Now Do Your Preparation In The Shortest Way With 1z0-060 Practice Test Under The Supervision of Qualified Experts

Question No :01

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

A. Oracle Data Pump
B. Oracle Recovery Manager (RMAN)
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Real Application Security

Answer: B 

Question No :02

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

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

Answer: B,C,F 

Question No :03

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disruption to availability is required. Which three statements are true about this requirement? (Choose three.)

A. The partitions can be moved online to new tablespaces.
Visit us athttps://www.examsboost.com/test/1z0-060/
B. Global indexes must be rebuilt manually after moving the partitions.
C. The partitions can be compressed in the same tablespaces.
D. The partitions can be compressed in the new tablespaces.
E. Local indexes must be rebuilt manually after moving the partitions.

Answer: A,C,D 

Question No :04

Which three are true about the large pool for an Oracle database instance that supports shared server connections? (Choose three.)

A. Allocates memory for RMAN backup and restore operations
B. Allocates memory for shared and private SQL areas
C. Contains a cursor area for storing runtime information about cursors
D. Contains stack space
E. Contains a hash area performing hash joins of tables

Answer: A,B,C 


Question No :05

What are three purposes of the RMAN “FROM” clause? (Choose three.)

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

Answer: B,D,E