Database Monitoring   «Prev  Next»
 

Checking License Compliance - Quiz

1. Why should you care about free space?
Please select the best answer.
  A. Free space is used as a buffer between the database and the operating system.
  B. Without free space, there won't be any data for the DBA_FREE_SPACE view to return.
  C. Free space allows objects in the database such as tables and indexes to grow in size.
  D. Free space is used by Oracle to store data for tables, indexes, and other objects.

2. Which query will return the size of the largest free extent in the USERS tablespace?
Please select the best answer.
  A. SELECT free_space FROM dba_tablespaces WHERE tablespace_name='USERS';
  B. SELECT MAX(bytes) FROM dba_unused_space WHERE tablespace_name='USERS';
  C. SELECT bytes FROM dba_free_space WHERE tablespace_name='USERS';
  D. SELECT MAX(bytes) FROM dba_free_space WHERE tablespace_name='USERS';

3. Why is the size of a tablespace's largest free extent so important?
Please select the best answer.
  A. Only objects with extent sizes larger than the largest free extent will be able to extend.
  B. An upper limit is set on the total amount of free space that can be made available.
  C. The size determines whether an object within that tablespace will be able to extend.
  D. The size setting represents the maximum amount of data that the tablespace can hold for any given object.

4. Which of the following situations can prevent an object from extending?
Please select all the correct answers.
  A. The object's next extent size exceeds the size of the largest free extent in the tablespace.
  B. The minimum extent size for the tablespace exceeds the size of its largest free extent.
  C. The minimum extent size for the tablespace exceeds the next extent size for the object.
  D. The object has already reached the maximum number of extents set for that object.