1z0-060 sample questions

Question 1

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?

Accepted Answer

Both the indexes are created; however, only the ORD_CUSTOMER_IX2 index is visible.

Answer

Only the ORD_CUSTOMER_IX1 index is created and it is visible.

Answer

Both the indexes are created; however, only the ORD_CUSTOMER_IX1 index is visible.

Answer

Both the indexes are created and both of them are visible.

Question 2

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?

Accepted Answer

Online Table Redefinition

Answer

Edition-Based Table Redefinition

Answer

Oracle Data Pump

Answer

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

Answer

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes

Question 3

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

Accepted Answer

The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Accepted Answer

Block change tracking will sometimes reduce I/O performed during cumulative incremental backups.

Accepted Answer

More than one database block may be read by an incremental backup for a change made to a single block.

Answer

The change tracking file must always be backed up when you perform a full database backup.

Answer

Block change tracking will always reduce I/O performed during cumulative incremental backups.

Question 4

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

Accepted Answer

range partitioning

Accepted Answer

hash partitioning

Answer

interval partitioning

Answer

list partitioning

Answer

system partitioning

Question 5

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

Accepted Answer

The size of the shared pool is too small.

Accepted Answer

The buffers are being read into the buffer cache, but some other session is changing the buffers.

Accepted Answer

Cursors are not being shared.

Answer

A large number COMMITS are being performed.

Answer

There are frequent logons and logoffs.

Question 6

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

select employee_id,first_name,salary
from hr.employees
order by employee_id
fetch first 20 percent rows only;

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

Accepted Answer

A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

Answer

a TOP-N query is created during execution and a filter is added to the query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

Answer

All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

Answer

a filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

Question 7

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.

Examine the command and its output below.

You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG;

Which data files will be backed up?

Accepted Answer

Data files that belong to the root container and all the pluggable databases (PDBs)

Answer

Data files that belong to only the root container

Answer

Data files that belong to only the root container and PDB$SEED

Answer

Data files that belong to the root container and all the PDBs excluding PDB$SEED

Question 8

You are connected to a pluggable database (PDB) as a common user with DBA privileges.

The STATISTICS-LEVEL parameter is PDB_MODIFIABLE.

You execute the following:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID=‘*’ SCOPE=SPFILE;

Which is true about the result of this command?

Accepted Answer

The STATISTICS-LEVEL parameter is set to ALL whenever this PDB is re-opened.

Answer

The STATISTICS-LEVEL parameter is set to ALL whenever the multitenant container database (CDB) is restarted.

Answer

The STATISTICS-LEVEL parameter is set to ALL whenever any PDB is reopened.

Answer

Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Question 9

A database is stored in an Automatic Storage Management (ASM) disk group, DGROUP1, created with SQL.

There is enough free space in the disk group for mirroring to be done.

What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?

Accepted Answer

ASM does not mirror any data until the CONTROLLERI failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the CONTROLLER? failure group, without mirroring.

Answer

Mirroring of allocation units will be done to ASM disks in the CONTROLLER? failure group until the CONTROLLER1 failure group is brought back online.

Answer

Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

Answer

The data in the CONTROLLER1 failure group is copied to the CONTROLLER? failure group and rebalancing is initiated.

Question 10

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

Accepted Answer

Allocates memory for RMAN backup and restore operations

Accepted Answer

Contains a cursor area for storing runtime information about cursors

Accepted Answer

Allocates memory for shared and private SQL areas

Answer

Contains stack space

Answer

Contains a hash area performing hash joins of tables

1z0-060 Sample Questions & Answers

Ready for the real thing?

1z0-060 Sample Questions & Answers

Related practice tests

Ready for the real thing?