Question No. 1

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

AIt provides a summary of the upgrade results.

BIt recompiles all invalid PL/SQL and Java code.

CIt generates a log file containing the fixes that can be made to the source database.

DIt provides parallel upgrade options to finish the upgrade process with a reduced down time.

EIt generates fix-up scripts to be run on the source database before upgrade.

Show Answer

Correct Answer: D

References:

https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52860

Question No. 2

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

Arecommending creation of indexes based on SQL workload

Brecommending restructuring of SQL statements that have suboptimal plans

Cchecking schema objects for missing and state statistics

Drecommending optimization of materialized views

Egenerating SQL profiles

Show Answer

Correct Answer: B, C, E

Question No. 3

Which statement is true regarding the DEFAULT profile?

AThe values assigned to the resource limits and password parameters in the default profile can be altered.

BA different DEFAULT profile can be created before each user in a database.

CIt can be dropped and recreated.

Dit must be explicitly assigned to the user.

Show Answer

Correct Answer: A

Question No. 4

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

Alistener configured by using NETCA

Bdatabase service created by using SRVCTL

Cdatabase created by using a SQL statement

Ddatabase created by using DBCA

EASM instance created by using ASMCA

Fdatabase service created by using DBMS_SERVICE.CREATE_SERVICE

Gdatabase service created by modifying the SERVICE_NAMES initialization parameter

Show Answer

Correct Answer: A, B, D, E

References https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart002.htm#insertedID3

Question No. 5

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.

In which three scenarios do you need media recovery? (Choose three.)

Aloss of all the copies of the control file

Bloss of all the inactive online redo log group members

Closs of a data file that belongs to the active undo tablespace

Dloss of data files that belong to the SYSTEM tablespace

Elogical corruption of data that is caused by a wrong transaction

Fabnormal termination of the database instance

Show Answer

Correct Answer: A, C, D

Free Oracle 1Z0-062 Exam Actual Questions

The questions for 1Z0-062 were last updated On Nov 6, 2024