Oracle Upgrade to Oracle Database 12c - 1Z0-060 Exam Practice Test

A. to review the change in the initialization parameters between the two runs B. to check the database time consumed for the two time periods C. to compare the performance change of top SQL statements for the two runs D. to check the performance improvement and degradation caused during the change E. to find the resource consumption by SQL statements that are common to both periods F. to review the hardware resources used during the two runs

A. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS. B. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS. C. Run the Automatic Workload Repository Monitor (ADDM). D. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

A. The CDB must be in the nomount stage. B. The CDB must be open. C. Alt existing PDBs must be closed. D. The CDB must be in the mount stage.

A. It generates an error when creating the table because the wallet is closed. B. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT. C. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces. D. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

A. Thread creation must be routed through a dispatcher process. B. Each multithreaded Oracle process has an SCMN thread. C. Each Oracle process runs an SCMN thread. D. The local listener may pass the request to an existing process which in turn will create a thread.

A. Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false. B. Results from remote queries may sometimes be stored in the query result cache. C. Stale results may still be obtained from the query result cache, if the query session's parameter is set to stale_tolerated.
query_rewrite_integrity D. Results obtained from a query rewrite to a materialized view may be stored in the query result cache. E. Results from distributed queries are never stored in the query result cache. F. Results obtained from a join between a table and a view may be stored in the query result cache.

A. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration. B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started. C. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started. D. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

A. Recover the table using Automated Tablespace Point In Time Recovery. B. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
OCP.EXAM_RESULTS; connected as SYSTEM. C. Recovery the table sing Database Point In Time Recovery. D. Recover the table using traditional Tablespace Point In Time Recovery. E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
EXAM_RESULTS; connected as the OCP user.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; B. BACKUP SPFILE SECTION SIZE 1M; C. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; D. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; E. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; F. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; G. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

A. It adds new; bettor plans automatically as fixed plans to the baseline. B. 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. C. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans. D. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

A. Each multithreaded Oracle process has an SCMN thread. B. Thread creation must be routed through a dispatcher process C. Each Oracle process runs an SCMN thread. D. The local listener may pass the request to an existing process which in turn will create a thread. E. The local listener may spawn a now process and have that new process create a thread

A. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker. B. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM). C. The C# # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus. D. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only. E. The C # # A_ADMIN user can perform wallet operations.

A. Effectively implements role separation B. Enables the Installation of Grid Infrastructure files on block or raw devices. C. Enables you to take advantage of Oracle Managed Files. D. Automatically registers the database with Oracle Restart. E. Helps you to easily upgrade the database from a prior release.

A. The unplugged PDB can be plugged into the same multitenant container database (CDB) B. The unplugged PDB can be plugged into another CDB. C. The PDB data files are automatically removed from disk. D. The PDB must be dosed. E. The PDB must be open in read only mode. F. The unplugged PDB becomes a non-CDB.