BIS245 Week 2 Quiz 2017

Question

Question 1.1. (TCO 2) How many data types does Access recognize? (Points : 4)

Five

Seven

Nine

10

Question 2.2. (TCO 2) Which of the following does NOT describe a many-to-many relationship? (Points : 4)

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.3. (TCO 2) SQL is (Points : 4)

nonprocedural and record oriented.

nonprocedural and table oriented.

procedural and object oriented.

procedural and record oriented.

Question 4.4. (TCO 3) A relational table includes the following conditions EXCEPT (Points : 4)

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.5. (TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access? (Points : 4)

Date/Time data types need no delimiters.

Date/Time data types need to be enclosed in single quotes.

Number data types require no delimiters.

Text data types require pound signs.

Question 6.6. (TCO 3) A Text data type has a maximum character size of (Points : 4)

50.

200.

255.

Limited only by memory

Question 7.7. (TCO 3) All of the following are true about the Indexed property EXCEPT (Points : 4)

an example of a setting is Yes (Duplicates OK).

indexed records are scanned sequentially.

indexing a table speeds the retrieval time.

primary keys must be indexed.

Question 8.8. (TCO 4) Which of the following is NOT an example of a primary key? (Points : 4)

ISBN number for a textbook

Last name

Social Security Number

Student ID

Question 9.9. (TCO 4) To ensure that a value of 15 or greater was entered into a field, you would use a (Points : 4)

field size.

field type.

Sarbanes-Oxley Act.

validation rule.

Question 10.10. (TCO 2) What is the special character called to represent one or more characters in the Criteria area of a query? (Points : 4)

Delimiter

Operand

Wildcard

Operator