1Z0-064 Exam Questions

You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed...

You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have alre...

In which three situations can dynamic statistics be used? (Choose three.)

You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large...

Examine the parameters: Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that...

Examine the parameters set for a database instance supporting a mixed workload: The database instance supports shared server and dedicated server connections simultaneously. Users...

You recently joined a new team administering a database. You notice that full table scans are performing poorly compared with full table scans on the databases you administered in...

Examine an extract from a PGA Memory Advisory for your database: Which two inferences are correct? (Choose two.)

Examine the structure of the EMPLOYEES table. EMPLOYEE_ID is the primary key. No other indexes exist on this table. View the Exhibit to examine the commands and their output. Which...

For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running tr...

Examine the parameters set for your database instance: You are asked by a developer to create a table for an application with these requirements: The table will be used for a DSS a...

Examine the parameters set for your database instance: You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads a...

Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)

Which two statements are true about server-generated alerts? (Choose two.)

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

Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

Examine the output of the query executed to diagnose the reason for performance degradation of queries: Which three factors will you investigate further to identify the cause of th...

Which two result in the latest fragmentation within segments and the least external fragmentation within tablespaces? (Choose two.)

You execute this query twice in a session: Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown. Which two statements are true? (Choose two.)

Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)

Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk...

Which two statements are true about Active Session History (ASH)? (Choose two.)

You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modu...

Examine the parameters set for your database instance: You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Ma...

In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level. Which two statements are...

Examine the Time Model Statistics section of an AWR report: Which two inferences can be definitely derived from this section? (Choose two.)

You observe that queries are performing poorly on the SALES_RECORDS table in your database. On investigation, you find that at the end of each day the contents of the SALES_RECORDS...

Which three statements are true about using Real-Time Database Operations? (Choose three.)

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? (Cho...

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions...

Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)

Which two statements are true about Compare Period ADDM? (Choose two.)

Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)

Examine the partial Activity Over Time section of an Active Session History (ASH) report: Which two inferences are correct? (Choose two.)

A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay. What three cou...

Examine the parameters set for your database instance: You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some querie...

Examine this list of possible tasks: 1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL. 2. Ensure that TIMED_STATISTICS is set to TRUE. 3. Set MAX_DUMP_FILE_SIZE to UNLIMITE...

Examine the partial AWR report taken for a time period of 60 minutes: Which two inferences can you draw from this report? (Choose two.)

Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries. Yo...

Examine the partial TKPROF output for an SQL statement: Which two inferences can definitely be made from this output? (Choose two.)

Examine the command to change a parameter value from the default to 50: SQL> ALTER SYSTEM SET OPTIMIZER_INDEX_COST_ADJ = 50; What is the effect of changing the value of the paramet...

You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?

Which two statements are true regarding the database control file? (Choose two.)

You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight...

You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries th...

You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services. You execute the command...

Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)

Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views. You notice that some q...

Examine the Load Profile section of an AWR report: Which two inferences can you derive from the details in this section? (Choose two.)

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report: What should you examine to diagnose the cause of the top three wait events? (Choose the be...