1z0-064 sample questions

Question 1

To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the query:

The table is stored in a tablespace that has Automatic Segment Space Management (ASSM) enabled. The tablespace is created with a standard block size of 8192 bytes.

Which three can be reasons for the slow response time of the queries? (Choose three.)

Accepted Answer

Row size is too large to fit into a single block during insert operations.

Accepted Answer

Row moves from one data block to another data block because the row grows too large to fit in the original block.

Accepted Answer

The value of PCTUSED is set to a value lower than the default, causing row chaining.

Answer

The table is subject to frequent insert, update, and delete DML activity leading to sparsely populated blocks.

Answer

The value of PCTFREE is set to a value lower than the default, causing row chaining.

Question 2

Examine the parameters set for your database instance:

You are administrating a database that supports a DSS workload. You make some changes to the sizes of memory components. Consequently, you receive this error:

Which three actions might resolve the issue?

Accepted Answer

enabling Automatic Shared Memory Management for the database instance

Accepted Answer

setting the value of MEMORY_MAX_TARGET to the value of the SGA_MAX_SIZE parameter

Accepted Answer

enabling Automatic Memory Management for the database instance

Answer

pinning the cursors in the shared pool

Answer

setting the PGA_AGGREGATE_TARGET parameter to 0 and the MEMORY_TARGET parameter to the value of the PGA_AGGREGATE_TARGET parameter

Answer

increasing the size of the shared pool

Question 3

You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.

Which action would you take to achieve this? (Choose the best answer.)

Accepted Answer

Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.

Answer

Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.

Answer

Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.

Answer

Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.

Question 4

Examine the parameters set for your database instance:

To investigate the slow response time of queries on the TRANS table, you gather table and execute the query:

The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained.

Which two actions would you recommend to improve query response time?

Accepted Answer

Reorganize the TRANS table online by using the DBMS_REDEFINITION package.

Accepted Answer

Move the TRANS table to a tablespace with manual segment space management with a higher value set for the PCTFREE attribute.

Answer

Create a bigger non-standard blocksize tablespace and move the TRANS table to that tablespace.

Answer

Move the TRANS table to a tablespace with manual segment space management with a lower value set for the PCTUSED attribute.

Question 5

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.

Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

Accepted Answer

the alert log

Accepted Answer

DBA_THRESHOLDS

Answer

Oracle Enterprise Manager Cloud Control

Answer

DBA_ALERT_HISTORY

Answer

DBA_OUTSTANDING_ALERTS

Answer

DBA_ACTIVE_SESSION_HISTORY

Question 6

Which three actions should you perform to reduce shared pool fragmentation and avoid the “ORA-04031: unable to allocate .... bytes of shared memory” error for the shared pool? (Choose three.)

Accepted Answer

Configure the Server Result Cache.

Accepted Answer

Configure shared server mode.

Accepted Answer

Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTIL packages and frequently executed compiled triggers.

Answer

Identify the packages or procedures that are causing the “ORA-04031 :unable to allocate....bytes of shared memory” error and use the DBMS_SHARED_POOL.KEEP to keep them in the shared pool.

Answer

Use more anonymous procedures.

Answer

Standardize the type, size, and naming conventions for bind variables and spacing conventions for SQL statements and PL/SQL blocks.

Oracle Database 12c: Performance Management and Tuning Free Sample Questions

Lifetime One

Two

Pro Four

Premium Twelve

1z0-064 Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Trusted by professionals at