BIS 245|BIS 245 FINAL EXAM BIS 245 FINAL EXAM

BIS 245/BIS 245 FINAL EXAMBIS 245 FINAL EXAM ATTEMPT HISTORY Attempt Time Score LATEST Attempt 1 128 minutes 212 out of 270 Score for this quiz: 212 out of 270 Submitted Jun 23 at 8:10am This attempt took 128 minutes. Question 1 5 / 5 pts (CO 1) Which object would you use to enter, delete, or modify data? CriteriaCorrect! Form Calculation Report Question 2 5 / 5 pts (CO 1) Which of the following means not equal to 30? > 30 = 30 >< 30 Correct! <> 30 Question 3 5 / 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 tool options Blank Report tool Correc Report Wizard tool Question 4 5 / 5 pts (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 5 / 5 pts (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 5 / 5 pts (CO 2) Which of the following is NOT a database system? Hierarchical Network Relational Correct! SQL Question 7 5 / 5 pts (CO 2) Which of the following is supported by a primary key? Changeable over time May be nullCorrect! Unique identifier Updateable Question 8 5 / 5 pts (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 5 / 5 pts (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 5 / 5 pts (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 0 / 5 pts (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 0 / 5 pts (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 5 / 5 pts (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 0 / 5 pts (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 0 / 5 pts (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 0 / 5 pts (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 5 / 5 pts (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 0 / 5 pts (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 5 / 5 pts (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 5 / 5 pts (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 0 / 5 pts (CO 10) ACCDE files 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 0 / 5 pts (CO 4) Which statement below is NOT true of the one-to-many relationships in the database description below? Description: Image Description: Three tables are pictured: Table 1: Order details with primary keys of OrderID and ProductID and fields: UnitPrice, Quantity, and Discount. Table 2: Orders with an OrderID primary key and fields of CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, and ShipCountry. Table 3: Customer has a primary key of CustomerID, Fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, and Fax. There is a relationship labeled with the infinity symbol attached to the OrderDetails (Table 1) and also attached with a number 1 to the orders table (Table 2). There is also a relationship with the infinity symbol beginning at orders table (Table 2) and connected to the customers table (Table 2) using a 1. Correct Answer It is the least used type of relationship. OrderID is a unique identification number that would be used in the orders table and order details table. You Answered Each record in the orders table may match one, more than one, or no records in the order details table. Each record in an orders table matches only one record in the customers table. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. Question 23 37 / 40 pts (CO 1) Describe the client/server architecture. Explain the client role. Explain the server role. Give an example. Your Answer: A client/server architecture is a computing model that server hosts, delivers and manages resources to be used by a client. This architecture will have more than one client resources connected to a main server over a internet connection. Client provides an interface to allow computer users to request services from other servers to display results. An example would be: electronics that connects to the internet and the internet that is sending information to the server. laptop, smart phone, iPad, Smart watch + Internet + Server Teacher Answer: Client/server architecture distributes computer workloads between service requesters (clients) and service providers (servers). An example could be found in a bank. Bank tellers would not be expected to have every account on their terminal at the branch because this information would have to be stored on each machine, and the information would become out-of-date very quickly. Thus, bank tellers use a client computer to make a balance request to a server, which stores customer information. Question 24 40 / 40 pts (CO 2) Explain the purpose of a conceptual database model, and describe the most common method of creating one. Your Answer: Conceptual database model is a data level summary that is mostly used on strategic data projects and sometimes called a conceptual model. Thinking product, location, and assets which is designed and developed for primarily for a business audience that contains multiple entities that is limited to a number of described attributes. Teacher Answer: The purpose of a conceptual database model is to serve as a generic description of data that is not tied to any specific software product. The most common method of creating one is through the creation of a diagram, which is a pictorial representation of the database. These diagrams, referred to as entity-relationship diagrams, or ERDs, make it easier to comprehend the relationships among items in the database. Question 25 25 / 40 pts (CO 4) Explain the importance of determining relationships before establishing primary keys in the design sequence. Your Answer: Every table include a number of columns that uniquely identifies each row stored in the table. This is usually called a unique identification number, of which an employee ID number, social security number, DoD number or any personal ID number that can identify a person. In database this is called the primary key of the table. Access uses primary keys field to quickly associate data from multiple tables and will combine all the data to a whole. A primary key should always have a value. If a column's value become unassigned or missing a value, it can't be used as a component in a primary key. Having a primary key whose value will not change will be beneficial. In a database that uses more than one table, a table’s primary key can be used as a reference in other tables. Teacher answer: The ER diagram must follow a systematic process in order to create a robust model. A design model must first determine the relationships to show that every table must connect to at least one other table in the database. Once this basic forum has been established, keys may be defined to show how the relationships are connected. See the Week 3 Lesson. Question 26 40 / 40 pts (CO 4) What is a relational database management system, and how does it relate to a database administrator? Your Answer: Relational database system is a program that will let you create, update and administer a relational database of data that will be stored in tables. The data being stored in tables will enables the database administrator to use a software to store and organize the data with easily. Teacher answer: The relational database management system (RDBMS) is the software that runs on the database server. The software allows for creation and maintenance of databases. A database administrator (DBA) runs the RDBMS to create and maintain the databases. Quiz Score: 212 out of 270