1z1-064 試験問題を無料オンラインアクセス

In your database, supporting an OLTP workload, the SALES table is range-partitioned on the SALES_DATE column. A new partition is created every quarter and is frequently used for updates and queries. You recently noticed degraded performance of queries on a new partition due to stale statistics. A local partitioned index exists on the SALES_DATE column.
What would you recommend to improve performance?

• A.setting the INCREMENTAL preference to TRUE and the CASCADE preference to FALSE for the partitioned table while gathering statistics
• B.dropping the local partitioned index and creating a global partitioned index on the SALES_DATE column
• C.setting the INCREMENTAL preference to TRUE and the GRANULARITY preference to AUTO for the partitioned table while gathering statistics
• D.setting the INCREMENTAL preference to TRUE and the NO_INVALIDATE preference to TRUE for the partitioned table while gathering statistics

Queries on the SALES table frequently use the PROD_ID and COST_ID columns together in the WHERE clause. Examine the command:

Which three statements are true about executing this command?

• A.It creates a virtual column for the column group (PROD_ID and CUST_ID).
• B.It improves the selectivity estimates of a single predicate in the WHERE clause.
• C.It improves the cardinality estimates when both the PROD_ID and CUST_ID columns are used in the WHERE clause.
• D.It gathers individual column statistics for the PROD_ID and CUST_ID columns.
• E.It creates extended statistics for the column group (PROD_ID and CUST_ID).

Examine the Load Profile and partial Top 10 Foreground Events by Total Wait Time sections from an AWR report.


Which two areas should you examine next to identify possible bottlenecks?

• A.the "SQL ordered by Reads" section of the AWR report to check for excessive physical reads
• B.the application code because of CPU-intensive activities
• C.the "SQL ordered by Gets" section of the AWR report to check for excessive logical I/O
• D.the application code because user calls are performing several queries that require sorting

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 perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.
To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.
What will you recommend to alleviate the issue? (Choose the best answer.)

• A.Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.
• B.Run the I/O calibration tool.
• C.Configure dedicated server connections for the applications.
• D.Configure the database instance to make asynchronous I/O available to DBWR.

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 a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)

• A.storing query results in the result cache
• B.setting of the OPTIMIZER_MODE parameter to ALL_ROWS
• C.block size of the tablespaces in which the tables being scanned are stored
• D.use of parallel queries
• E.setting of the DISK_ASYNC_IO parameter to TRUE
• F.value of the OPTIMIZER_DYNAMIC_SAMPLING parameter
• G.value of DB_FILE_MULTIBLOCK_READ_COUNT