单选题You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the tran

第1题：

At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

• A、 William used the Flashback Version Query feature.
• B、 William issued the CROSSCHECK command at the RMAN prompt.
• C、 William viewed the alert log file.
• D、 William used the Flashback Table feature.

第2题：

You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

• A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
• B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
• C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
• D、 You cannot shrink the SCOTT.EMP table.

第3题：

You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）

• A、 The statement will not execute successfully.
• B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days
• C、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.
• D、 Backups will be deleted from the media after 400 days.

第4题：

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

• A、 Create a FOR trigger. 
• B、 Create an INSTEAD OF trigger. 
• C、 Create an AFTER trigger. 
• D、 Create a DDL trigger.

第5题：

You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

• A、Custom event handlers
• B、Data flow error output
• C、SSIS log provider for SQL Server
• D、Execute SQL tasks with failure precedence constraints

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In which scenario will you use the Flashback Transaction Query feature？（）

• A、 when you want to restore an important table that is dropped from the Recycle Bin
• B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
• C、when you want to restore a dropped user’s schema
• D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

第14题：

At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group populated?（）

• A、When the user navigates to the HOTEL item. 
• B、When the form module successfully compiles. 
• C、After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. 
• D、When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES. 

第15题：

You work as the enterprise exchange administrator at Xxx .Xxx is using Microsoft Exchange Server 2010 as their messaging solution.You have received instructions from the CIO to enable Autodiscover for Internet users by creating a resource record in DNS.What actions must you take？（）

• A、You must set up recipient filtering.
• B、You must set up a Host （A）.
• C、You must use a TXT record.
• D、You must use a Pointer （PTR） record.
• E、You must use a Mail exchange （MX） record.

第16题：

You have an Exchange Server 2010 organization.You need to create a resource record in DNS to support Autodiscover from the Internet.What type of resource record should you create？（）

• A、Host（A）
• B、Text（TXT）
• C、Pointer（PTR）
• D、Mail exchange（MX）

第17题：

You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）

• A、You should consider creating a Host （A） resource record.
• B、You should consider creating a Text （TXT） resource record.
• C、You should consider creating a Pointer （PTR） resource record.
• D、You should consider creating a Mail exchange （MX） resource record.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：