Question
devry bis245 week 2 Quiz latest 2016 may
1. Question : (TCO 2) 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. Question : (TCO 2) All of the following describe a large database system EXCEPT
different users may have different levels of access to data in the database.
simultaneous logging into a database is not recommended.
multiple users in the database are common.
the database could be split into a front and back end.
Question 3. Question : (TCO 2) Columns in an Access table are called
fields.
records.
relation.
tuples.
Question 4. Question : (TCO 3) 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. Question : (TCO 3) 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. Question : (TCO 3) Which data type will increment automatically each time a new record is entered into a table?
AutoNumber
Currency
Date/Time
Number
Question 7. Question : (TCO 3) 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. Question : (TCO 4) Which of the following is NOT an example of a primary key?
ISBN number for a textbook
Last name
Social Security Number
Student ID
Question 9. Question : (TCO 4) Which of the following is NOT an Access data type?
Text
Currency
Name
Date/Time
Question 10. Question : (TCO 2) In Access, which item below is NOT considered a logical operator?
Equal
And
Not
Or