BIS245 Week 2 Quiz 2017/BIS245 Week 2 Quiz 2017

QuestionQuestion 1.1. (TCO 2) How many data types does Access recognize? (Points : 4)FiveSevenNine10Question 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 memoryQuestion 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 textbookLast nameSocial Security NumberStudent IDQuestion 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)DelimiterOperandWildcardOperator