6. You are working on the performance tuning of your database. Which two types of performance tuning-related information would an alert log file provide? (Choose two.)
A.mean time to recover
B.latch contention information
C.instance recovery start and complete times
D.SQL statements that are consuming maximum resources
E.the top five sessions that are consuming maximum resources
ANSWER: AC
7. What is the effect of setting the FAST_START_MTTR_TARGET initialization parameter?
A.A higher value for the FAST_START_MTTR_TARGET initialization parameter results in less time spent on reading redo during instance startup.
B.A lower value for the FAST_START_MTTR_TARGET initialization parameter results in more time spent on reading redo during instance startup.
C.A lower value for the FAST_START_MTTR_TARGET initialization parameter results in an increase in the frequency of the DBWRn process writing dirty buffers.
D.A higher value for the FAST_START_MTTR_TARGET initialization parameter results in the LGWR process writing redo log buffers faster.
ANSWER: C
8. 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
9. You have objects that have a variable reference pattern. These are referenced vigorously for some time, and then not referenced at all for a long time. As a result, these objects are being aged out from Oracle memory buffers frequently. Which two strategies would you recommend to avoid aging out of erratically accessed objects? (Choose two.)
A.increasing PGA size
B.increasing large pool size
C.increasing buffer cache size
D.creating RECYCLE cache using the DB_RECYCLE_CACHE_SIZE parameter
E.creating a KEEP cache using the DB_KEEP_CACHE_SIZE parameter and altering the objects to that cache
ANSWER: CE
10. Which two statements are correct regarding users in a shared server environment? (Choose two.)
A.Connections can share dispatcher processes.
B.Multiplexing and pooling can be used for user connections.
C.It is advantageous for sessions performing batch operations.
D.The CPU overhead is reduced for each individual user request.
E.Multiple users cannot share the dispatcher processes to access the Oracle server.
ANSWER: AB
Tags:
Post comment:
◎welcome to give out your point。