Object Tables   «Prev  Next»

Querying Object Tables - Quiz

Each question is worth one point. Select the best answer for each question.
 
1. What is the difference between varrays and nested tables?
Please select the best answer.
  A. A varray is an object. A nested table is a relational table.
  B. A varray is an array that can be defined only within PL/SQL. A nested table is a persistent object within the database.
  C. A varray has a predefined set of elements. A nested table can have any number of elements.
  D. A varray can have any number of elements. A nested table has a predefined set of elements.

2. l If an object table has an object type within another object type, how will you query the object table?
Please select the best answer.
  A. Use a simple SELECT statement.
  B. Use dot notation to drill down to the attribute of the object type.
  C. You cannot query such an object table.
  D. Use the REF and VALUE operators.

3. l Can you use enumeration types to index collections within Oracle8i?
Please select the best answer.
  A. No, because collections can have only one dimension and you must use integers to index them.
  B. Yes, because collections can have multiple dimensions.
  C. No, because although collections can have multiple dimensions, Oracle8i does not support indexing them by enumeration types.
  D. Yes, because indexing collections within Oracle8i is similar to indexing arrays in Pascal and Ada.
Correct answers:

Your Score: 0