[Refresh] 1z0-060 exam

1z0-060 Royal Pack Testengine pdf

100% Actual & Verified — 100% PASS

Unlimited access to the world's largest Dumps library!

https://www.2passeasy.com/dumps/1z0-060/

Exam Code: 1z0-060 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Upgrade to Oracle Database 12c
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-060 Exam.

2016 Jul 1z0-060 dumps:

Q51. You notice that the elapsed time for an important database scheduler Job is unacceptably long.

The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?

A. Increasing the priority of the job class to which the job belongs

B. Increasing the job's relative priority within the Job class to which it belongs

C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

F. Increasing the priority of the scheduler window to which the job belongs

Answer: CF


Q52. Which three operations can be performed as multipartition operations in Oracle?

A. Merge partitions of a list partitioned table

B. Drop partitions of a list partitioned table

C. Coalesce partitions of a hash-partitioned global index.

D. Move partitions of a range-partitioned table

E. Rename partitions of a range partitioned table

F. Merge partitions of a reference partitioned index

Answer: ABF


Q53. Your 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?

A. Oracle Data Pump.

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

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

D. Online Table Redefinition.

E. Edition-Based Table Redefinition.

Answer: D


Q54. Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

C. All the components may be moved into SYSAUX tablespace.

D. All the components may be moved from the SYSAUX tablespace.

Answer: AB


Q55. You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.

You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.

Which three findings would you get from the report?

A. It detects any configuration change that caused a performance difference in both time periods.

B. It identifies any workload change that caused a performance difference in both time periods.

C. It detects the top wait events causing performance degradation.

D. It shows the resource usage for CPU, memory, and I/O in both time periods.

E. It shows the difference in the size of memory pools in both time periods.

F. It gives information about statistics collection in both time periods.

Answer: ABD


2passeasy.com

Most recent download 1z0-060:

Q56. Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

A. Change in the Oracle Database version

B. Change in your network infrastructure

C. Change in the hardware configuration of the database server

D. Migration of database storage from non-ASM to ASM storage

E. Database and operating system upgrade

Answer: ACE


Q57. Which three functions are performed by the SQL Tuning Advisor?

A. Building and implementing SQL profiles

B. Recommending the optimization of materialized views

C. Checking query objects for missing and stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending the restructuring of SQL queries that are using bad plans

Answer: ACE


Q58. Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A. By default, EM express is available for a database after database creation.

B. You can use EM express to manage multiple databases running on the same server.

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D. You cannot start up or shut down a database Instance by using EM express.

E. You can create and configure pluggable databases by using EM express.

Answer: D


Q59. Examine the following parameters for a database instance:

MEMORY_MAX_TARGET=0 

MEMORY_TARGET=0 

SGA_TARGET=0 

PGA_AGGREGATE_TARGET=500m

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?

A. LOG_BUFFER

B. SORT_AREA_SIZE

C. JAVA_POOL_SIZE

D. STREAMS_POOL_SIZE

E. DB_16K_CACHE_SZIE

F. DB_KEEP_CACHE_SIZE

Answer: AEF


Q60. Which three statements are true about Automatic Workload Repository (AWR)?

A. All AWR tables belong to the SYSTEM schema. 

B. The AWR data is stored in memory and in the database.

C. The snapshots collected by AWR are used by the self-tuning components in the database

D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.

Answer: CDE



see more Upgrade to Oracle Database 12c