Exam 1: Clientserver Databases and the Oracle10g Relational Database

When a personal database is shared by more than one user,where do the database files typically reside?

How many users typically use a personal database?

A ____ does not perform any processing - it sends keyboard input and displays output from a central computer.

The purpose of normalization is to store data efficiently in the least possible amount of space.

In a relational database,relationships are created using ____________________ keys.

A terminal is a program that requests and uses server resources.

When is a table considered to be in 3NF?

What is a partial dependency and how do you remove it?

The Oracle 10g ____________________ is used for developing database applications.

A composite key usually comprises fields that are foreign keys in other tables.

A(n)____________________ is a program that listens for requests for resources from clients and responds to those requests.

In a relational database,relationships among entities are established through ____________________ fields.

A(n)____________________ key is a unique key that you create by combining two or more columns.

A(n)____________________ key has no real relationship to the row to which it is assigned,other than to identify the row uniquely.

The final step in the normalization process is to convert the tables to fourth normal form (4NF).

Data is considered to be normalized as long as a primary key has been designated.

____________________ is the dominant personal database on the market today.

When the DBMS and the database applications run on the same workstation and appear to the user as a single integrated application this is known as a(n)____________________ database.

In an ER diagram a 1:M relationship shows a simple straight line between two entities.

Relationships between entities in database tables are maintained using key fields.