A.The number of table rows is considered when evaluating the cost of accessing a table using an index.

B.Index balanced B*Tree height is considered when evaluating the cost of using an index.

C.The Statistics Advisor can help recommend the best way to gather statistics.

D.Statistics collected using DBMS_STATS always yield the best optimizer result.

E.The Statistics Advisor generates actions for all recommendations.

A.Oracle DBCA templates can be used to create new databases and duplicate existing databases.

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

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

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

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

A.FLASHBACK DATA ARCHIVE

B.FLASHBACK DATABASE

C.FLASHBACK TRANSACTION

D.FLASHBACK VERSION QUERY

E.FLASHBACK TABLE

A.Backups must be contained in backup sets.

B.Backups can be taken only if the database is in archivelog mode.

C.Backups must be done incrementally.

D.The database must be registered in an RMAN catalog.

E.Backups can be done incrementally.

F.Only consistent backups can be created.

A.Run the SQL Tuning Advisor.

B.Run the Memory Advisor for the shared pool.

C.Run the Memory Advisor for the System Global Area.

D.Run the Memory Advisor for the Program Global Area.

E.Run the SQL Access Advisor.