Checking It

1:Oracle is (mark all that apply)
  1. A hierarchical database

  2. A network database

  3. A relational database

  4. An Object-oriented database

2:ISAM and VSAM are examples of a network database

True/False

3:Referential integrity is
  1. A relationship enforced at the database level by PL/SQL

  2. A relationship enforced at the database level based on primary and foreign keys

  3. AA relationship enforced at the application level by PL/SQL, Java, or XML

  4. A relationship enforced by using concatenated keys

4:Which of the following statements is true:
  1. COBOL works with groups of records

  2. SQL processes data row at a time

  3. SQL lets you work with data at the logical level

  4. It matters to Oracle the order of the data in the database

5:SQL is a procedural language in that it processes sets of records at a time rather than single records at a time.

True/False

6:Object-oriented support in the Oracle RDBMS was first introduced with which version:
  1. 7.3

  2. 8.0

  3. 8.1

  4. 9.0

7:Resumable SQL allows some Oracle processes/tools to pickup where it left off in the event of space-oriented errors.

True/False

8:A compiler:
  1. Makes machine language from source code

  2. Makes source code from machine language

  3. AMakes runtime interpreters that then read the source code

  4. Makes machine code for runtime interpreters

9:SQL*Plus can:
  1. Process any SQL statement

  2. Handle administrative functions in the database

  3. Can format SQL output into reports

  4. Can take input from a file

  5. All of the above

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.148.104.124