Oracle 1Z0-083 Quiz 15 Topic 8 Questions 71-75

Question: 1

Which two are true about backup set compression using RMAN default compression? (Choose two.)

ACompressed backups can be written only to media.

BBinary compression adds CPU overhead to backup operations.

CUnused blocks below the high water mark are backed up.

DCompressed backups cannot have a section size defined.

ECompression can be done only for locally managed tablespaces.

Show Answer

Question: 2

Which two are true about memory advisors? (Choose two.)

AIf Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always
available.

BIf Automatic Memory Management is enabled, no memory advisors are available.

CAll memory advisors use data from Automatic Workload Repository.

DIf Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache
Advisor are available.

EIf Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are
available to set the maximum size for these individual System Global Area components.

Show Answer

Question: 3

Which three are true about patchsets? (Choose three.)

AThey can be applied in a rolling fashion for Clusterware and the databases.

BThey can introduce new features.

CThey are installed via OPatch or OPatchAuto.

DInstalling a patchset is considered an ''upgrade''.

EThey are only released quarterly.

FA base release is not needed to install patchsets.

Show Answer

Question: 4

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

AFLASHBACK LOGS are archived after a log switch.

BA database can be flashed back using SQL*PLUS.

CQueries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

DFLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

EIt always generates REDO and UNDO.

FIt requires that the target database be in ARCHIVELOG mode.

Show Answer

Question: 5

Which three are true about an application container? (Choose three.)

AIt can contain a single application.

BIt can contain multiple applications.

CIt must have an application seed PDB.

DIt must have an application root PDB.

ETwo application containers can share an application seed PDB.

FAn application PDB can belong to multiple application containers.

Show Answer

Oracle 1Z0-083 Quiz:15 Topic:8 Questions:71-75