Data Dictionary   «Prev  Next»

DBA Performance Tools - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. Which V$ view contains global accumulated statistical information about the Oracle database?
Please select the best answer.
  A. V$SYSSTAT
  B. V$SGASTAT
  C. V$SESSION
  D. V$LIBRARYCACHE

2. Which view can be interrogated to see if a table can take another extent? Please select the best answer.
  A. V$SESSION
  B. DBA_TABLESPACES and DBA_TABLES
  C. DBA_VIEWS
  D. DBA_DATA_FILES and DBA_SEGMENTS

3. What are listed as conditions that the DBA would want to be alerted to? (Choose all that apply)
Please select all the correct answers.
  A. Objects that cannot take another extent
  B. Object has high extents
  C. Too many connected sessions
  D. Tablespace is getting too full

4. This question is based on the script we created in the "How to build an alert monitor" simulation shown below. What best describes the method for detecting objects with more than 600 extents?

alert monitor simulation final code Please select the best answer.
  A. Viewing the NEXT_EXTENT column of DBA_OBJECTS
  B. Viewing the NEXT_EXTENT column of DBA_TABLES
  C. Viewing the EXTENTS columns of DBA_SEGMENTS
  D. Viewing the MAX_EXTENTS columns of DBA_TABLES