Data Structures   «Prev  Next»

Object Data Constructs - Quiz

Select the best answer or answers for each question.
 
1. What Oracle data construct allows related data items to be grouped together? Please select all the correct answers.
  A. OIDs
  B. ADTs
  C. Nested tables
  D. VARRAYs in tables

2. Which were listed as Oracle constructs that would help Oracle performance? (Choose all that apply)
Please select all the correct answers.
  A. Data columns of the data type OID
  B. Nested tables
  C. Tables with VARRAY data types
  D. Tables with MAXEXTENTS UNLIMITED

3. What time consuming operation do the Oracle object constructs help to avoid?
Please select the best answer.
  A. Expensive index range scans
  B. Expensive fetches by ROWIDs
  C. Expensive SQL table JOINs
  D. Expensive full-table scans