BIS 245 Final complete (version 2) complete questions & answers - latest 2019/20.

BIS 245 FINAL EXAM Score for this quiz: 212 out of 270 Question 1 (CO 1) Which object would you use to enter, delete, or modify data? CriteriaCorrect! Form Calculation Report Question ...

BIS 245 FINAL EXAM Score for this quiz: 212 out of 270 Question 1 (CO 1) Which object would you use to enter, delete, or modify data? CriteriaCorrect! Form Calculation Report Question 2 (CO 1) Which of the following means not equal to 30? > 30 = 30 >< 30 Correct! <> 30 Question 3 (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 tool options Blank Report tool Correc Report Wizard tool 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? Correct! All of the above questions should be asked. Question 5 (CO 1) Which of the following is NOT one of the query wizards in Access? Find duplicates query Simple query Correct Multitabular query Crosstab query Question 6 (CO 2) Which of the following is NOT a database system? Hierarchical Network Relational Correct! SQL Question 7 (CO 2) Which of the following is supported by a primary key? Changeable over time May be nullCorrect! Unique identifier Updateable Question 8 (CO 3) All of the following describe a caption property except allows for placing spaces between words. can take the place of a field name in datasheet view. Correct! can be used in place of a field name in an expression. the caption appears in datasheet, report, and form views. Question 9 (CO 3) All of the following applies to data redundancy except it requires updating in two locations. Correct! 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 is NOT true of a property? Correct! A property is an object's characteristic or attribute. Tables, forms, queries, and reports have a set of properties. A property sheet is used to make changes. Design properties are displayed in datasheet view. Question 11 (CO 4) In a _____ dependency, a relationship exists when one attribute uniquely identifies another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time, and room number. Course would uniquely identify an instructor. You Answered structural functional referential transitive See the Week 3 Lesson and Chapter 2: Kroenke & Auer Chapter 3 & Glossery. Question 12 (CO 5) Which form type displays records in a tabular format similar to a datasheet view but has more editing options, such as adding graphics? Datasheet form Multiple items form Split form Subform See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. Question 13 (CO 5) Clicking on the form tool will open a(n) existing form. new form in design view. new form in layout view. wizard to design a form. Question 14 (CO 6) Which of the following is a term used to describe a calculated field? Function Identifier Operator Value See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. Question 15 (CO 6) Data aggregate functions You Answered are used to perform calculations on individual records in a table or query. cannot be used on a row. perform calculations on entire columns of data. return multiple values. See Chapter 3: (Grauer) Microsoft Access 2016 Comprehensive. 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. See Chapter 3: Kroenke & Auer Text. 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. Correct! 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) The _____ interface displays a menu that provides the ability to open the various objects within the database and to move easily from one object to another. form utility switchboard form or navigation form object See Week 7 Lesson and Lab. Question 19 (CO 9) To secure an Access database, all of the following should be done except digitally sign a database and open it in a trusted location. require a password to open a database. Correct! run the table analyzing wizard and performance analyzer. save a database with the .accde file extension. 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 deny users permission to change data but not modify a database. deny users permission to create forms and reports but will allow them to modify forms and reports. You Answered give users permission to create and change forms and reports within a database. give users permission to fully access a database. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. Question 22 (CO 4) Which statement below is NOT true of the one-to-many relationships in the database description below? Question 23 (CO 1) Describe the client/server architecture. Explain the client role. Explain the server role. Give an example. Question 24 (CO 2) Explain the purpose of a conceptual database model, and describe the most common method of creating one. Your Answer: Question 25 (CO 4) Explain the importance of determining relationships before establishing primary keys in the design sequence. Question 26 (CO 4) What is a relational database management system, and how does it relate to a database administrator?