BIS245 WEEK 8: FINAL EXAM 2022 a grade

BIS245 WEEK 8: FINAL EXAM 2022 a grade Question 1 5 / 5 pts (CO 1) A primary key is a field or set of fields that uniquely identifies a record. a key that uniquely identifies columns in a table. Correct! the key used to uniquely identify a record in a table. a nonunique value. Question 2 5 / 5 pts (CO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue generated from UPS Express box large in November 2017?” Parameter query Primary keys Correct! Table connections or query Foreign keys Question 3 0 / 5 pts (CO 1) Which one of the following tools is the quickest way to create a tabular report in MS Access based on the selected table or query? Report Design tool Correct Answer Report Wizard tool You Answered Blank Report tool Report tool options Question 4 5 / 5 pts (CO 1) Most of the printed documents generated by managers using Access will come from queries. Correct! reports. tables. forms. Question 5 3 / 5 pts (CO 1) A Report section that is used to summarize grouped field data is Correct Answer group footer. report footer. group header. You Answered detail. Question 6 5 / 5 pts (CO 2) A table is also recognized as a(n) domain. Correct! entity. key. cardinality. Question 7 1 / 5 pts (CO 2) SQL is a fourth-generation language that is Correct Answer table oriented and nonprocedural. oriented toward static data. flat-file oriented and nonprocedural. You Answered procedural and record oriented. Question 8 5 / 5 pts (CO 3) Which of the following should be considered when designing a database? How calculated fields are used The relationships between records The relationship between attribute keys Correct! Store data in its smallest parts Question 9 5 / 5 pts (CO 3) The following data type would appear as a checkbox in a table. Attribute