Free Practice Oracle 1Z0-083 Exam Questions 2025

Stay ahead with 100% Free Oracle Database Administration II 1Z0-083 Dumps Practice Questions

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart

Question 1

choose two Which two are true about RMAN image copies?

A : They can only be written to disk.

B : They can be encrypted using Transparent Data Encryption (TDE).

C : They can be used as a level 0 incremental backup.

D : They can be used as a level 1 incremental backup.

E : They are the only backup option available for databases in NOARCHIVELOG mode.

Answer: A,C

Question 2

Choose two. Which two statements are true when row-archival management is enabled?

A : The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.

B : The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query

C : The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D : The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

E : The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

Answer: B,C

Question 3

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 4

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

A : PDB1 and PDB2 are in MOUNT state.

B : Redo logs are opened.

C : PDB1 and PDB2 are in READ ONLY state.

D : CDB$ROOT is in MOUNT state.

E : PDB$SEED is in READ ONLY state.

Answer: A,D

Question 5

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.
COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A : It will return an error because creation of a local role is not allowed in CDB$ROOT.

B : ROLE1 will be created only in CDB$ROOT.

C : It will return an error because common roles must start with C##.

D : ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E : ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Answer: A

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart