Table Space Management   «Prev  Next»

Read Only Tablespace in Oracle - Quiz

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

1. You have static map layer data stored in your Oracle database. The data files are on CD-ROM. Which kind of tablespace is most suitable for this kind of data?
Please select the best answer.
  A. Locally managed tablespace
  B. Transportable tablespace
  C. READ ONLY tablespace
  D. READ WRITE tablespace

2. Observe the query below. Looking at the rowid column of the row containing data about the box turtle, find the portion of this rowid representing the row number. Which answer matches the row number?
Please select the best answer.
  B. AAB
  C. AAAIb9
  D. AAA

3. What changes make it faster and easier to execute the command shown below?
Please select all the correct answers.
  A. Only the activity on the tablespace must be complete before the command completes.
  B. All extents are locally managed, saving time.
  C. The tablespace is immediately placed in temporary READ ONLY status.
  D. The tablespace has uniform 25MB extents.

4. Why must index-organized tables use the logical rowid instead of the extended rowid?
Please select the best answer.
  A. The logical rowid is more efficient for storage.
  B. The physical location of a row can change during the row's lifetime.
  C. The data dictionary only stores locally managed rowids.
  D. There is no room for the location of the index in an extended rowid.