1z0-060 Upgrade to Oracle Database 12c Practice Questions
Prepare for 1z0-060 with more than an answer.
- Exam fee
- $245 USD
- Time limit
- 120 minutes
- Questions on the exam
- 80
- Passing score
- 65% (scale 0-100%)
- Level
- Professional
- Valid for
- Must be recertified for current database versions
Domains covered on the exam 10
- Oracle Enterprise Manager and Other Tools8%
- Basics of Multitenant Container Database (CDB)12%
- Configuring and Creating CDBs and PDBs15%
- Managing CDBs and PDBs18%
- Managing Tablespaces, Users, Privileges and Roles10%
- Backup, Recovery and Flashback for CDB/PDB12%
- SQL Enhancements8%
- Information Lifecycle Management and Storage Enhancements10%
- Auditing Enhancements10%
- Performance and Optimizer Enhancements7%
- 1
What are three purposes of the RMAN “FROM SERVICE” clause? (Choose three.)
Show answer details
Correct answer: A, C, D
A,C,D--Explanation:
- With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible. * RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.
A,C,D--Explanation:
- With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible. * RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.
A,C,D--Explanation:
- With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible. * RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.
- 2
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?
Show answer details
Correct answer: D
D--Explanation:
The REPORT_SQL_MONITOR function is used to return a SQL monitoring report for a specific SQL statement.
Incorrect answers:
D: SET SESSION-LONGOPS Procedure This Procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is used to indicate the on-going progress of a long running operation. Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup.
Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view.
A: Not interested in session statistics, only in statistics for the particular SQL query.
B: We are interested in statistics, not tracing. - 3
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.
Show answer details
Correct answer: A
A--Explanation:
- optimizer_dynamic_sampling OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics.
Range of valuesO to 11
- optimizer_dynamic_sampling OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics.
- 4
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?
Show answer details
Correct answer: A
A--Explanation:
Note: Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You mtist choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine. - 5
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.)
Show answer details
Correct answer: B, D
B,D
B,D
- 6
Which three statements are true about tablespaces in a multitenant container database (CDB)? (Choose three.)
Show answer details
Correct answer: B, D, E
B,D,E
B,D,E
B,D,E
- 7
Which two statements are true about variable extent size support for large ASM files? (Choose two.)
Show answer details
Correct answer: A, D
A,D
A,D
- 8
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?
Show answer details
Correct answer: A
A
- 9
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.)
Show answer details
Correct answer: A, B, C
A,B,C--Expiration:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
Incorrect answers:
B: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.--
References: http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.htmlA,B,C--Expiration:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
Incorrect answers:
B: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.--
References: http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.htmlA,B,C--Expiration:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
Incorrect answers:
B: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.--
References: http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34dba-2193424.html - 10
Which three statements are true about SQL plan directives? (Choose three.)
Show answer details
Correct answer: B, C, D
B,C,D
B,C,D
B,C,D
