BIS 245 Final Exam Week 8 (version 1) complete questions & answers - DeVry University, New York.

BIS 245 Final Exam Week 8. Question 1 (CO 1) A primary key is a field or set of fields that uniquely identifies a record. the key used to uniquely identify a record in a table. a key that uniquely identifies ...

BIS 245 Final Exam Week 8. Question 1 (CO 1) A primary key is a field or set of fields that uniquely identifies a record. the key used to uniquely identify a record in a table. a key that uniquely identifies columns in a table. a nonunique value. Question 2 (CO 1) Which object would you use to retrieve customers who live in Germany and the United States? Criteria Form Query Table Question 3 (CO 1) The navigation pane allows you to open tables. open views. filter by datatype. filter by group and navigate to category. Question 4 (CO 1) Which of the following is a question that you should ask before you create an Access report? What is the purpose of the report? Who will use the report? How will the report be distributed? All of the above questions should be asked. Question 5 (CO 1) A Report section that is used to summarize grouped field data is detail. group header. group footer. report footer. Question 6 (CO 2) A table is also recognized as a(n) cardinality. domain. entity. key. Question 7 (CO 2) SQL is a fourth-generation language that is flat-file oriented and nonprocedural. oriented toward static data. procedural and record oriented. table oriented and nonprocedural. Question 8 (CO 3) A property that provides a user-friendly name to a column in datasheet view is a(n) caption. default value. input mask. rule. Question 9 (CO 3) All of the following applies to data redundancy except it requires updating in two locations. data is always linked in two tables. output could be incorrect if the first and second locations of the same data are not updated. the same data exists in two tables. Question 10 (CO 3) Which of the following does NOT describe a caption property? A label can substitute for a field name in datasheet view. The caption appears in datasheet view, form, and report. The label allows spaces between words. The label can be used in place of a field name in an expression. Question 11 (CO 4) Which of the following does NOT describe the following description of a one-to-one relationship? 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. The tables must have exactly the same fields. The Employees and NewEmployees tables use the same primary key. More tables can be joined to either table. It may be used for security reasons to protect data availability. Question 12 (CO 5) All of the following describe form usage except a form user should have less input errors than a table user. a form can show data from only one table. forms restrict data entry to one record at a time. you can create Access forms to match paper forms. Question 13 (CO 5) A bound control always contains a label. contains text and number values entered by the user. is unique and contains a data field from another underlying source. must contain a formula. Question 14 (CO 6) Which of the following is a term used to describe a calculated field? Function Identifier Operator Value Question 15 (CO 6) After running a query, which view will be shown? Datasheet Design Query Result Question 16 (CO 9) All of the following are drawbacks to normalization, except less tables and larger columns. CPU usage. memory usage. input/output resources. Question 17 (CO 2) Which of the following statements best describes data mining? It is the determining of future volume of sales. It is the predicting of future customer buying behavior. It is identifying patterns or relationships through a process of analyzing large quantities of data. It is tracking customer purchasing behavior. Question 18 (CO 8) All of the following describe how a Navigation Form is used except click the create tab and then navigation in the forms group to create a navigation form. is another term for a specific report. helps users open forms and reports. has the look and feel of a web form. Question 19 (CO 9) An encrypted file is created by scrambling the content. protected by a password. saved with a specific file extension. unreadable if it is opened through a tampering tool or another program. Question 20 (CO 9) When a user creates his or her own self-signed digital signature, only a commercial service or local server for processing will work. only provides users proof that the software can be trusted. it is created through anyone. it will prove that the creator does not own the database. Question 21 (CO 10) The table analyzer tool does this for your database. Will not improve the database Make suggestions to create another report Make suggestions to minimize duplication of data Make suggestions to create another query Question 22 (CO 4) The term cascading refers to data changes travel from one table to another. data is put in sequential order. queries can retrieve data at a faster rate. records are arranged in order.