1Z0-060 Online Practice Questions and Answers

A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.

For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.

What should you do to accomplish this task?

A. Execute the query and view Active Session History (ASH) for information about the query.

B. Enable SQL trace for the query.

C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.

D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

You issue the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

For which database users is the audit policy now active?

A. All users except SYS

B. All users except SCOTT

C. All users except SYS and SCOTT

D. All users except SYS, SYSTEM, and SCOTT

Examine the following query output:

You issue the following command to import tables into the hr schema:

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y

Which statement is true?

A. All database operations performed by the impdp command are logged.

B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Which three statements are true about adaptive SQL plan management?

A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

C. It adds new, bettor plans automatically as fixed plans to the baseline.

D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.

One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.

When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.

Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

A. Increase the value of the ASM_POWER_LIMIT parameter.

B. Set the DISK_REPAIR_TIME disk attribute to a lower value.

C. Specify the statement that adds the disk back to the disk group.

D. Increase the number of ASMB processes.

E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)

A. Thread creation must be routed through a dispatcher process

B. The local listener may spawn a now process and have that new process create a thread

C. Each Oracle process runs an SCMN thread.

D. Each multithreaded Oracle process has an SCMN thread.

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

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

A. System privileges apply only to the PDB in which they are used.

B. Local users cannot use local system privileges on the schema of a common user.

C. The granter of system privileges must possess the set container privilege.

D. Common users connected to a PDB can exercise privileges across other PDBs.

E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

Identify three benefits of Unified Auditing.

A. Decreased use of storage to store audit trail rows in the database.

B. It improves overall auditing performance.

C. It guarantees zero-loss auditing.

D. The audit trail cannot be easily modified because it is read-only.

E. It automatically audits Recovery Manager (RMAN) events.

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.

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.