BIS245 WEEK 8: FINAL EXAM_DeVry University, Keller Graduate School of Management - LATEST Attempt 1 _Score for this quiz: 222 out of 270

Document Content and Description Below

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. a nonunique value. Questio... n 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 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 Report Wizard tool 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. reports. tables. forms. Question 5 3 / 5 pts (CO 1) A Report section that is used to summarize grouped field data is group footer. report footer. group header. detail. Question 6 5 / 5 pts (CO 2) A table is also recognized as a(n) domain. entity. key. cardinality. Question 7 1 / 5 pts (CO 2) SQL is a fourth-generation language that is table oriented and nonprocedural. oriented toward static data. flat-file oriented and nonprocedural. 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 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 Yes/No Text Number Question 10 5 / 5 pts (CO 3) Which of the following does NOT describe a caption property? The label allows spaces between words. A label can substitute for a field name in datasheet view. The caption appears in datasheet view, form, and report. The label can be used in place of a field name in an expression. Question 11 5 / 5 pts (CO 4) Which of the following does NOT describe the following description of a one-to-one relationship? FE_IMG55.jpg Description: Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols. It may be used for security reasons to protect data availability. More tables can be joined to either table. The Employees and NewEmployees tables use the same primary key. The tables must have exactly the same fields. Question 12 5 / 5 pts (CO 5) To edit a form, use layout view. design view. wizard view. datasheet view. Question 13 5 / 5 pts (CO 5) The following are form creation tools except form layout. form design. blank form. form wizard. Question 14 5 / 5 pts (CO 6) Queries are objects in a database based on one or more underlying tables. modules. forms. macros. Question 15 2 / 5 pts (CO 6) The benefit of a relationship is to determine which fields to include in each table. efficiently combine data from related tables. minimize data redundancy. facilitate how Access will manage the relationship. Question 16 5 / 5 pts (CO 9) A deletion anomaly is deleting facts about one entity and deleting facts about another entity. deleting a table. deleting only one fact from a column. deleting facts about one entity successfully. Question 17 2 / 5 pts (CO 2) Which of the following statements best describes data mining? It is identifying patterns or relationships through a process of analyzing large quantities of data. It is the predicting of future customer buying behavior. It is the determining of future volume of sales. It is tracking customer purchasing behavior. Question 18 5 / 5 pts (CO 8) A navigation form is a screen that is used to hide objects from users. design tool to analyze and optimize a database. form that looks like a menu or a series of menus that ties objects in a database and helps users look to forms and reports that they are authorized to view. report that looks like a menu or a series of menus that ties objects in a database and is not user friendly. Question 19 0 / 5 pts (CO 9) An encrypted file is created by scrambling the content. unreadable if it is opened through a tampering tool or another program. saved with a specific file extension. protected by a password. Question 20 5 / 5 pts (CO 9) A digital signature helps confirm who created the file, that the file is valid, and that no changes have been made to the file once it is authenticated. must be obtained from a certification authority, such as VeriSign. is a tracking system of a file activity. is used with database files exclusively. Question 21 5 / 5 pts (CO 10) After creating an ACCDE file, you can convert it back to its source format. will see a "file already in use" message that continues to display to all other users. will be able to modify forms and reports but not tables. will need to go back to the original file if an underlying object requires a change. Question 22 5 / 5 pts (CO 4) The term cascading refers to data changes travel from one table to another. data is put in sequential order. records are arranged in order. queries can retrieve data at a faster rate. Question 23 40 / 40 pts (CO 1) Describe three-tier architecture. Explain the functions performed by each tier. Your Answer: A computing architecture consists of the following. (1) Client computers capture user input, send requests for information, and present the results of the request. (2) Application servers enable business logic. (3) Data servers store data that provide data to the application server. Question 24 14 / 40 pts (CO 2) Explain the purpose of a conceptual database model, and describe the most common method of creating one. Your Answer: Question 25 40 / 40 pts (CO 4) Explain the terms entity and attribute. Describe an example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes. Your Answer: Question 26 40 / 40 pts (CO 4) If you were given an ERD that contained a M:N relationship between orders and products, what would you need to do in order to create the tables and relationship in Access? Your Answer: TABLES AND THEIR COLUMN NAMES Order :: OrderID , OrderDate, OrderTotalprice, OrderShipped OrderLine :: OrderID , ProductID, OrderLineUnitsPrice , price PRODUCTS :: ProductID , ProductName, NumberOfUnits, UnitPrice [Show More]

Last updated: 1 year ago

Preview 1 out of 11 pages