Pass4side Oracle 1Z0-033最新考试题库分享（2）

考题内容摘自www.pass4side.cn 更新时间：2008-9-17
6. You have reserved memory within the Shared Pool by using the SHARED_POOL_RESERVED_SIZEparameter 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_FAILUREScolumn 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 KEEPpool?
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 objectsthat 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 allowfor object growth
Answer:: D

8. ABC Corp. plans to build an online transaction processing (OLTP) system. The company plans to tune all thecomponents during the development life cycle.From the list given below, identify the order in which the components should be tuned.1. logical and physical model2. cursor sharing3. Oracle instance memory structures4. operating system5 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 systemwas rigorously tested during the development phases.What is the first recommended activity that the DBA should perform before starting to monitor the performance ofthe system on a regular basis?A.running SQL*TraceB.collecting baseline statisticsC.analyzing indexes and user tablesD.arranging meetings with users once each two weeks to discuss performanceAnswer:: B10. 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 systemsE.minimize parallelism for online transaction processing (OLTP) systems
Answer:: ABD