Hands-On Database (Conger)
Chapter 1 Who Needs a Database?
1.1 Multiple-Choice Questions
1) A good definition for a database is:
A) A collection of related data
B) A piece of software for managing databases
C) A text file with values delimited by commas
D) A card catalogue
Answer: A
Diff: 1 Page Ref: 2
2) Which best describes a delimited file?
A) A file where each piece of data is alloted the same amount of space
B) A file with limited size
C) A file where the data fields are separated by some character such as a comma
D) A simple text file
Answer: B
Diff: 1 Page Ref: 2
3) Which description best describes a fixed length file?
A) A file where every piece of data is alloted the same amount of space
B) A file with limited size
C) A file where data fields are separated by some character such as a comma
,D) A simple text file
Answer: A
Diff: 2 Page Ref: 2
4) Redundancy refers to what database condition?
A) A primary key is repeated in another table as a foreign key
B) All data is stored in tables
C) The same data is recorded in more than one place in the same database
D) You have more than one database devoted to the same thing
Answer: D
Diff: 3 Page Ref: 2
5) Who first defined the principles of a relational database?
A) Oracle
B) Edgar Codd
C) Bill Gates
D) Steve Jobs
Answer: C
Diff: 1 Page Ref: 4
,6) Which best defines the function of a primary key?
A) It uniquely identifies each record
B) It is always a number
C) It is the first field in a table
D) It unlocks the data in a table
Answer: A
Diff: 2 Page Ref: 4
7) What best describes the function of a foreign key?
A) A foreign key is a key that doesn't belong in the table
B) A foreign key is the primary key of one table repeated in another table in order to
create a relationship between the tables
C) A foreign key is redundant data
D) A foreign key is a field telling what language the data is in
Answer: C
Diff: 2 Page Ref: 4,5
8) Which best defines the function of SQL in a database?
A) It is the language relational databases use to query the database
B) It is the language relational databases use to create database objects and to manipulate
and retrieve data
C) It is a language like Java or C# for creating applications
D) It is the name of Microsoft's relational database manager
Answer: B
Diff: 2 Page Ref: 4
, 9) Which of the following is one of Codd's principles?
A) All data must be numerical
B) Tables must have no more than 1000 rows
C) Logical design must match physical design
D) Logical design must be kept separate from physical design
Answer: D
Diff: 3 Page Ref: 4
10) When a primary key is repeated in a second table to make a relationship it is called:
A) A visitor key
B) A foreign key
C) A second primary key
D) Just another column
Answer: B
Diff: 2 Page Ref: 4,5
Chapter 1 Who Needs a Database?
1.1 Multiple-Choice Questions
1) A good definition for a database is:
A) A collection of related data
B) A piece of software for managing databases
C) A text file with values delimited by commas
D) A card catalogue
Answer: A
Diff: 1 Page Ref: 2
2) Which best describes a delimited file?
A) A file where each piece of data is alloted the same amount of space
B) A file with limited size
C) A file where the data fields are separated by some character such as a comma
D) A simple text file
Answer: B
Diff: 1 Page Ref: 2
3) Which description best describes a fixed length file?
A) A file where every piece of data is alloted the same amount of space
B) A file with limited size
C) A file where data fields are separated by some character such as a comma
,D) A simple text file
Answer: A
Diff: 2 Page Ref: 2
4) Redundancy refers to what database condition?
A) A primary key is repeated in another table as a foreign key
B) All data is stored in tables
C) The same data is recorded in more than one place in the same database
D) You have more than one database devoted to the same thing
Answer: D
Diff: 3 Page Ref: 2
5) Who first defined the principles of a relational database?
A) Oracle
B) Edgar Codd
C) Bill Gates
D) Steve Jobs
Answer: C
Diff: 1 Page Ref: 4
,6) Which best defines the function of a primary key?
A) It uniquely identifies each record
B) It is always a number
C) It is the first field in a table
D) It unlocks the data in a table
Answer: A
Diff: 2 Page Ref: 4
7) What best describes the function of a foreign key?
A) A foreign key is a key that doesn't belong in the table
B) A foreign key is the primary key of one table repeated in another table in order to
create a relationship between the tables
C) A foreign key is redundant data
D) A foreign key is a field telling what language the data is in
Answer: C
Diff: 2 Page Ref: 4,5
8) Which best defines the function of SQL in a database?
A) It is the language relational databases use to query the database
B) It is the language relational databases use to create database objects and to manipulate
and retrieve data
C) It is a language like Java or C# for creating applications
D) It is the name of Microsoft's relational database manager
Answer: B
Diff: 2 Page Ref: 4
, 9) Which of the following is one of Codd's principles?
A) All data must be numerical
B) Tables must have no more than 1000 rows
C) Logical design must match physical design
D) Logical design must be kept separate from physical design
Answer: D
Diff: 3 Page Ref: 4
10) When a primary key is repeated in a second table to make a relationship it is called:
A) A visitor key
B) A foreign key
C) A second primary key
D) Just another column
Answer: B
Diff: 2 Page Ref: 4,5
