Oracle 1Z0-083 Quiz 12 Topic 2 Questions 56-60

Question: 1

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

AThey are generated if STATISTICS_LEVEL is set to TYPICAL.

BThey are generated if STATISTICS_LEVEL is set to ALL.

CThey are always created automatically.

DThey are always created manually.

EThey can be retained forever.

FThey are generated if STATISTICS_LEVEL is set to BASIC.

Show Answer

Question: 2

Which three are true about using Database Resource Manager in an Oracle multitenant environment?

(Choose three.)

AA PDB-level resource plan can limit session PGA memory.

BA CDB-level resource plan can limit PDB CPU utilization.

CA CDB-level resource plan can limit session CPU utilization.

DPDB-level resource plans can limit uncommitted UNDO per consumer group.

EA CDB-level resource plan can limit PDB UNDO use.

FA CDB-level resource plan is mandatory when using PDB-level resource plans.

Show Answer

Question: 3

In which two situations can you use Database Upgrade Assistant? (Choose two.)

Awhen the operating system (OS) needs to be changed as part of the upgrade

Bwhen a character set conversion is required during the upgrade

Cwhen multiple pluggable databases in a container database have to be upgraded in a specific sequence

Dwhen the target and source database are on the same platform

Ewhen the hardware platform needs to be changed as part of the upgrade

Show Answer

Question: 4

Which two are true about the Program Global Area (PGA) and its management in an Oracle database

instance? (Choose two.)

AThe private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

BPGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

CThe entire PGA is located in the System Global Area (SGA) when using shared servers.

DSorts and Hash Joins use PGA memory.

EThe private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

Show Answer

Question: 5

Which two are true about RMAN backups when using a media manager? (Choose two.)

AA media manager always writes RMAN requested backups to tape.

BBy default, a request for a proxy copy may result in a backup set being created.

CA media manager is required to create RMAN proxy copies.

DA media manager is required to create RMAN image copies.

EThe media manager layer (MML) routines provided by Oracle support any vendors' media management
products.

Show Answer

Oracle 1Z0-083 Quiz:12 Topic:2 Questions:56-60