1z0-060 Free Sample Questions

Which three statements are true about tablespaces in a multitenant container database (CDB)? (Choose three.)

Which two statements are true about variable extent size support for large ASM files? (Choose two.)

Examine the current values for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOGJ3UFFER = 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?

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.)

Which three statements are true about SQL plan directives? (Choose three.)

On your Oracle 12c database, you issue the following commands to create indexes: SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customerjd, sales_rep_id); SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customerjd, sales_rep_id); Which statement is correct?

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?

You performed an incremental level 0 backup of a database: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 7mydir/rman_change_track.f; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true? (Choose three.)

Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report: What are three possible causes for the latch-related wait events? (Choose three.)