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: Apr 09, 2021

Add To Cart

Question 1

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

A :

A non-CDB can be cloned into a PDB.

B :

A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

C :

Only one PDB can be cloned at a time.

D :

Two or more PDBs can be cloned with the same command.

E :

A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F :

The target and auxiliary instance passwords must be the same.

Answer: A,B,C

Question 2

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

Question 3

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADAT 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A : L will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B : L will be added to APP_PDB1.EMP, with NULLs in columns of existing rows

C : will return an error because the SYNC operation is not allowed when constraints are added to common objects.

D : will return an error because EMP is not empty in APP_ROOT.

E : will return an error because EMP.SAL is empty in APP_ROOT.

Answer: D

Question 4

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 5

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

A : data dictionary in CDB$ROOT

B : log writer process (LGWR)

C : SYSAUX tablespaces

D : mporary tablespaces

E : Process Monitor Process (PMON)

F : do tablespaces

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart