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 alert monitor script shown below. What best describes the method for detecting objects with more than 600 extents? 
-- Objects with more than 600 extents
-- Applied NVL function purposely to extents column.
SELECT SUBSTR(owner,        1, 22) owner,
       SUBSTR(segment_name, 1, 30) object_name,
       SUBSTR(segment_type, 1,  8) type,
       extents
FROM dba_segments
WHERE 600 < NVL(extents, 1)
  AND segment_type IN ('TABLE', 'INDEX', 'ROLLBACK')
ORDER BY 1, 3, 4 DESC, 2;

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