PL/SQL   «Prev  Next»

Varray Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. In what forms can Oracle store a varray?
Please select the best answer.
  A. BLOB only
  B. Raw data only
  C. Both raw data and BLOB
  D. Neither raw data nor BLOB

2. What explains why it is more efficient to use a nested table than a varray?
Please select the best answer.
  A. A nested table allows you to update parts of the data, whereas updating parts of the data is not allowed within a varray.
  B. A varray allows you to update parts of the data, whereas updating parts of the data is not allowed within a nested table.
  C. Neither a varray nor a nested table allows you to update parts of the data.
  D. Both a varray and a nested table allow you to update parts of the data.

3. If the application requires querying and modifying the entire collection, which collection: 1) nested table or 2) varray is the better alternative?
Please select the best answer.
  A. A nested table is the better alternative.
  B. It does not matter, you can use either.
  C. Neither are good alternatives.
  D. A varray is the better alternative.

Correct answers:

Your Score: 0