home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shelly Cashman Series Ex…s - A Record of Discovery
/
Explore.bin
/
LAB15.TXT
< prev
next >
Wrap
Text File
|
1997-03-12
|
2KB
|
111 lines
Shelly Cashman Series Lab - Designing a Database
Name ____________________________________
Course and Division _______________________
Date ___________________ Page 1 of 2
As you step through the Interactive Lab, answer the following
questions in the spaces provided. For multiple choice
questions, enter the appropriate letter on the blank line.
1. In an inventory database, PART NUMBER would be an
example of a _____________.
a. flat file
b. field
c. record
d. database file
2. A database restricts a user's access to a single file.
True or False? _____________
3. In a hierarchical database, a child can have more than
one parent. True or False? _____________
4. In a _____________ database, data across multiple files
is linked together based on a single field common to each
file.
a. hierarchical
b. object-oriented
c. network
d. relational
5. _____________ are items containing data and the actions
which can be taken on that data.
a. Objects
b. Relations
c. Networks
d. Trees
6. When a user is querying a database, he or she is
_____________.
a. adding a record to the database
b. modifying a record that already exists in the database
c. deleting a record from the database
d. requesting data from the database to display
Shelly Cashman Series Lab - Designing a Database
Page 2 of 2
7. With QBE, a user enters criteria into one or more
_____________.
a. files
b. records
c. fields
d. children
8. SQL stands for _____________.
a. standard query language
b. stored query language
c. structured query language
d. saved query language
9. What type of field information is stored in a data
dictionary?
__________________________________________________________
__________________________________________________________
10. A(n) _____________ records changes made to the database in
a log, which can be used to reconstruct the database in
the event of an accident or malfunction.
a. query language
b. utility program
c. security program
d. recovery program
11. LAST NAME would be a good choice for a key field.
True or False? _____________
12. Explain why default values are used.
__________________________________________________________
__________________________________________________________