Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 101:

  A redaction policy was added to the SAL column of the SCOTT.EMP table:

  

  All users have their default set of system privileges.

  For which three situations will data not be redacted? (Choose three.)

  A. SYS sessions, regardless of the roles that are set in the session

  B. SYSTEM sessions, regardless of the roles that are set in the session

  C. SCOTT sessions, only if the MGR role is set in the session

  D. SCOTT sessions, only if the MGR role is granted to SCOTT

  E. SCOTT sessions, because he is the owner of the table

  F. SYSTEM session, only if the MGR role is set in the session

  Correct Answer: ABD

• Question 102:

  You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

  A. Database Replay

  B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

  C. Active Session History (ASH) report

  D. SQL Performance Analyzer

  Correct Answer: B

• Question 103:

  You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB.

  Which three methods can you use? (Choose three).

  A. Data Pump full database export and import

  B. cloning the non-CDB as a PDB

  C. replication using GoldenGate

  D. Data Pump transportable tablespaces

  E. Data Pump full transportable database

  F. the DBMS_PDB package

  Correct Answer: CDE

• Question 104:

  Which three actions are mandatory post database upgrade? (Choose three).

  A. Updating client scripts with the new Oracle home.

  B. Resetting passwords to enforce case-sensitivity.

  C. Run OPatch commands from the new Oracle home.

  D. Setting threshold values for table space alerts.

  E. Migration to unified auditing.

  F. Upgrading user tables that depend on Oracle-maintained abstract data types.

  Correct Answer: ACF

• Question 105:

  You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded.

  Sometimes you are not able to connect to the instance because it hangs.

  You do not want to restart the database instance. How can you detect the cause of the degraded performance?

  A. Enable Memory Access Mode, which reads performance data from SGA.

  B. Use emergency monitoring to fetch data directly from SGA for analysis.

  C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

  D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

  E. Run ADDM in diagnostic mode.

  Correct Answer: B

  The Emergency Monitoring feature of Enterprise Manager Cloud Control 12c is an evolution of Memory Access Mode from Grid Control 11g, allowing you to access in-memory statistics. In EM12c you no longer need to explicitly enable memory access mode. Just navigate to the page and wait while it makes a diagnostic connection to the database and performs lightweight analysis. The screen contains information that will help analyze performance issues, even if the database is hung and you can't connect to the normal performance pages.

• Question 106:

  Which two statements are true about RMAN duplexed backups?

  A. It is not supported for image copies.

  B. It is only supported for backups to tape via the media management interface.

  C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

  D. Duplex backups can contain only data files and control files.

  E. For performing duplexed backups, the parallelism for the device must be set equal to the number copies.

  Correct Answer: AC

• Question 107:

  Which three are true about unified auditing in full mode? (Choose three)

  A. The unified audit trail is written to a read-only table.

  B. The unified audit trail is written to a read-only external file.

  C. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

  D. Audit records are created for SYS.

  E. Audit records are created for non-sys users.

  Correct Answer: ADE

• Question 108:

  Examine the RMAN command:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1,4,5 CHANNEL c1)

  (DATAFILE 2,3,9 CHANNEL c2)

  (DATAFILE 6,7,8 CHANNEL c3);

  SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement is true about the command?

  A. The RMAN multiplexing level is 4.

  B. It is the use of asynchronous I/O by RMAN.

  C. It is a case of parallelization of the backup set.

  D. It is an implementation of a multisection backup.

  Correct Answer: C

• Question 109:

  Examine this configuration:

  1.

  CDB1 is a container database.

  2.

  DEFAULT_SHARING is METADATA.

  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. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

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

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

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

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

  Correct Answer: D

• Question 110:

  You want to duplicate one of your databases when connected to the target database and to the recovery catalog.

  Which three are true about this type of database duplication? (Choose three)

  A. The target database must be open

  B. The duplication process can use existing backup sets or image copies

  C. The duplication process can use existing backup sets or image copies.

  D. The target database must be in mount state.

  E. The duplication -process pushes backup sets to the auxiliary instance.

  F. The duplication process pushes image copies to the auxiliary instance.

  Correct Answer: ACF