Question 1

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

Options :

A : A PDB snapshot is always a full copy of the source PDB.

B : A PDB snapshot is always a sparse copy of the source PDB.

C : A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D : A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E : A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F : A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G : A snapshot copy PDB can be created from a stand-alone clone PDB.

Answer: A,C

Question 2

Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?

Options :

A : TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.

B : The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker

C : The C # # A_ADMIN user can perform wallet operations.

D : The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

E : The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Answer: A,B,D

Question 3

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

Options :

A : the data dictionary in CDB$ROOT

B : the log writer process (LGWR)

C : SYSAUX tablespaces

D : temporary tablespaces

E : the Process Monitor Process (PMON)

F : undo tablespaces

Answer: A,B

Question 4

Choose three. Which three are true about recovering tables using RMAN?

Options :

A : RMAN can recover tables owned by the SYSTEM user.

B : RMAN can recover tables owned by the SYS user.

C : RMAN can recover tables in the SYSTEM tablespace.

D : RMAN always uses an auxiliary instance.

E : RMAN can recover a table after a DDL operation has altered the table structure

F : RMAN can recover tables in the SYSAUX tablespace.

G : RMAN can recover tables in a standby database.

Answer: A,D

Question 5

Which two are true about common objects? (Choose two.)

Options :

A : They can be created only in CDB$ROOT.

B : They can be only metadata-linked in an application container.

C : They can exist in user-defined schemas only in application containers.

D : They can exist in CDB$ROOT and an application root.

E : They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Answer: D

Higher Test Marks with Free Online 1Z0-083 Exam Practice

Buying Options: