BIS245 FINAL EXAM_LATEST,100% CORRECT

Document Content and Description Below

5 / 5 pts (CO 1) MS Visio is used during database design for the following reasons. It calculates formulas. Correct! It depicts entities and relationships between entities. I ... t sets reports. It can query information. Question 2 5 / 5 pts (CO 1) In a table, the _____ view is where you add, edit, and delete records. SQL layout Correct! datasheet design Question 3 5 / 5 pts (CO 1) When creating a report in Access, what report tool best outlines the following description? This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. Blank report tool Tabular layout report Label tool Correct! Report wizard Question 4 0 / 5 pts (CO 1) All of the following filters work except filter by form with a comparison operator. filter by selection with an equal condition. You Answered filter by selection with a comparison operator. Question 5 0 / 5 pts (CO 1) A detail line is used to All of the above You Answered print more detailed information on one record only. provide additional field information on a record. repeat data for each record in the record source. Question 6 5 / 5 pts (CO 2) A field that uniquely identifies each record in a table is a relationship. Correct! primary key. link. foreign key. Question 7 5 / 5 pts (CO 2) SQL is a fourth-generation language that is procedural and record oriented. flat-file oriented and nonprocedural. Correct! table oriented and nonprocedural. oriented toward static data. Question 8 5 / 5 pts (CO 3) Which of the following should be considered when designing a database? The relationship between attribute keys Correct! Store data in its smallest parts How calculated fields are used The relationships between records Question 9 5 / 5 pts (CO 3) All of the following applies to data redundancy except output could be incorrect if the first and second locations of the same data are not updated. it requires updating in two locations. Correct! data is always linked in two tables. the same data exists in two tables. Question 10 5 / 5 pts (CO 3) Which of the following is NOT true of indexed property? An example of a setting is yes (no duplicates). Indexing a table speeds the retrieval time. Correct! Setting the index requires each record to be scanned sequentially and saves time searching data. Primary keys must be indexed. Question 11 5 / 5 pts (CO 4) When building a calculated field, formulas can be created using the report builder. table wizard. form wizard. Correct! expression builder. Question 12 0 / 5 pts (CO 5) To edit a form, use datasheet view. design view. You Answered layout view. wizard view. Question 13 5 / 5 pts (CO 5) The following are form creation tools except Correct! form layout. form wizard. form design. blank form. Question 14 0 / 5 pts (CO 6) Which of the following statements is NOT correct about a query? You Answered Instructions on which data to display are saved within a query. Changing data values in a query will not change data values in a table. Instructions on the format to display data are saved within a query. Data is not saved within a query. Question 15 5 / 5 pts (CO 6) Using the rules for order of operations, what is the result of the following expression: (4 * 3) +1 + 4 - 2 * 3 + 5? 50 Correct! 16 18 11 Question 16 0 / 5 pts (CO 9) All of the following are drawbacks to normalization, except input/output resources. CPU usage. less tables and larger columns. You Answered memory usage. Question 17 5 / 5 pts (CO 2) A required field that is used in entering data is a field that appears with a specific value. can be left blank. is selected from a list of values. Correct! cannot be left blank. Question 18 0 / 5 pts (CO 8) All of the following describe how a Navigation Form is used except is another term for a specific report. You Answered click the create tab and then navigation in the forms group to create a navigation form. helps users open forms and reports. has the look and feel of a web form. Question 19 5 / 5 pts (CO 9) A good password should have Correct! a combination of six to eight letters in uppercase and lowercase, numbers, and symbols. part of your account name. a combination of five letters. a word or name that is easy to remember by the user, such as the name of their children. Question 20 5 / 5 pts (CO 9) All of the following describe a digital signature certification authority except a certification authority is a commercial company that is highly regulated in most countries. Correct! certification authority companies establish their own rules and regulations that users must follow. a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database. a fee is charged for the service of issuing and validating identities using a digital signature. Question 21 0 / 5 pts (CO 10) ACCDE files give users permission to fully access a database. You Answered give users permission to create and change forms and reports within a database. deny users permission to create forms and reports but will allow them to modify forms and reports. deny users permission to change data but not modify a database. Question 22 5 / 5 pts (CO 4) Which database property type helps keep data consistent when doing data entry? Correct! Validation rule Expression Indexed Validation text Question 23 Not yet graded / 40 pts (CO 1) Designing a database often involves obtaining different perspectives from various sources to gather information. Discuss the importance of end-user interviews in the data requirements gathering process. Question 24 Not yet graded / 40 pts (CO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database. Question 25 Not yet graded / 40 pts (CO 4) What are the advantages and disadvantages of the denormalization process? maintain within a table. Update, insert, and delete queries take a performance hit due to high data volume from redundancy. Redundancy increases storage size causing waste. Lack of referential integrity leads to dirty data. Question 26 Not yet graded / 40 pts (CO 4) Explain 1NF, 2NF, and 3NF as related to database design. [Show More]

Last updated: 3 years ago

Preview 1 out of 14 pages