從最新題庫、模擬考軟體到售後更新服務，Fast2test 提供 Oracle Database 12c: Performance Management and Tuning 一站式備考方案。1z0-064 共 120 道練習題，2026 年準備考試所需的一切，在這裡一次備齊。

Oracle 1z0-064 考試概覽:

Oracle 1z0-064 考試大綱主題:

Oracle 1z0-064 考試疑問總整理

最新的 Oracle Database 1z0-064 免費考試真題：

問題 #1

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 table are moved to the SALES_HISTORY table. The delete operations cause the table to be sparsely populated.
The SALES_RECORDS table is created in a tablespace using Automatic Segment Space Management (ASSM) and row movement is enabled. The table must be accessible 24x7.
Which two tasks would you recommend to improve the performance? (Choose two.)

A. Reorganize the SALES_RECORDS table online by using the DBMS_REDEFINITION package.
B. Deallocate the space in the SALES_RECORDS table by using the ALTER TABLE...DEALLOCATE UNUSED command.
C. Shrink the SALES_RECORDS table by using the ALTER TABLE...SHRINK SPACE command.
D. Perform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table.
E. Move the SALES_RECORDS table to a tablespace by using manual segment space management.
F. Move the SALES_RECORDS table to a different location by using the ALTER TABLE...MOVE command.

問題 #2

In which three scenarios would you recommend the use of the SQL Performance Analyzer?

A. to identify SQL statements whose performance may have regressed due to a hardware upgrade
B. to identify SQL statements that require SQL profiles
C. to analyze the impact of network and interconnect changes on database workload
D. to analyze the impact of using bind variables for syntactically similar SQL statements
E. to analyze the impact of new indexes and materialized views on the SQL statements executed by an application
F. to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c

問題 #3

Your database supports an OLTP workload. You are planning to migrate database storage from file system storage to Automatic Storage Management (ASM). The applications supported by the database primarily perform small, random I/Os.
Which two statements are true regarding ASM striping in combination with RAID 0?

A. It improves the performance of only write-intensive workloads.
B. It helps in reducing network latency.
C. It provides higher I/O bandwidth.
D. It improves availability and reliability of data be ensuring that logical data corruptions are found and repaired.
E. It allows you to evenly spread data over multiple disks.

問題 #4

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 that vary in literal values in the WHERE clause, causing a large number of hard parses to occur.
Which four statements would be true if you use bind variables for these queries? (Choose four.)

A. The optimizer will use bind peeking and subsequent execution of the queries will always generate the same plans irrespective of the cardinality.
B. Hard parses will be reduced for the queries.
C. The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal values.
D. The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in the WHERE clause of these queries.
E. Mutex contention in the library cache will be reduced.
F. The optimizer will use bind peeking and use the literal value to determine the execution plan for these queries.

問題 #5

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 transactions that consume huge amounts of space in the UNDO tablespace.
You want to control the usage of the UNDO tablespace only for these user sessions.
How would you avoid the issue from repeating in future? (Choose the best answer.)

A. Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
B. Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.
C. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
D. Set the threshold for UNDO tablespace usage for the users.

問題與答案：