You&ensp;are&ensp;working&ensp;as&ensp...

单项选择题 You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200.
The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：
SQL>UPDATE EMPLOYEE SET SALARY = 2000
WHERE EMPNO = ’E0025’；
SQL>COMMIT；
On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：
SQL>UPDATE EMPLOYEE SET SALARY = 2400
WHERE EMPNO = ’E0025’；
SQL>COMMIT；
On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’
SQL>UPDATE EMPLOYEE SET SALARY = 2900
WHERE EMPNO = ’E0025’；
SQL>COMMIT；
On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）

A. Flashback Drop
B. Flashback Table
C. Flashback Database
D.Flashback Version Query

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）

A. Flashback Drop
B. Flashback Database
C. Flashback Table
D. Flashback Version Query

点击查看答案

2.多项选择题 You issued the following command：
SQL> DROP TABLE MYTABLE；
SQL> SHOW RECYCLEBIN The following output is returned：
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
------------- ------------------------------ --------------- --------------------
MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE
2005-01-13：20：11：31 You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

A. DROP TABLE MYTABLE PURGE；
B. PURGE RECYCLEBIN；
C. PURGE TABLE MYTABLE；
D. PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

点击查看答案

3.多项选择题You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？（）

A. RESETLOGS
B. TO TIMESTAMP
C. TO BEFORE DROP
D. RENAME TO
E. TO SCN

点击查看答案

4.单项选择题 You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace. The following dependent objects have been defined on the dropped table：

Due to limited space， some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement： SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP；
What will be the implication of executing this statement？（）

A. Only the WAREHOUSE_DETAILS table is recovered， and none of the dependent objects are recovered.
B. The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints， primary key constraint， and the referential integrity constraints.
C. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.

点击查看答案

5.多项选择题On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）

A. by using Oracle Enterprise Manager
B. by issuing the FLASHBACK TABLE statement at the RMAN prompt
C. by issuing the FLASHBACK TABLE statement at the SQL prompt
D. by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

点击查看答案

6.单项选择题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

A. You must use automatic undo management in the database.
B. You must configure OMF in your database.
C. You must configure ASM for storing the datafiles.
D. You must multiplex the online redo log file.

点击查看答案

7.单项选择题 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.

点击查看答案

8.单项选择题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 transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）

A. Only the Flashback Table
B. Both the Flashback Transaction Query and the Flashback Version Query
C. Only the Flashback Drop
D. Only the Flashback Version

点击查看答案

9.单项选择题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

点击查看答案

10.单项选择题You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）

A. Flashback Table
B. Flashback Query
C.Flashback Version Query
D. Flashback Transaction Query

点击查看答案