QUESTION NO: 1
Which two statements regarding OLTP systems are true? (Choose two)

1. Use literals for optimally shared SQL rather than bind variables to keep the overhead of parsing to a minimum.
2. To avoid the performance load of dynamic space allocation, allocate space explicitly so tables, clusters and indexes.
3. B-tree indexing is preferred to bitmap indexing, because of locking issues affecting DML operations.
4. 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.
5. Use application code to enforce rules instead of constraints, because constraints are extremely expensive to process.

Answer: B, C

QUESTION NO: 2
When performing a sort operation, you notice that there are a large number of sorts requiring I/0 to the disk. Which parameter could be increased to allow more sorts to be performed in memory?

A. SORT_AREA_SIZE
B. LARGE_POOL_SIZE
C. SORT_AREA_RETAINED_SIZE
D. SORT_MULTIBLOCK_READ_COUNT

Answer: A

QUESTION NO: 3
Which statement could require a sort?

A. SELECT DISTINCT dept_id FROM emp:
B. UPDATE emp SET salary=salary*1.1 WHERE id 7722;
C. SELECT emp_id, name FROM empWHERE emp-id= 7722;
D. SELECT emp_id, name FROM emp WHERE emp_id BETWEEN 7722 and 7100;

Answer: A