1z0-060 sample questions

Question 1

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 2

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

Question 3

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

Accepted Answer

to support synchronization of a standby database with the primary database in a Data Guard environment

Accepted Answer

to support file restoration over the network in a Data Guard environment

Accepted Answer

to support file recovery over the network in a Data Guard environment

Answer

to support PUSH-based active database duplication

Answer

to support active database duplication by taking image copies of the source database

Question 4

A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.

For the database instance STATISTICS-LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.

What should you do to accomplish this task?

Accepted Answer

Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.

Answer

Execute the query and view Active Session History (ASH) for information about the query.

Answer

Enable SQL trace for the query.

Answer

Use the DBMS_APPLICATIONJNFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Question 5

Examine the parameter for your database instance below.

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

SQL> SELECT product_name
FROM order_items o, product_information p
WHERE o.unit_price = 15
AND quantity > 1
AND p.product)id = o.product_id;

30 rows selected.

Identify the reason why the optimizer chose different execution plans.

Accepted Answer

The optimizer chose different plans because automatic dynamic sampling was enabled.

Answer

The optimizer used re-optimization cardinality feedback for the query.

Answer

The optimizer used a dynamic plan for the query.

Answer

The optimizer chose different plan because extended statistics were created for the columns used.

Question 6

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.

Which statement is true?

Accepted Answer

The operating system group that is specified must have permission to write to the inventory directory.

Answer

The operating system group that is specified should have the root user as its member.

Answer

The installation is being performed by the root user.

Answer

The ORACLEJ3ASE base parameter is not set.

Question 7

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the command below in the root container. Which two statements are true? (Choose two.)

Accepted Answer

The command will create a common user whose description is contained in the root and each PDB.

Accepted Answer

The schema for the common user C##A_ADMIN can be different in each container.

Answer

The command will create a user in the root container only because the CONTAINER clause is not used.

Answer

The C##A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

Answer

Schema objects owned by the C##A_ADMIN common user can be shared across all PDBs.

Question 8

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

Accepted Answer

CDBs and PDBs may share the same temporary tablespace that is present in the root container.

Accepted Answer

Each pluggable database (PDB) can have a temporary tablespace or a tablespace group.

Accepted Answer

All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces.

Answer

There can be only one temporary tablespace group in a CDB.

Answer

All PDBs and CDBs have their own UNDO tablespaces.

Question 9

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

Accepted Answer

An ASM instance automatically allocates an appropriate extent size for a file based on file size.

Accepted Answer

The metadata used to track extents in SGA is reduced.

Answer

Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Answer

Resync operations are completed faster when a disk comes online after being taken offline.

Answer

Rebalance operations are completed faster than with a fixed extent size.

Question 10

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?

Accepted Answer

It succeeds only if memory is available from the autotuned components of SGA.

Answer

It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

Answer

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

Answer

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

1z0-060 Upgrade to Oracle Database 12c Practice Questions

Create an account to continue.

Create an account to continue.

Related exams