Exam 1: Overview of Database Concepts

Partial dependency can only exist if the data is uniquely identified by a composite primary key.

A record in the logical design of a database is represented by what in the physical database?

A record in the logical design of a database corresponds to a ____ in the physical database.

Two tables can be linked or joined together through a common field.

A(n) ____________________ is a common field between two tables and is also a primary key for one of the tables.

_________________________ is a data sublanguage that processes sets of data.

A file is referred to as a(n) ____________________ in an Oracle10g database.

Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?

A record in the logical design of a database corresponds to a row in the physical table of a relational database.

SQL commands can be issued in Oracle11g through ____________________ which is an interface that allows users to interact with the database.

A straight line with a crow's foot at one end depicts a(n) ____________________ relationship in an E-R Model.

Which of the following may contain repeating groups of data?

A(n) ____________________ relationship means data can have multiple occurrences in both entities.

Which of the following can lead to partial dependencies?

The occurrence of data anomalies would indicate an unnormalized database design.

Which of the following is an example of an attribute?

Data is in second normal form if it is in first normal form and has no ____________________.

Structured Query Language (SQL) is generally used to interact with a database.

The steps used to design and develop a database are commonly referred to as the ______________________________.

A(n) ____________________ relationship cannot exist in a physical relational database.