A.It can configure Automatic Storage Management (ASM) diskgroups.

B.It can generate SQL database creation scripts.

C.It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

D.It can be used to add a new tablespace.

E.It can be used to create a database template from an existing database.

A.All archive logs created after this backup are kept for two years.

B.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C.The SPFILEis included in the self-contaied archival backup.

D.The restore point is a label for the system change number (SCN) before the archival backup was taken.

E.The control file is included in the self-contained archival backup.

F.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

A.SQL statements should always be tuned before tuning any file systems.

B.Tuning activities should stop onceagreed service levels for performance have been met.

C.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

D.Tuning activities should stop once the user is satisfied with performance.

E.The alert log should be used to find the database and instance areas most in need of tuning.

F.The database instance memory should always be tuned before tuning any file systems.

A.Oracle DBCA templates can store only logical structure and not database files.

B.New templates can only be created by modifying an existing user-created template.

C.The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

D.Oracle DBCAtemplates can be used to create new databases and duplicate existing databases.

E.The Data Warehouse template is most suitable when transaction response time is the key criterion.

A.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

B.It is performed by the Recovery Writer (rvwr) background process.

C.Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.

D.It is performed automatically while the database remains in mount state. Then the database is opened.

E.Setting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

F.It is not possible if an archived log is missing.