.png){kind=logo}
1 Copyright © 2012 Pearson Education, Inc.Hands-On Database (Conger) Chapter 1 Who Needs a Database?
1.1 Multiple-Choice Questions
1) A good definition for a database is:
- A collection of related data
- A piece of software for managing databases
- A text file with values delimited by commas
- A card catalogue
Answer: A
Diff: 1 Page Ref: 2
2) Which best describes a delimited file?
- A file where each piece of data is alloted the same amount of space
- A file with limited size
- A file where the data fields are separated by some character such as a comma
- A simple text file
Answer: B
Diff: 1 Page Ref: 2
3) Which description best describes a fixed length file?
- A file where every piece of data is alloted the same amount of space
- A file with limited size
- A file where data fields are separated by some character such as a comma
- A simple text file
Answer: A
Diff: 2 Page Ref: 2
4) Redundancy refers to what database condition?
- A primary key is repeated in another table as a foreign key
- All data is stored in tables
- The same data is recorded in more than one place in the same database
- 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?
- Oracle
- Edgar Codd
- Bill Gates
- Steve Jobs
Answer: C
Diff: 1 Page Ref: 4 (Hands-On Database 1e Steve Conger) (Test Bank all Chapters) 1 / 4
2 Copyright © 2012 Pearson Education, Inc.6) Which best defines the function of a primary key?
- It uniquely identifies each record
- It is always a number
- It is the first field in a table
- 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 foreign key is a key that doesn't belong in the table
- A foreign key is the primary key of one table repeated in another table in order to create a
- A foreign key is redundant data
- A foreign key is a field telling what language the data is in
relationship between the tables
Answer: C
Diff: 2 Page Ref: 4,5
8) Which best defines the function of SQL in a database?
- It is the language relational databases use to query the database
- It is the language relational databases use to create database objects and to manipulate and
- It is a language like Java or C# for creating applications
- It is the name of Microsoft's relational database manager
retrieve data
Answer: B
Diff: 2 Page Ref: 4
9) Which of the following is one of Codd's principles?
- All data must be numerical
- Tables must have no more than 1000 rows
- Logical design must match physical design
- 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 visitor key
- A foreign key
- A second primary key
- Just another column
Answer: B
Diff: 2 Page Ref: 4,5 2 / 4
3 Copyright © 2012 Pearson Education, Inc.
11) A column or columns that uniquely identifies each row in a table is called:
- A foreign key
- An ID
- A primary key
- None of the above
Answer: C
Diff: 2 Page Ref: 4
12) Which of the following is one of the chief drawbacks of relational databases?
- The inherent complexity
- The expense of the software
- Mastering SQL
- Naming conventions
Answer: A
Diff: 2 Page Ref: 4
13) Which part of a statement of work defines all the broad requirements for a project?
- History
- Statement of scope
- Tasks and timeline
- Objectives
Answer: B
Diff: 2 Page Ref: 12, 13
14) Which best describes what the history section of a statement of work does?
- It provides a description of the broad requirements of the database project
- It provides a complete history of the company
- It provides backgrounds on the people involved in the project
- It provides a background for the issues and problems that led to the decision to develop a new
database
Answer: D
Diff: 2 Page Ref: 12, 13
15) Which of the following best describes the function of a statement of scope?
- It defines the project requirements down to the smallest details
- It says what software and systems will be used in the project
- It defines all the broad requirements of a project
- It defines what limits the project will have
Answer: C
Diff: 3 Page Ref: 8 3 / 4
4 Copyright © 2012 Pearson Education, Inc.
16) When estimating times for tasks it is a good practice to:
- Determine the best time and the worst and then make your estimate with an edge toward the
- Always assume that everything will go perfectly
- Assume that everything that can go wrong will go wrong
- Pick an estimate from thin air
worst
Answer: A
Diff: 2 Page Ref: 12
17) Which of the following is the best way to begin identifying the topics of a database?
- Sit down and begin drawing a relational diagram
- Look at the project notes and identify all the nouns, then group them into themes
- Ask the client what they think the database objects should be
- Just assume it has the same objects most other databases have
Answer: B
Diff: 2 Page Ref: 10-11
18) Which of the following is it important to document?
- The design of the database
- The process of developing the database
- Both A and B
- None of the above
Answer: C
Diff: 2 Page Ref: 15
19) Which of the following best describes the function of a project notebook?
- To keep and organize all the documentation related to the project
- To keep a diary of time spent working on the project
- A place to shove extra paper
- To keep track of invoices and receipts
Answer: A
Diff: 2 Page Ref: 15
20) A database entity can best be described as:
- The person responsible for the database
- The database itself
- Something the database is concerned with about for which data can be stored
- Something that describes a person or process
Answer: C
Diff: 2 Page Ref: 10 21) Which of the following is the best definition for a database attribute?
- A principle the database must follow
- One of the features of a database
- Something the database is concerned about for which data can be stored
- Something that describes some part of an entity
Answer: D
Diff: 3 Page Ref: 11
- / 4
.png)