WhichpackageprovidesAPI’sfortheSQLTuningAdvis

You create two resource plans，one for data warehouse lo...

单项选择题

You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.
How would you achieve this？（）

A. Implement job classes
B. Implement Scheduler windows
C. Implement the mapping rule for the consumer groups
D. Set the SWITCH_TIME resource plan directive for both the resource plans

TheDB_BLOCK_CHECKINGinitializationparameterissettoOFF.W...

单项选择题The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）

A. The Oracle database will perform block checking for the index blocks only
B. The Oracle database will not perform block checking for any of the data blocks
C. The Oracle database will perform block checking for the default permanent tablespace only
D. The Oracle database will perform block checking for the data blocks in all user tablespaces
E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

A database is running in ARCHIVELOG mode and regular ba...

单项选择题

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message：

Which is the recommended sequence of operations you need to perform for the query successfully？（）

A. Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.
B. Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.
C. Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.

1Z0-053

Which package provides API’s for the SQL Tuning Advisor？（）