You performed the

第1题：

Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

• A、You can perform online whole database backups.
• B、You can performofflinewhole database backups.
• C、You cannot perform schema-level export/import operations.
• D、You can perform the backup of only the SYSTEM tablespace when the database is open.

第2题：

You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

• A、 The backup will not be performed at all.
• B、 three times
• C、 four times
• D、 six times

第3题：

第4题：

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

第5题：

What happens when you run the SQL Tuning Advisor with limited scope？（）  

• A、 Access path analysis is not performed for SQL statements.
• B、 SQL structure analysis is not performed for SQL statements.
• C、 SQL Profile recommendations are not generated for SQL statements.
• D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

第6题：

You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）

• A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.
• B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
• C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
• D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

第7题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第8题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第9题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

• A、 The time when the last flashback operation in your database was performed.
• B、 The time when the first flashback operation in your database was performed.
• C、 A list of flashback operations performed in your database using SCN and time.
• D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

第10题：

You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）

• A、 LOGGING_OFF
• B、 LOGGING_RUNS
• C、 LOGGING_FULL
• D、 LOGGING_NULL