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: Mar 27, 2025

Add To Cart

Question 1

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

A : can be created from a non-CDB.

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

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

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

E : can be created by cloning an existing CDB.

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

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

Answer: A,B

Question 2

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 : will return an error because creation of a local role is not allowed in CDB$ROOT.

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

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

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

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

Answer: A

Question 3

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

A : B2 will be opened READ WRITE.

B : B1 will be opened READ WRITE.

C : B1 will be MOUNTED.

D : B$SEED will be opened READ ONLY.

E : B$SEED will be MOUNTED

F : B2 will be MOUNTED.

Answer: A,B,D

Question 4

Which three statements are true about Flashback Data Archive?

A : use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

B : enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

C : ile enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

D : table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

E : ashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Answer: A,C,D

Question 5

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

A : allow database duplication without a connection to the target instance

B : store backup metadata that would cause the controlfile to become too large.

C : to store backups that would cause the controlfile to become too large

D : report on the database schema at an earlier point in time.

E : allow database duplication without a connection to the auxiliary instance.

Answer: A,B,D

Page: 1 / 57

Total 285 Questions | Updated On: Mar 27, 2025

Add To Cart