Oracle 1Z0-083 Quiz 24 Topic 4 Questions 116-120

Question: 1

Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

ARMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

BThe undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.

CRMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

DThe undo tablespace clause is always required when no connection exists to the target instance.

ERMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Show Answer

Question: 2

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?

ASBT tape compression can be used even if no RMAN compression is configured.

BAny backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

CAny backup written to the SBT device in this configuration can contain a maximum of two backup sets.

DSBT tape compression and RMAN backup compression should be used in parallel.

EThe SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously

Show Answer

Question: 3

Which two are true about the Oracle database tuning methodology?

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

BTuning activities should stop once the user is satisfied with performance.

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

DSQL statements should always be tuned before tuning any file systems.

ETuning activities should stop once agreed service levels for performance have been met.

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

Show Answer

Question: 4

Examine this output:

q4_1Z0-083

Which two are true?

AAny PDB not specified in the plan will be unable to execute statements in parallel.

BPDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

CAny PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

DPDB3 can use all available parallel execution processes at times.

EPDB1 is always limited to 40% of the available system resources regardless of demand.

FPDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Show Answer

Question: 5

Which two are true about gathering optimizer statistics?

AExecuting dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.

BSystem statistics can be gathered only while connected to cdb$root.

CExecuting dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).

DExecuting dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.

EExecuting dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.

Show Answer

Oracle 1Z0-083 Quiz:24 Topic:4 Questions:116-120