Online Access Free 1Z1-083 Practice Test

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A.Data file 24 can be restored only while connected to CDB$ROOT.
• B.Data file 24 can be recovered while connected to CDB$ROOT.
• C.Data file 24 can be restored only while connected to PDB2.
• D.Data file 24 can be recovered only while connected to PDB2.
• E.Data file 24 can be restored and recovered while connected to CDB$ROOT.
• F.Data file 24 can be recovered while connected to PDB2.

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

• A.Installing a patchset is considered an "upgrade".
• B.They are installed via OPatch or OPatchAuto.
• C.A base release is not needed to install patchsets.
• D.They are only released quarterly.
• E.They can be applied in a rolling fashion for Clusterware and the databases.
• F.They can introduce new features.

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

• A.five
• B.three
• C.six
• D.seven
• E.eight

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?

• A.The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• B.The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
• C.TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.
• D.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
• E.The C # # A_ADMIN user can perform wallet operations.

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

• A.It requires only local undo mode in the database where the application container will be unplugged.
• B.It requires local undo mode in both container databases.
• C.Unplugging the application root from a CDB unplugs all its application PDBs.
• D.Plugging the application root into a different CDB plugs In all its application PDBs.
• E.The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
• F.Application PDBs In the applic tion container must be unplugged before the application root Is unplugged.