Free Oracle 1Z0-083 Exam Questions
Try our Free Demo Practice Tests for Comprehensive 1Z0-083 Exam Preparation
-
Oracle 1Z0-083 Exam Questions
-
Provided By: Oracle
- Exam: Oracle Database Administration II
- Certification: Oracle Database
-
Total Questions: 285
-
Updated On: Apr 16, 2025
-
Rated: 4.9 |
-
Online Users: 570
-
Question 1
-
choose two Which two are true about RMAN image copies?
Answer: A,C
-
choose two Which two are true about RMAN image copies?
-
Question 2
-
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?
Answer: D
-
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?
-
Question 3
-
Choose three. Which three are true about a whole database backup?
Answer: C,D,E
-
Choose three. Which three are true about a whole database backup?
-
Question 4
-
Choose three. Which three are true about cloning databases into an existing CDB with RMAN?
Answer: A,B,C
-
Choose three. Which three are true about cloning databases into an existing CDB with RMAN?
-
Question 5
-
choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
Answer: A,B,D
-
choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).