Question 1. When building a database, you should first create and input the design of the table and reports at the same time.
determine the input and then design the tables.
determine the output and then design the tables.
input the data and then design the reports.
Question 2. Which of the following does NOT describe a many-to-many relationship?
There must be at least two tables.
Many matching records exist in each direction between the tables.
A junction table is used.
You can connect to tables in other databases such as Oracle.
Question 3. SQL is
nonprocedural and record oriented.
nonprocedural and table oriented.
procedural and object oriented.
procedural and record oriented.
Question 4. A relational table includes the following conditions EXCEPT
column entries and attributes must be the same data type.
rows must be in order.
cells contain a single data value.
columns or attributes have a well defined range of values.
Question 5. In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?
11/12/2011
12/11/2011
#12/11/2011#
Between #10/01/2011# And #11/12/2011#
Question 6. Which data type will increment automatically each time a new record is entered into a table?
AutoNumber
Currency
Date/Time
Number
Question 7. All of the following are true about a property EXCEPT
a Datasheet View is used to display properties.
referenced as an attribute.
changes can be made with a property sheet.
tables, forms, queries, and reports can have properties.
Question 8. Which of the following is NOT true of a hire date field?
A hire date is considered a constant.
A hire date would be defined as a date/time field.
Date arithmetic can be applied to a hire date field.
The years of service field, which shows how long an employee has been with the company.
Question 9. Storage space for a field is reserved with the
PNPI.
field size property.
indexed property.
validation rule property.
Question 10. Which of the following is a property that determines how much physical storage the field requires in the database?
Caption
Field Size
Input Mask
Validation Rule