Exam (elaborations)
Hands-On Database 2nd Edition By Steve Conger (Test Bank)
- Course
- Institution
Hands-On Database 2e Steve Conger (Test Bank) Hands-On Database 2e Steve Conger (Test Bank)
[Show more]
Content preview
(Hands-On Database 2e Steve Conger)(Test Bank all Chapters)
Hands-On Database, 2e (Conger)
Chapter 1 Who Needs a Database?
1.1 Multiple Choice
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: C
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: C
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: B
Diff: 1 Page Ref: 3
1
Copyright © 2014 Pearson Education, Inc.
,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 at 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: B
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
2
Copyright © 2014 Pearson Education, Inc.
,11) A column or columns that uniquely identifies each row in a table is called:
A) A foreign key
B) An ID
C) A primary key
D) 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?
A) The inherent complexity
B) The expense of the software
C) Mastering SQL
D) 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?
A) History
B) Statement of scope
C) Tasks and time line
D) Objectives
Answer: B
Diff: 2 Page Ref: 12, 13
14) Which best describes what the history section of a statement of work does?
A) It provides a description of the broad requirements of the database project
B) It provides a complete history of the company
C) It provides backgrounds on the people involved in the project
D) 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?
A) It defines the project requirements down to the smallest details
B) It says what software and systems will be used in the project
C) It defines all the broad requirements of a project
D) It defines what limits the project will have
Answer: C
Diff: 3 Page Ref: 8
3
Copyright © 2014 Pearson Education, Inc.
, 16) When estimating times for tasks it is a good practice to:
A) Determine the best time and the worst and then make your estimate with an edge toward the
worst
B) Always assume that everything will go perfectly
C) Assume that everything that can go wrong will go wrong
D) Pick an estimate from thin air
Answer: A
Diff: 2 Page Ref: 12
17) Which of the following is the best way to begin identifying the topics of a database?
A) Sit down and begin drawing a relational diagram
B) Look at the project notes and identify all the nouns, then group them into themes
C) Ask the client what they think the database objects should be
D) 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?
A) The design of the database
B) The process of developing the database
C) Both A and B
D) None of the above
Answer: C
Diff: 2 Page Ref: 15
19) Which of the following best describes the function of a project notebook?
A) To keep and organize all the documentation related to the project
B) Keep a diary of time spent working on the project
C) A place to shove extra paper
D) To keep track of invoices and receipts
Answer: A
Diff: 2 Page Ref: 15
20) A database entity can best be described as:
A) The person responsible for the database
B) The database itself
C) Something the database is concerned with, for which data can be stored
D) Something that describes a person or process
Answer: C
Diff: 2 Page Ref: 10
4
Copyright © 2014 Pearson Education, Inc.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller tutorsection. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now