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

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?

You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
`+RECO';
Which five steps are performed by RMAN?

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

You are administering a database stored in Automatic Storage Management (ASM).
You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?

Examine the types and examples of relationships that follow:
1. One-to-one
a) Teacher to students
2. One-to-many
b) Employees to Manager
3. Many-to-one
c) Person to SSN
4. Many-to-many
d) Customers to products
Which option indicates the correctly matched relationships?

Which two statements are true about the Oracle Direct Network File system (DNFS)?

Which three statements are true about the use of the query result cache? (Choose three.)

Which three statements are true about adaptive SQL plan management?