Answers to Chapter 1

Reviewing It

1: What is a relational database?
A1: The relational database supports a single, “logical” structure called a relation, a two-dimensional data structure commonly called a table in the database
2: What is the difference between a primary key and a unique key?
A2: Unlike primary keys, unique keys can contain null values
3: Who is considered the father of relational databases? What was the first SQL language called? What company produced the first working relational database?
A3: Dr. E. F. Codd, SEQUEL, Relational Systems, Inc (later became Oracle Corp)
4: The type of SQL used to update data, delete rows, and so on is known as what? The type of SQL used to create objects is known as what?
A4: DML and DDL
5: What is Deja-view?
A5: The ability to produce a result set based on a particular time (utilizing Oracle's read-consistent view mechanism)
6: List-partitioning is useful for what?
A6: partition data based on character data
7: How does Data Pump work?
A7: treat operating-system files as Oracle tables for the purposes of data loading
8: What would be a good use of having multiple buffer pools?
A8: Gives the DBA the ability to further separate various types of object access from other types of object access
9: What is the old name for Net8?
A9: SQL*Net
10: Describe the basic role of DBA Studio.
A10: Oracle click 'n shoot administrative tool
11: Describe Log Miner and what it might be useful for.
A11: Displays information from the Oracle online and archive log files, creates UNDO and REDO SQL, and can audit a variety of user activities.

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

A1: b and d
2: ISAM and VSAM are examples of a network database

True/False

A2: 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

A3: b
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

A4: c
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

A5: False (non-procedural language)
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

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

True/False

A7: True
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

A8: a
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

A9: e.

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

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