Examen
Hands-On Database 2nd Edition By Steve Conger (Test Bank)
- Cours
- Établissement
Hands-On Database 2e Steve Conger (Test Bank) Hands-On Database 2e Steve Conger (Test Bank)
[Montrer plus]
Vendeur
S'abonner
tutorsection
Avis reçus
Aperçu du contenu
(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.
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur tutorsection. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €15,26. Vous n'êtes lié à rien après votre achat.
Peut-on faire confiance à Stuvia ?
4.6 étoiles sur Google & Trustpilot (+1000 avis)
66579 résumés ont été vendus ces 30 derniers jours
Fondée en 2010, la référence pour acheter des résumés depuis déjà 14 ans