RelationalDBDesign 




Space Management   «Prev  Next»

Oracle space management - Quiz

Select the best answer or answers for each question.
 

1. Which of the following types of segments hold data permanently?
Please select all the correct answers.
  A. Index segment
  B. Rollback segment
  C. Data segment
  D. Temporary segment


2. Which is correct if your database will be primarily holding smaller rows?
Please select the best answer.
  A. Specify a smaller data block size when you create the database.
  B. Specify a larger data block size when you create the database.
  C. The data block size is automatically adjusted for the size of the rows in a table.
  D. The data block size does not matter.

3. How many extents are allocated when you initially create a table?
Please select the best answer.
  A. No extents are allocated.
  B. The number of extents specified as the initial number are allocated when the first row is inserted into the table.
  C. The number of extents specified as the minimum number are allocated immediately.
  D. The maximum number of extents are allocated immediately