单项选择题
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
相关考题
-
单项选择题
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted. -
多项选择题
Whichstatementsaretrueregardingthesystem-definedmovingwindowbaselineinOracleDatabase11g？（）
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）. -
单项选择题
You issue the following RMAN command to set a retention policy on a database： RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of issuing this command？（）
A. After two days，a backup will be marked obsolete
B. After two days，a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
