Oracle Oracle Database 1Z0-060 Questions & Answers

• Question 51:

  Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.

  A. Create a SYSMAN user with the SYSDBA role as an administrator for EM express.

  B. Configure the DISPATCHERS initialization parameter such that at least one dispatcher is configured for the XMLDB service with the TCP protocol.

  C. Install the Oracle HTTP Server.

  D. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure port number 5500 for the HTTP server.

  Correct Answer: D

  Execute the DBMS_XDB_CONFIG.SETHTTPSPORT procedure. Reference: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-em-databaseexpress-12c.html

• Question 52:

  Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases.

  You issue the following commands and get an error:

  

  Examine the following commands: Identify two correct sequences of commands to perform a recovery and make the data available.

  

  A. 1,2,3,4,7,8

  B. 1,2,5,6,7,8

  C. 1,2,10,5,6,9

  D. 10,3,4,8,9

  Correct Answer: BC

• Question 53:

  In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.

  Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

  A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

  B. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

  C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

  D. Setting the target tablespace to read-only after the segments are moved

  E. Taking the target tablespace offline after the segments are moved

  Correct Answer: CD

• Question 54:

  Which two are true concerning a multitenant container database with three pluggable databases?

  A. Pluggable databases in the same container database (CDB) each have their own buffer cache

  B. Pluggable databases can make database consolidation easier

  C. All administration tasks must be done to each pluggable database.

  D. Pluggable databases increase patching time.

  E. Pluggable databases are patched together

  Correct Answer: BE

• Question 55:

  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 56:

  Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

  A. reduced CPU utilization

  B. reduced physical I/O

  C. improved Serial Execution performance

  D. reduced logical I/O

  E. reduced virtual memory utilization

  Correct Answer: AE

• Question 57:

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

  A. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

  B. Visibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

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

  E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

  Correct Answer: AD

• Question 58:

  To complete the online redefinition procedure, you execute the following command;

  EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(`SH', `SALES', `INT_SALES', 600);

  What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

  A. All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.

  B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.

  C. All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.

  D. It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.

  Correct Answer: B

  Wait up to 600 seconds for required locks on SH.SALES:

  EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE (

  'SH', 'SALES', 'INT_SALES', 600);

  Reference: http://oradb-srv.wlv.ac.uk/E50529_01/ARPLS/d_redefi.htm#ARPLS042

• Question 59:

  You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.

  Which three findings would you get from the report?

  A. It shows the resource usage for CPU, memory, and I/O in both time periods.

  B. It identifies any workload change that caused a performance difference in both time periods

  C. It detects any configuration change that caused a performance difference in both time periods.

  D. It gives information about statistics collection in both time periods.

  E. It detects the top wait events causing performance degradation.

  Correct Answer: ABC

• Question 60:

  Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?

  A. Restart the database Instance in RESTRICTED mode.

  B. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.

  C. Shut down the database instance.

  D. Restart the database instance in UPGRADE mode.

  E. Restart the instance in normal mode.

  F. Run the Database Migration Assistant.

  G. Set the MAX_STRING_SIZE parameter to EXTENDED.

  Correct Answer: BCDEG

  1.

  Shut down the database.

  2.

  Restart the database in UPGRADE mode.

  3.

  Change the setting of MAX_STRING_SIZE to EXTENDED.

  4.

  Run the rdbms/admin/utl32k.sql script. You must be connected AS SYSDBA to run the script.

  5.

  Restart the database in NORMAL mode.

  Reference: https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC699C0E6724693C.htm#REFRN10321