Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  row 
B)  field 
C)  record, 
D)  row.

Question 3

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

Accepted Answer

A)  column 
B)  row 
C)  table 
D)  file

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of A(n) ____________________ is a common field between...

Question 6

_________________________ is a data sublanguage that processes sets of data.

Accepted Answer

The answer of _________________________ is a data sublanguage that processes...

Question 7

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

Accepted Answer

The answer of A file is referred to as a(n)...

Question 8

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?

Accepted Answer

A)  one-to-many 
B)  many-to-many 
C)  one-to-all 
D)  one-to-one

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The answer of SQL commands can be issued in Oracle11g...

Question 11

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

Accepted Answer

The answer of A straight line with a crow's foot...

Question 12

Which of the following may contain repeating groups of data?

Accepted Answer

A)  unnormalized data 
B)  first normal form (1NF) 
C)  second normal form (2NF) 
D)  third normal form (3NF)

Question 13

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

Accepted Answer

The answer of A(n) ____________________ relationship means data can have...

Question 14

Which of the following can lead to partial dependencies?

Accepted Answer

A)  composite primary key 
B)  common fields 
C)  foreign keys 
D)  normalization

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is an example of an attribute?

Accepted Answer

A)  a person's hair color 
B)  the people who live in a particular town 
C)  the patients in a doctor's office 
D)  vendors

Question 17

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

Accepted Answer

The answer of Data is in second normal form if...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of The steps used to design and develop...

Question 20

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

Accepted Answer

The answer of A(n) ____________________ relationship cannot exist in a...

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.