1Z0-024 Performance Tuning Practice Exam

Oracle ™

1Z0-024 Performance Tuning

Note 1: 1Z0-024 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 1Z0-024 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 1.

Which two statements regarding OLTP systems are true? (Choose two)

A. Use literals for optimally shared SQL rather than bind variables to keep the overhead of parsing to a minimum.
B. To avoid the performance load of dynamic space allocation, allocate space explicitly so tables, clusters and indexes.
C. tree indexing is preferred to bitmap indexing, because of locking issues affecting DML operations.
D. Use hash clusters especially on tables that are heavily inserted into, because of the use of space and the number of blocks that need to be visited.
E. Use application code to enforce business rules instead of constraints, because constraints are extremely expensive to process.

Display Answer

Purchase Full Version:

1Z0-024 Printable PDF Prep Guide $49.95 BUY NOW!

1Z0-024 Test Simulation Engine $69.95 BUY NOW!

1Z0-024 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: B, C

Explanation: It's better to allocate space explicitly to tables, clusters and indexes in OLTP system to avoid the performance load of dynamic space allocation. B. tree indexing is preferred to bitmap indexes in OLTP systems, because of locking issues affecting DML operations. Most of DML operations related with bitmap indexes will require high-level locking due to low cardinality nature of bitmap indexes and it will cause performance issues because of high level of DML operations in OLTP systems. Incorrect