1z0-083 Practice Test

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

A.

By default, AWR snapshots are taken every 60 minutes.

B.

Its collection level is determined by the value of theSTATISTICS_LEVEL database parameter

C.

By default, AWR snapshots are retained for 7 days.

D.

The taking of AWR snapshots can be disabled.

E.

AWR data is stored in the SYSTEM tablespace

Which two are true about RMAN duplexed backup sets? (Choose two.)

A.

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the
same number of files.

B.

A non-duplexed backup set written to disk can be duplexed to disk bybacking up the backup set that is
already on disk.

C.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is
already on tape.

D.

A non-duplexed backup set written to disk can be duplexed to tape by backing upthe backup set that is
already on disk.

E.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is
already on tape.

F.

A duplexed backup set always uses twice as many SBT channels as a non-duplexedbackup set for the
same number of files.

You are managing this configuration:
CDB1is a container database.
PDB1andPDB2are two pluggable databases inCDB1.
USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2.
CDB1userSYSexecutes these commands after connecting successfully toPDB2:

Which two are true? (Choose two.)

A.

The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

B.

The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

C.

The insert on USER2.DEPT fails because of the active transaction in the parent container.

D.

The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is
committed.

E.

The inserts on USER1.EMP were rolled back when the session connected to PDB2.

F.

The insert on USER2.DEPT is uncommitted

G.

The inserts on USER1.EMP were committed when the session connected to PDB2

Examine this configuration:

What will be the outcome?

A.

It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’

B.

It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.

C.

It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’

D.

It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.

E.

It will fail because there is no autobackup of the controlfiles.

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A.

It includes both Oracle Restart and OracleAutomatic Storage Management (ASM) software.

B.

It creates one disk group during installation.

C.

It requires the operating system oracle_base environment variable to be predefined before installation

D.

It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM)
disks

E.

It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.

F.

Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as
secondary groups for its installationowner.