Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 151:

  In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT? (Choose three).

  A. redo logs

  B. control files

  C. all data dictionary metadata

  D. user-defined PL/SQL packages

  E. temporary tablespaces

  F. mandatory Oracle-supplied PL/SQL packages

  G. undo tablespaces

  Correct Answer: ABC

• Question 152:

  You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites? (Choose two).

  A. an operating system user to own this installation

  B. the Oracle Inventory group oinstall

  C. an operating system account called grid

  D. a group called dba

  E. the installation of Oracle ASMLIB

  Correct Answer: AB

• Question 153:

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

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

  B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

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

  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.

  Correct Answer: BC

• Question 154:

  Oracle Data Redaction is active on the SCOTT.EMP table.

  You queried the table twice.

  SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

  

  SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

  

  Which is guaranteed to be true concerning the redaction policy?

  A. FULL redaction is active on the SAL column

  B. RANDOM redaction is active on the MGR column

  C. RANDOM redaction is active on the HIREDATE column

  D. PARTIAL redaction is active on the MGR column.

  E. PARTIAL redaction is active of the HIREDATE column.

  Correct Answer: A

• Question 155:

  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 the root

  D. 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.

  Correct Answer: A

• Question 156:

  Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

  Which statement is true about the DUPLICATE command?

  A. It succeeds and creates multisection backup sets that are used for active database duplication.

  B. It fails because there is no connection to a recovery catalog.

  C. It succeeds only if the target database is in MOUNT state.

  D. It fails because no parallel channels are allocated for the auxiliary database.

  Correct Answer: A

• Question 157:

  Which two are benefits of unified auditing in full mode? (Choose two)

  A. All audit data is written to both the traditional locations and to the unified location.

  B. The audit trail is in a single format.

  C. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

  D. The audit trail is read-only.

  E. The audit trail uses less space.

  Correct Answer: BD

• Question 158:

  Examine this configuration:

  1.

  CDB1 is a container database.

  2.

  APP1_ROOT is an application container contained in CDB1.

  3.

  APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT.

  4.

  APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT.

  5.

  APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.

  6.

  USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed.

  You execute these commands:

  $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

  SQL> ALTER

  SESSION SET CONTAINER=app1_root; Session altered.

  SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered.

  SQL> GRANT CREATE SESSION TO USER1; Grant succeeded.

  SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0'; Pluggable database altered

  SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered.

  SQL> ALTER

  Which two are true? (Choose two).

  A. APP1_USER1 can be created in PDB1.

  B. USER1 can connect to APP1_ROOT and APP1_PDB1.

  C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

  D. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

  E. C##_APP_USER1 can be created in CDB1.

  Correct Answer: AE

• Question 159:

  Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

  A. Tables or table partitions can be recovered by using an auxiliary instance only.

  B. Tables or table partitions with a foreign key cannot be recovered.

  C. Tables or table partitions can be recovered only when the database is in mount state.

  D. Tables or table partitions from the system and sysaux table spaces cannot be recovered.

  E. Tables with not null constraints cannot be recovered.

  Correct Answer: AD

  Reference: http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695 (Limitations of Recovering Tables and Table Partitions from RMAN Backups)

• Question 160:

  For which two tasks can you use the DBMS_PDB.DESCRIBE procedure? (Choose two).

  A. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

  B. to generate an XML metadata file from any unplugged PDB

  C. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

  D. to generate a . pdb archive file for any PDB in the current CDB

  E. to generate an XML metadata file that describes the current plugged-in PDB

  Correct Answer: AE