1. You determined that the values for REQUEST_FAILURES as seen from V$SHARED_POOL_RESERVEED is more than zero and always increasing. Which action would be appropriate?
A. Increase the value for the LARGE_POOL_SIZE parameter. B. Decrease the value for the LARGE_POOL_SIZE parameter. C. Increase the value for the SHARED_POOL_RESERVED_SIZE parameter. D. Decrease the value for the SHARED_POOL_RESERVED_SIZE parameter. Answer:
2.What does this statement do? SQL> ANALYZE INDEX index_name VALIDATE STRUCTURE;
A. It places information into the INDEX_STATS view and allows for the monitoring of space used by an index. B. It provides information in the INDEX_HISTOGRAM view to indicate whether an index is invalid or valid. C. It provides information in the DBA_INDEXED view for the COST BASED Optimizer when choosing an execution plan. Answer:
3. On database that is running Multithreaded Server, which view would you query to get information for users with shared server connections?
A. V$CIRCUIT B. DBA_USERS C. DBA_CIRCUIT D. V$DISPATCHER_USERS E. DBA_DISPATCHER_USERS Answer:
4. Which action could potentially cause checkpoints to take longer? A. increasing the number of redo log groups B. increasing the size of rollback segments C. decreasing the value of the REDO_LOG_BUFFERS parameter D. increasing the value of the FAST_START_IO_TARGET parameter Answer:
5.Which two views would you query to monitor session-related statistics? (Choose two.)
A. V$SESSTAT B. V$SESSION_EVENT C. V$SESSION_STATS D. V$SESSION_STATUS E. V$WAITS_PER_SESSION Answer:
6.The database includes tables with static data which are used for queries only. To which size should you set PCTFREE for this type of table?
