Free 1z0-060 Exam Dumps

Question 26

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

A. Parallel compilation of only the stored PL/SQL code
B. Sequential recompilation of only the stored PL/SQL code
C. Parallel recompilation of any stored PL/SQL code
D. Sequential recompilation of any stored PL/SQL code
E. Parallel recompilation of Java code
F. Sequential recompilation of Java code

Correct Answer:CE

Question 27

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
\1.Mount the CDB.
\2.Close all the PDBs.
\3.Open the database.
\4.Apply the archive redo logs.
\5.Restore the data file.
\6.Take the SYSAUX tablespace offline.
\7.Place the SYSAUX tablespace online.
\8.Open all the PDBs with RESETLOGS.
\9.Open the database with RESETLOGS.
\10.Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

A. 6, 5, 4, 7
B. 10, 1, 2, 5, 8
C. 10, 1, 2, 5, 4, 9, 8
D. 10, 1, 5, 8, 10

Correct Answer:A

Question 28

What are three purposes of the RMAN “FROM” clause?

A. to support PUSH-based active database duplication
B. to support synchronization of a standby database with the primary database in a Data environment
C. To support PULL-based active database duplication
D. To support file restores over the network in a Data Guard environment
E. To support file recovery over the network in a Data Guard environment

Correct Answer:BDE

Question 29

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?

A. Increase the value of the ASM_POWER_LIMIT parameter.
B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
C. Specify the statement that adds the disk back to the disk group.
D. Increase the number of ASMB processes.
E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Correct Answer:AC

Question 30

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B. It fails because no SQL *Loader data file location is specifie
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D. It fails because no SQL *Loader control file location is specifie

Correct Answer:AC