考题内容摘自 更新时间：2008-9-17
6. You have reserved memory within the Shared Pool by using the SHARED_POOL_RESERVED_SIZE
parameter to accommodate large space allocations while compiling PL/SQL blocks and database triggers.
While observing the performance of the reserved area, you find that the value of the REQUEST_FAILURES
column in the V$SHARED_POOL_RESERVED view is continuously increasing.
Which statement is true in this scenario?
A.The parsing of the statement fails due to invalidations.
B.The execution of the statement fails due to invalidations.
C.The space allocated for the reserved area is not enough.
D.The syntax in the PL/SQL blocks is causing the compilation failure.
Answer:: C
7. You need to size the KEEP pool. Which calculation would you use to determine the initial size of the KEEP
pool?
A.50% of the DEFAULT pool
B.50% of the RECYCLE pool
C.the total number of blocks of all the candidate objects that you need in the KEEP pool / the number of objects
that you need in the KEEP pool
D.total number of blocks of all the candidate objects that you need in the KEEP pool + additional space to allow
for object growth
Answer:: D
8. ABC Corp. plans to build an online transaction processing (OLTP) system. The company plans to tune all the
components during the development life cycle.
From the list given below, identify the order in which the components should be tuned.
1. logical and physical model
2. cursor sharing
3. Oracle instance memory structures
4. operating system
5 data file I/O
A.1, 2, 3, 5, 4
B.1, 3, 2, 4, 5
C.1, 2, 3, 4, 5
D.1, 2, 5, 3, 4
Answer:: A
9. ABC Corp. has an online transaction processing (OLTP) system that has just gone into production. The system
was rigorously tested during the development phases.
What is the first recommended activity that the DBA should perform before starting to monitor the performance of
the system on a regular basis?
A.running SQL*Trace
B.collecting baseline statistics
C.analyzing indexes and user tables
D.arranging meetings with users once each two weeks to discuss performance
Answer:: B
10. When tuning a database server, which three goals should you focus on? (Choose three.)
A.minimize response time for OLTP users
B.maximize throughput for batch processing
C.minimize response time for batch processing
D.increase load capability for the decision-support systems
E.minimize parallelism for online transaction processing (OLTP) systems
Answer:: ABD
阅读(111) | 评论(0) | 转发(0) |
