Oracle 1Z0-083 Quiz 17 Topic 1 Questions 81-85

Question: 1

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

q1_1Z0-083

Which three are true?

AAPP1 can never be unplugged.

BApplication PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

CAn application seed PDB Is created for APP1.

DApplication PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

EAn application root PDB is created for APP1.

FA default service Is created for the application root APP1.

Show Answer

Question: 2

Which two are true about Oracle Optimizer Statistics, their use, and their collection?

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

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

CIndex balanced B*Tree height is considered when evaluating the cost of using an index,

DThe Statistics Advisor generates actions for all recommendations.

EStatistics collected using DBMS_ATATS always yield the best optimizer result.

Show Answer

Question: 3

Which two are true about the SQL Tuning Advisor?

AIt prevents performance regressions for SQL statements when changes are made.

BIt only recommends syntactic changes to SQL statements.

CIt can recommend semantic changes to SQL statements.

DIt considers all SQL statements being analyzed by the advisor task as a group.

EIt checks each query being analyzed for missing or stale statistics.

Show Answer

Question: 4

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

AThe Pre-Upgrade Information Tool script is executed by DBUA.

BDBUA must be launched from the target Oracle Home.

CAll pluggable databases are automatically upgraded as part of a container database upgrade.

DA whole database backup must exist before upgrade

EThe database must be opened in read-only mode.

FMultiple databases with the same ORACLE_HOME can be upgraded simultaneously.

Show Answer

Question: 5

A schema owner truncated a table in error and must recover the data.

Which Oracle Flashback feature could be used to recover the data?

AFLASHBACK TRANSACTION

BFLASHBACK VERSION QUERY

CFLASHBACK DATA ARCHIVE

DFLASHBACK TABLE

EFLASHBACK DATABASE

Show Answer

Oracle 1Z0-083 Quiz:17 Topic:1 Questions:81-85