BIS 245 Final Exam practice questions and answers solution 2020

Document Content and Description Below

BIS 245 Final Exam practice questions and answers solution 2020 1. Question : (TCO 1) Which object would you use to enter, delete, or modify data? Points Received: 5 of 5 Comments: ... 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Points Received: 5 of 5 Comments: 3. Question : (TCO 1) To design a report you should do all of the following EXCEPT Points Received: 5 of 5 Comments: 4. Question : (TCO 1) Which of the following is NOT a Report Section? Points Received: 5 of 5 Comments: 5. Question : (TCO 1) A Detail line is used to Points Received: 0 of 5 Comments: 6. Question : (TCO 2) For the following image, which of the following is TRUE? Points Received: 5 of 5 Comments: 7. Question : (TCO 2) A symbol used in ER diagrams for an entity is a Points Received: 5 of 5 Comments: 8. Question : (TCO 3) A property that provides a "user friendly" name to a column in Datasheet View is a Points Received: 5 of 5 Comments: 9. Question : (TCO 3) Summarized data in an easy-to-read view is known as a Points Received: 0 of 5 Comments: 10. Question : (TCO 3) Which of the following is NOT true of a property? Points Received: 0 of 5 Comments: 11. Question : (TCO 4) Which of the following does NOT describe the following one-to-one relationship? Points Received: 5 of 5 Comments: 1. Question : (TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics? Points Received: 0 of 5 Comments: 2. Question : (TCO 5) A calculated control Points Received: 5 of 5 Comments: 3. Question : (TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties? Points Received: 5 of 5 Comments: 4. Question : (TCO 6) Data aggregates Points Received: 5 of 5 Comments: 5. Question : (TCO 7) When making vertical data comparisons, you should use the following chart. Points Received: 5 of 5 Comments: 6. Question : (TCO 7) Discrete data Points Received: 5 of 5 Comments: 7. Question : (TCO 8) A switchboard is a Points Received: 5 of 5 Comments: 8. Question : (TCO 9) To secure an Access database, all of the following should be done EXCEPT Points Received: 5 of 5 Comments: 9. Question : (TCO 9) All of the following describe a certification authority EXCEPT Points Received: 5 of 5 Comments: 10. Question : (TCO 10) Which of the following file format types removes all VBA code from the database and prohibits users from making changes to forms and reports? Points Received: 5 of 5 Comments: 11. Question : (TCO 4) The term "cascading" refers to Points Received: 5 of 5 Comments: 1. Question : (TCO 1) Describe three-tier architecture. Explain the functions performed by each tier. Points Received: 40 of 40 Comments: ok 2. Question : (TCO 2) Explain business logic and describe how it relates to a relational database. Points Received: 40 of 40 Comments: ok 3. Question : (TCO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain (1) how that normal form is often violated by inexperienced database designers and (2) how to correct such a violation of that normal form. Points Received: 40 of 40 Comments: ok 4. Question : (TCO 4) Explain 1NF, 2NF, and 3NF as related to database design. Points Received: 40 of 40 Comments: ok [Show More]

Last updated: 2 years ago

Preview 1 out of 27 pages