Oracle 1Z0-083 Quiz 7 Topic 2 Questions 31-35

Question: 1

Which three are true about the Oracle Optimizer? (Choose three.)

AIt obeys all hints.

BIt considers the filters in WHERE clauses when generating execution plans for SQL statements.

CIt can re-optimize execution plans after previous executions detect suboptimal plans.

DIt considers object statistics when generating execution plans for SQL statements.

EIt updates stale object statistics in the Data Dictionary.

FIt can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

Show Answer

Question: 2

RMAN has just been connected to a target database and the recovery catalog database.

In which two cases would an automatic full resynchronization occur between this target database's control file

and the RMAN recovery catalog? (Choose two.)

Awhen control file metadata for archive log backups or image copies has been overwritten in the target
database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

Bwhen control file metadata for data file backups or image copies has been overwritten in the target
database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

Cwhen a new tablespace is added to a registered target database

Dwhen a backup of the current control file is created

Ewhen the target is first registered

Show Answer

Question: 3

Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

AA table's constraints must be disabled before issuing the flashback.

BThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the
user performing the flashback.

CA table's indexes must be set to unusable before issuing the flashback.

DRow Movement must be enabled on the table being flashed back.

EThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the
table owner.

Show Answer

Question: 4

Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?

(Choose two.)

AEach of the file sections must be processed serially.

BThe four sections can be created serially.

CThe four sections must be image copies.

DThe four sections can be created in parallel.

EThe four sections must be contained in backup sets.

Show Answer

Question: 5

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of

the SALES_APP application.

Examine these steps:

1. Install the SALES_APP application, including the common tables, in the application root.

2. Install the SALES_APP application in the application root and the common tables in both the CDB root and

the application root.

3. Create an application seed.

4. Install the SALES_APP application in the application seed.

5. Create the SALES_APP1 and SALES_APP2 application PDBs.

6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

8. Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

A3, 4, 1, 6, 8

B2, 5, 6

C1, 5, 6

D1, 3, 5, 6, 7

E1, 3, 5, 7

Show Answer

Oracle 1Z0-083 Quiz:7 Topic:2 Questions:31-35