单选题Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every  Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE；  Table dropped.  Client B executes a query at 9：0

第1题：

Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1：  ORA/x7f00942： table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）

• A、retrieve the table by using the flashback feature
• B、restore all the data files from last Sunday’s backup， and then perform a time­based recovery
• C、restore all the data files from last Sunday’s backup， and then perform a log sequence recovery
• D、restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery
• E、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery

第2题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp； Table dropped.  What happens in this scenario？ （）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第3题：

You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

• A、SQL Access Advisor
• B、 Memory Advisor
• C、SQL Tuning Advisor
• D、 Segment Advisor

第4题：

User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

• A、It fails to delete the records because the records are locked in SHARE mode.
• B、It deletes the rows successfully because the table is locked in SHARE mode
• C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
• D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

第5题：

Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every  Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE；  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord；  SELECT * FROM cust_ord  *ERROR at line 1：ORA-00942： table or view does not exist  Client B needs the dropped table and reports the problem to you.With reference to this scenario， which action should you take？（）

• A、 retrieve the table by using the flashback feature
• B、 restore all the data files from last Sunday’s backup and then perform a time-based recovery
• C、 restore all the data files from last Sunday’s backup and then perform a log sequence recovery
• D、 restore all the data files from last Sunday’s backup and then perform a cancel-based recovery
• E、 restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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；

第14题：

You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

• A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
• B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
• C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
• D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
• E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

第15题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

• A、 UNTIL SEQUENCE
• B、 UNTIL SCN
• C、 UNTIL CHANGE
• D、 UNTIL CANCEL

第16题：

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

• A、 incomplete recovery
• B、 complete recovery
• C、 recovery using the Flashback Database feature
• D、 recovery using the export/import utility

第17题：

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

• A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
• B、 restore the entire database from the most recent backup and open it
• C、 recover the table by using the Flashback Table feature
• D、 perform point-in-time recovery to recover the table

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：