Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Feb 21, 2026

Add To Cart

Question 1

Choose three. Which three are true about a container database (CDB)?

A : It can be created from a non-CDB.

B : It can contain only one PDB$SEED, which is created when the CDB is created.

C : It can have local users with the same name in different PDBs.

D : It can contain only one Application Container seed, which is created when the Application Container is created.

E : It can be created by cloning an existing CDB.

F : It can have any number of pluggable databases (PDBs) limited only by space availability.

G : It contains predefined common roles in both the root and the seed.

Answer: A,B

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?

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 two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path destinationhome Oracle_home_path For which two purposes can you use this command?

A : to switch to a patched Oracle Database home

B : to upgrade an Oracle Database on the centralized Rapid Home Provisioning server

C : to move an Oracle Database to the centralized Rapid Home Provisioning server

D : to switch back to the previous Oracle home as part of a rollback operation

E : to switch to a read-only Oracle home

Answer: A,B

Question 4

T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

A : Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B : Recovery catalog is resynchronized with the control files of the registered databases.

C : Imported databases are unregistered from the RC11 catalog.

D : Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

E : All databases registered in the RC11 catalog are registered in the RC12C catalog.

Answer: A,D

Question 5

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

A : It fails because Data Pump cannot be container.

B : It creates a full export of the root

C : It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

Answer: A

Page: 1 / 57

Total 285 Questions | Updated On: Feb 21, 2026

Add To Cart