Oracle Oracle Database 1Z0-060 Questions & Answers

• Question 11:

  The current system change number (SCN) for a live database is 663571.

  You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.

  After flashing back the CUSTOMERS table, you query it and decide to undo the effects of the FLASHBACK TABLE command.

  Which is the fastest way to do this?

  A. Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

  B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.

  C. Perform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

  D. Perform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

  Correct Answer: B

• Question 12:

  Which two statement are true about the installation modes in Oracle Database 12c? (Choose two.)

  A. In silent mode installation, you can validate the parameter values on installation screens for which you have provided information in the response file.

  B. In interactive mode, parameter values are read from a response file and can be changed during installation.

  C. Response file mode is useful when you require multiple Oracle Homes with variation in some of the installation parameters for each home.

  D. In response file mode, you can include responses for some or all prompts.

  Correct Answer: AD

• Question 13:

  Examine these parameters settings:

  

  What is true about the control file?

  A. The control file is multiplexed in the locations specified by DB_CREATE_ONLINE_LOG_DEST_1 and DB_CREATE_ONLINE_LOG_DEST_2.

  B. Only a single control file exists in the location specified by DB_CREATE_FILE_DEST.

  C. The control file is multiplexed in the locations specified by DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST.

  D. Only a single control file exists in the location specified by DB_RECOVERY_FILE_DEST.

  E. The control file is multiplexed in the locations specified by DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_1.

  Correct Answer: A

  Reference: https://docs.oracle.com/cd/E18283_01/server.112/e17120/omf005.htm

• Question 14:

  Which three statements are true about the use of the In-Database Archiving and Temporal Validity features of Oracle Database 12c? (Choose three.)

  A. Both Transaction Time and Temporal Validity time dimensions may be used as filters in the same query.

  B. Temporal Validity spans the time between a row insert and a subsequent update or delete for the same row.

  C. In-Database Archiving is based on application-managed setting of the life-cycle state.

  D. Temporal Validity time is based on the times specified by the application.

  E. Inactive rows that have been archived are always invisible.

  Correct Answer: ADE

  Reference: https://oracle-base.com/articles/12c/in-database-archiving-12cr1

• Question 15:

  Examine the parameters for your database instance:

  

  You generate an execution plan for this query and the plan table shows a nested loop join in the plan/

  

  After query execution, you see that a hash join was performed: What explain this optimizer behavior?

  A. It used SQL plan baselines for the query.

  B. It chose different plans because extended statistics were created on the filter columns.

  C. It chose different plans because automatic dynamic sampling was enabled.

  D. It used an adaptive execution plan.

  Correct Answer: C

• Question 16:

  You are connected to a multitenant container database (CDB) with DBA privileges.

  The STATISTICS_LEVEL parameter is PDB_MODIFIABLE.

  You issue:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;

  Which three effects does this have on the CDB and its pluggable databases (PDBs)? (Choose three.)

  A. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter has no value set.

  B. The STATISTICS_LEVEL parameter is immediately set to ALL in the CDB instance.

  C. The STATISTICS_LEVEL parameter is set to ALL on all PDBs when they are opened.

  D. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs.

  E. The STATISTICS_LEVEL parameter is set to ALL in the SPFILE.

  Correct Answer: ABC

• Question 17:

  Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

  A. You cannot have multiple SQL*Loader data files.

  B. The DEGREE_OF_PARALLELISM parameter is set to AUTO.

  C. If no data file is specified, it uses table-name.dat and assumes it is in the current directory.

  D. A new table is created and data is inserted into the table if it does not exist in a schema.

  Correct Answer: BC

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loaderexpress-mode.html#GUID-0F35B551-861B-450D-8BF3-2312893A67D7

• Question 18:

  While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAIL view was queried.

  How can you ensure that all available audit records are returned when the audit trail is queried?

  A. Query the v$UNIFIED_AUDIT_TRAIL view rather than the UNIFIED_AUDIT_TRAIL view.

  B. Enable the OS auditing option in the database before querying the UNIFIED_AUDIT_TRAIL view.

  C. Configure the IMMEDIATE write mode using the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL view.

  D. Execute the DBMS_AUDIT_MGMT.FLUSH_INIFIED_AUDIT_TRAIL procedure before querying the UNIFIED_AUDIT_TRAIL view.

  Correct Answer: D

  Reference: https://blogs.oracle.com/oraclemagazine/unify-auditing

• Question 19:

  You execute this piece of code with appropriate privileges:

  

  User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

  Which two statements are true when a session logged in as SCOTT queries the SAL columns in the view and the table?

  A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

  B. Data is never redacted on the EMP.SAL column.

  C. Data is redacted for the EMP.SAL column only if the SCOTT session has the MGR role set.

  D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

  E. Data is never redacted on the EMP_V.SAL column.

  Correct Answer: AE

• Question 20:

  Your multitenant container database (CDB) contains several pluggable databases (PDBs).

  A common user C##A_ADMIN, is created with connect privileges.

  You execute this command from the root container:

  SQL> GRANT create tablespace to C##A_ADMIN;

  Which statement is true?

  A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root container.

  B. The command fails because the CONTAINER=ALL clause is not used.

  C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root container as well as in the PDBs.

  D. The command fails because the CONTAINER=CURRENT clause is not used.

  Correct Answer: C