saint acc303 quiz 6
saint acc303 quiz 6
.At the time
that a user starts to input data into a database, an “input mask” for a
telephone number in an Access database might look like: (Points : 4)
( ) xxx-xxx-xxxx.
( ) abc-def-ghij.
( ) ( _ _ _ ) _ _ _ - _ _ _ _.
( ) none of these.
|
Question 2. 2.
Within a database context, the relationship between “military
officer” and “private” would most likely be: (Points : 4)
|
( )
one-to-one.
( ) one-to-many.
( ) many-to-one.
( ) many-to-many.
|
|
Question 3. 3.
The purpose of the E-R model is to help database designers:
(Points : 4)
|
( )
identify data redundancies.
( ) create databases in third normal
form.
( ) design databases and depict data relationships.
( ) answer structured queries about
the data in accounting databases.
|
|
Question 4. 4.
Which punctuation mark delineates the separation between a
calculated field name and the formula for that field? (Points : 4)
|
( )
Colon
( ) Space
( ) Asterisk
( ) Dash
|
|
Question 5. 5.
In the E-R model, the primary record key of a file is indicated
by: (Points : 4)
|
( )
an asterisk.
( ) underlining.
( ) using a square.
( ) printing the term (e.g., part
number) in italics.
|
|
Question 6. 6.
Assume that an accounts receivable application contains database tables
for customer orders, inventory items, customers, and salespersons.
All of these would be likely data fields in a customer order table except:
(Points : 4)
|
( )
customer name
( ) customer number
( ) date of order
( ) order number
|
|
Question 7. 7.
One purpose of a data manipulation language is to: (Points : 4)
|
( )
create data fields.
( ) define the record structure.
( ) create queries on the data.
( ) all of these.
|
|
Question 8. 8.
What is the first step in creating a report? (Points : 4)
|
( )
Determining what information to display
( ) Analyzing the available information
( ) Restructuring the database
( ) Analyzing the database
|
|
Question 9. 9.
Manual forms, in terms of database form design, are: (Points : 4)
|
( )
archaic.
( ) used to guide the development of electronic forms.
( ) used to collect information
electronically.
( ) used by many offices already.
|
|
Question 10. 10.
The value that a database will use if the user does not
provide an alternate value is called a(n): (Points : 4)
|
( ) asset value.
( ) text value.
( ) control value.
( ) default value.
Solution: saint acc303 quiz 6