Oracle Oracle Database 1Z0-060 Questions & Answers

• Question 61:

  You enabled an audit policy by issuing the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

  For which database users and for which executions is the audit policy now active? (Choose two.)

  A. SCOTT, SYS and SYSTEM

  B. SYS and SYSTEM, but not SCOTT

  C. SCOTT, but not SYS and SYSTEM

  D. Only for successful executions

  E. Only for failed executions

  F. Both successful and failed executions

  Correct Answer: BF

• Question 62:

  On your Oracle 12c database, you issue the following commands to create indexes:

  SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;

  SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);

  Which two statements are true? (Choose two.)

  A. The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.

  B. Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.

  C. Only the ORD_CUSTOMER_IX1 index is created.

  D. Only the ORD_CUSTOMER_IX2 index is created.

  E. Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERS table.

  Correct Answer: BE

• Question 63:

  Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

  A. The local listener may pass the request to an existing process which in turn will create a thread.

  B. Each multithreaded Oracle process has an SCMN thread.

  C. Each Oracle process runs an SCMN thread.

  D. Thread creation must be routed through a dispatcher process.

  Correct Answer: AD

• Question 64:

  You find this query being used in your Oracle 12c database:

  

  Which method a used by the optimizer to limit the rows being returned?

  A. A TOP-N query is created during execution and a filter is added to the query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

  B. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

  C. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

  D. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

  Correct Answer: B

• Question 65:

  You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

  In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

  A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as input parameter and use RMAN to restore the data.

  B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

  C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

  D. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

  E. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

  Correct Answer: BCE

• Question 66:

  In your Oracle 12c database, you create two roles: AUDITOR and AUDIT_ADMIN. You then execute the following commands:

  

  To create a privilege analysis policy for the AUDIT_ADMIN role, you execute the following PL/SQL block:

  

  Which statement is correct about the procedure?

  A. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.

  B. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT PAYABLE module is used.

  C. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.

  D. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the ACCOUNT PAYABLE module is used.

  Correct Answer: B

  References: https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM591

• Question 67:

  You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.

  For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)

  A. to check the database time consumed for the two time periods

  B. to review the change in the initialization parameters between the two runs

  C. to find the resource consumption by SQL statements that are common to both periods

  D. to check the performance improvement and degradation caused during the change

  E. to review the hardware resources used during the two runs

  F. to compare the performance change of top SQL statements for the two runs

  Correct Answer: CDE

• Question 68:

  Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c? (Choose two.)

  A. By default, EM express is available for a database after database creation.

  B. Multiple databases on the same node (or host) may each be individually managed by using EM Express.

  C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

  D. You cannot start up or shut down a database instance by using EM express.

  E. You can create and configure pluggable databases by using EM express.

  Correct Answer: BD

  O12c is integrated in database don't have his own agent like in O11G then you cannot start up or shut down a database.

• Question 69:

  You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements: RANDOM redaction on the SAL and COMM columns PARTIAL redaction on the HIREDATE column FULL redaction on the MGR column

  What would you define to implement this?

  A. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted

  B. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type

  C. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted

  D. several redaction policies, with one redaction policy for each table column that must be redacted

  Correct Answer: C

  You can redact columns of different data types, using different redaction types, for one table or view.

  1.

  Create the policy for the first column that you want to redact.

  2.

  Use the DBMS_REDACT.ALTER_POLICY procedure to add the next column to the policy.

  References: https://docs.oracle.com/cd/E11882_01/network.112/e40393/redaction_config.htm

• Question 70:

  A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

  

  There is enough free space in the disk group for mirroring to be done.

  What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?

  A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

  B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

  C. The data in the CONTROLLER1 failure group is copied to the CONTROLLER2 failure group and rebalancing is initiated.

  D. ASM does not mirror any data until the CONTROLLER1 failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group, without mirroring.

  Correct Answer: D