Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 201:

  Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

  A. The ability of users to audit their own schema objects is not available in the post-migrated database.

  B. Operating system audit trail is available in the post-migrated database.

  C. Network auditing is available in the post-migrated database.

  D. Mandatory auditing of audit administrative actions is available in the post-migrated database.

  Correct Answer: AD

  References: https://docs.oracle.com/database/121/DBSEG/audit_changes.htm#DBSEG341

• Question 202:

  Which three statements are true about Database Resource Manager? (Choose three.)

  A. A resource plan change can be automated by using the Oracle Scheduler.

  B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

  C. It can be used to control the usage of the undo tablespace by consumer groups.

  D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

  E. It can be used to enable resumable timeout for user sessions.

  F. It can be used to control the usage of the temp tablespace by consumer groups.

  Correct Answer: ACD

• Question 203:

  Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

  A. A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.

  B. A job class specifies a scheduler window that will be open when that job class becomes active.

  C. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.

  D. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.

  E. A scheduler window can control resource allocation by itself.

  Correct Answer: DE

• Question 204:

  What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

  A. Optimizer statistics are collected automatically.

  B. Only timed operating system (OS) statistics and plan execution statistics are collected.

  C. Automatic Workload Repository (AWR) snapshots are not generated automatically.

  D. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

  Correct Answer: C

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

• Question 205:

  Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  A. It calls SQL advisors automatically if required.

  B. It provides recommendations only for poorly performing SQL statements.

  C. Its results are stored in AWR.

  D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.

  E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

  Correct Answer: CE

• Question 206:

  Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

  A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.

  B. It automatically makes necessary changes to Oracle environment variables.

  C. It automatically enables unified auditing in the upgraded database.

  D. It automatically adds new data files if there is not enough disk space to grow.

  Correct Answer: D

  References: https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insertedID5

• Question 207:

  Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

  A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.

  B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.

  C. Install Oracle HTTP Server.

  D. Configure at least one dispatcher for the TCP/IP protocol.

  E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.

  Correct Answer: DE

• Question 208:

  Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (ASM) by using RMAN. You back up the entire database.

  What should the next step be in this migration process?

  A. enabling row movement for the database

  B. disabling Oracle Flashback Database if enabled

  C. opening the database in exclusive mode

  D. placing all tablespaces in read-only mode

  Correct Answer: B

  References: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm#OSTMG89995

• Question 209:

  Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

  What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

  A. Automatic Database Diagnostic Monitor (ADDM)

  B. SQL Tuning Advisor

  C. SQL Access Advisor

  D. SQL Performance Analyzer

  E. Automatic Workload Repository (AWR) report

  Correct Answer: C

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm#TDPDW00813

• Question 210:

  You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command:

  RMAN> DELETE OBSOLETE;

  Which three statements are true is this scenario? (Choose three.)

  A. The backup sets marked as expired are deleted.

  B. The information related to the backups is removed from the recovery catalog and the control file.

  C. The physical files related to the backup need to be manually deleted.

  D. The physical files related to the backup are deleted automatically.

  E. The backups deleted are based on the backup retention policy.

  Correct Answer: BDE