1Z0-064 Exam Questions

Examine the query and its output: Which two statements are true? (Choose two.)

You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded perf...

Examine the partial PLAN_TABLE output: Which is the correct sequence of execution? (Choose the best answer.)

Examine the query and its output: Which two inferences can be definitely derived from this output? (Choose two.)

You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft op...

In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert. What is the outcome? (C...

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

Examine the parameters set for a database instance: An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slo...

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

Which two are prerequisites for running the I/O calibration tool? (Choose two.)

Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currentl...

Which two statements are true about viewing the details of Real-Time Database Operations? (Choose two.)

You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already cre...

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

In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the COUNTRY_ID column. You want to make the optimizer aware of this dependency when these...

A DBA informs you that an Oracle instance has started. What does this imply?

Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

Examine the initialization parameters set for a database instance: The database supports an OLTP workload. Applications connect to the instance using shared server connections and...

For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendations by default? (Choose three.)

Your database supports an OLTP system. Examine the parameter values configured in your database: sga_max_size = 480M sga_target = 480M pga_aggregate_target = 160M The CUSTOMERS tab...

Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

Examine the parameter values configured in your database: sga_max_size = 480M sga_target = 480M pga_aggregate_target = 160M The CUSTOMERS table contains 8,000 rows. The CUST_ID col...

You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository...

Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattere...

Which two statements are true about gathering statistics? (Choose two.)

Which three statements are true about the interpretation of an execution plan? (Choose three.)

Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types...

Which two situations can lead to sparsely populated index blocks? (Choose two.)

Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)

Examine the parameters set for a database instance: The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigat...

You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them....

You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for tra...

You have been asked to use table compression for two large tables. Given are the details of the tables: The TRANS_DET table: The table is used by an OLTP application. High volume i...

You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them. Which two tasks would you pe...

In which three situations does DB time always increase? (Choose three.)

Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database. You notice that the sessions create...

For which database operation do you need the database to be in MOUNT state?

You want to capture the performance of your database during the last ten days of the first quarter of the current financial year, so that you can compare this performance against t...

For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)

Which two statements are true regarding undo data records?