Free Oracle 1Z0-060 Exam Dumps Questions & Answers

Which three statements are true about Oracle Data Pump export and import operations?

• A.The master table is the last object to be exported by the data pump.
• B.Data pump import requires the import file to be in a directory owned by the oracle owner.
• C.You can detach from a data pump export job and reattach later.
• D.You can detach from a data pump import job and reattach later.
• E.Data pump uses parallel execution server processes to implement parallel import.

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?

• A.Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
• B.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
• C.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• D.The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
• E.ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A.Reduced logical I/O
• B.Reduced CPU utilization
• C.Improved parallel Execution performance
• D.Improved Serial Execution performance
• E.Reduced physical I/O
• F.Reduced virtual memory utilization

Which three statements are true about using flashback database in a multitenant container database (CDB)?

• A.Individual PDBs can be flashed back without flashing back the entire CDB.
• B.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
• C.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
• D.To enable flashback database, the CDB must be mounted.
• E.The root container can be flashed back without flashing back the pluggable databases (PDBs).

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

• A.Increasing the job's relative priority within the Job class to which it belongs
• B.Increasing the priority of the scheduler window to which the job belongs
• C.Increasing the value of the JOB_QUEUE_PROCESSES parameter
• D.increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window
• E.Moving the job to an existing higher priority scheduler window with the same schedule and duration