1Z0-062 Oracle Exam Questions and Free Practice Test

Question 73

In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure. In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

A. One control file copy is intact so the spfile is changed to refer to only one copy.

B. One control file copy is intact and damaged control file copies have to be restored to the default location.

C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.

D. All copies of the control file are damaged and the auto backed up control file is used for recovery.

E. One control file copy is intact and damaged control file copies have to be restored to a non-default locatio

Correct Answer:CD

Question 74

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade. What must you do first in this situation to attempt to fix this problem?

A. Run catuppst.sql to perform revalidation actions

B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

C. Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.

D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY vie

Correct Answer:D

Question 75

Which two statements are true about the RMAN validate database command? (Choose two.) A. It checks the database for intrablock corruptions.

A. It can detect corrupt pfiles.

B. It can detect corrupt spfiles.

C. It checks the database for interblock corruptions.

D. It can detect corrupt block change tracking files.

Correct Answer:AC
Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. th« corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption.
(key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption.
VALIDATE Command Output ••> List of Control File and SPFILE. File TYPE >»» SPFILE or Control File.
Status >»» OK if no corruption, or FAILED If block corruption is found. Blocks Failing »»» The number of blocks that fail the corruption check. These blocks are newly corrupt.
Blocks Examined »»» Total number of blocks in the file. Oracle' Database Backup and Recovery User's Guide
12c Release 1 (12.1) - 16 Validating Database Files and Backups

Question 76

To implement Automatic Management (AMM), you set the following parameters:
1Z0-062 dumps exhibit
When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

A. The PGA_AGGREGATE_TARGET parameter is set to zero.

B. The STATISTICS_LEVEL parameter is set to BASIC.

C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Correct Answer:B
Example:
SQL> startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

Question 77

You want to schedule a job to rebuild a table’s indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system.
What would you do to accomplish this?

A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.

B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.

C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.

D. Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.

Correct Answer:A

Question 78

Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

A. the optimizer_mode initialization parameter

B. operating system (OS) statistics

C. cardinality estimates

D. object statistics in the data dictionary

E. fixed baselines

Correct Answer:ACD

START 1Z0-062 EXAM