DeVry University, New York - BIS 245 - Final Exam (Latest) Already Graded A+

Document Content and Description Below

(CO 1) A foreign key is A field in one table that is also the primary key of another table. Another name for a candidate key. A value that can connect two tables simultaneously. A unique v... alue that identifies each row within a table. (CO 1) In what situation would Access be a better choice than Excel? You have an extensive amount of data. You need to conduct extensive statistical analyses on your data. You have a limited amount of data. You require a flat file view of your data. (CO 1) The number of sections Access creates for a report is Five Six. Three. Four. (CO 2) Which of the following is NOT a database system? Relational Network SQL Hierarchical (CO 3) All of the following describe a caption property except The caption appears in datasheet, report, and form views. Can take the place of a field name in datasheet view. Can be used in place of a field name in an expression. Allows for placing spaces between words. (CO 3) Which of the following does NOT apply to the following description of an image? Image Description: Three tables are pictured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a primary key of CategoryID and fields: Categoryname, Description, and Picture. There is a relationship labeled 1 attached to Table 1 or suppliers and an infinity symbol attached to Table 2 or products. One table is not joined to the other two tables. A join exists on two primary keys. A one-to-many relationship is applied. The display is showing the design view of relationships. (CO 5) All of the following describe form usage except a form can show data from only one table. you can create Access forms to match paper forms. a form user should have less input errors than a table user. forms restrict data entry to one record at a time. (CO 5) Clicking on the form tool will open a(n) Wizard to design a form. New form in layout view. New form in design view. Existing form. (CO 6) Which of the following statements is NOT correct about a query? Instructions on which data to display are saved within a query. Data is not 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. (CO 9) All of the following are drawbacks to normalization, except Input/output resources. CPU usage. Memory usage. Less tables and larger columns. (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. Switchboard form or navigation form Object Utility Form (CO 9) All of the following describe a digital signature certification authority except 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 certification authority is a commercial company that is highly regulated in most countries. A fee is charged for the service of issuing and validating identities using a digital signature. (CO 1) All of the following are Access objects except Criteria Table Query Form (CO 1) Which of the following means not equal to 30? > 30 = 30 >< 30 <> 30 (CO 1) Which of the following is NOT an Access interface element? Title bar Navigation pane Status bar Criteria (CO 1) Which of the following is NOT a report section? Detail Summary Group footer Page footer (CO 1) A report creation tool that will automatically pull in the fields from a table or query is the Report design. Report wizard. Blank report. Report tool. (CO 2) A field that uniquely identifies each record in a table is Relationship Primary key Link Foreign key (CO 2) SQL is a fourth-generation language that is Table oriented and nonprocedural. Procedural and record oriented. Flat-file oriented and nonprocedural. Oriented toward static data. (CO 3) Which relationship is used most commonly within the database environment? A one-to-many relationship. Many-to-many relationship. One-to-one relationship. Two-to-one relationship. (CO 3) Attributes are better defined as a characteristic of an entity. a description of an entity. a column. All of the above (CO 3) Which of the following is NOT true of indexed property? Setting the index requires each record to be scanned sequentially and saves time searching data. Primary keys must be indexed. Indexing a table speeds the retrieval time. An example of a setting is yes (no duplicates). (CO 4) In terms of data types and their uses, which one of the following is NOT correct? The TEXT data type can be used for Last Name. The Date/Time data type can be used for 10/31/2012. The Currency data type can be used for Account balance. The AutoNumber data type can be used for Customer Name. (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 Split form Multiple items form Subform (CO 5) A calculated control Is an unbound box that the user will fill in with a numeric value. Is a text box containing a description. Is a bound box. Contains a formula that displays the result. (CO 6) Which of the following is a term used to describe a calculated field? Identifier Value Function Operator (CO 6) Data aggregate functions Cannot be used on a row. Return multiple values. Are used to perform calculations on individual records in a table or query. Perform calculations on entire columns of data. (CO 9) Default normalization form 4 takes place When all candidate keys are identified. When all tables are related. When third normal-form includes several candidate keys. When third normal-form has one and only one candidate key, which is a primary key. (CO 2) A required field that is used in entering data is a field that Cannot be left blank. Can be left blank. Is selected from a list of values. Appears with a specific value. (CO 8) All of the following describe how a Navigation Form is used except Is another term for a specific report. Helps users open forms and reports. Has the look and feel of a web form. Click the create tab and then navigation in the forms group to create a navigation form. (CO 9) Of the following security techniques available in Microsoft Access to keep a database application safe, which choice would make the database virtually impossible to break into? Digitally signing and publishing the database Creating a menu system Encrypting and password-protecting the database Saving the database as an ACCDE file (CO 9) Database security is a specialty within computer security that protects a database application from unintended use. Unintended use includes Unauthorized viewing of data. All of the above Malicious attacks. Inadvertent mistakes made by employees. (CO 10) The table analyzer tool does this for your database. Make suggestions to create another query Will not improve the database Make suggestions to create another report Make suggestions to minimize duplication of data (CO 4) Which of the following is NOT true of a ship date field? A ship date would be defined as a date/time field. A ship date would be defined as a calculated field. Date arithmetic can be applied to a ship date field. A ship date is considered a constant. (CO 1) Explain the benefits an organization gains by using a relational database? 40 Points (CO 2) Explain entity integrity and referential integrity. Give an example of each. 40 Points (CO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain how that normal form is often violated by inexperienced database designers and how to correct such a violation of that normal form. 40 Points (CO 4) When constructing a database, two rules are followed by the database designer to ensure the integrity of keys. Describe each rule, and discuss common violations. 40 Points (CO 1) Which object would you use to enter, delete, or modify data? (Points : 5) Criteria Form Query Table (CO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue generated from UPS Express Box Large in November 2013?” (Points : 5) Foreign keys Primary keys Parameter query Table connections (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. (Points : 5) Label Tool Tabular Layout Report Blank Report Tool Report Wizard (CO 1) A filter in Access (Points : 5) Creates a new table with matching criteria. Deletes unique records from the database. Allows the user to edit specific records. Displays a subset of records based on specified criteria. (CO 1) A report creation tool that will automatically pull in the fields from a table or query is the (Points : 5) Report tool Report design Report wizard Blank report (CO 2) A field that uniquely identifies each record in a table is a (Points : 5) Link Relationship Primary key Foreign key (CO 2) A symbol used in ER diagrams for an entity is a (Points : 5) Box Diamond Line Triangle (CO 3) All of the following apply to the relationships image found below EXCEPT Image Description: Three Tables are pcitured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a Primary key of CategoryID and fields: Categoryname, Description and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products. (Points : 5) A one-to-many relationship is found between the Suppliers table and the Products table. A relationship exists between the two primary keys of the Suppliers table and the Products table. One table is not joined to the two other tables. The primary key for the Categories table is CategoryID. (CO 3) All of the following applies to data redundancy EXCEPT (Points : 5) 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. (CO 3) Which of the following does NOT apply to the following relationship image? Image Description: Three Tables are pictured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a primary key of CategoryID and fields: Categoryname, Description, and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products. (Points : 5) A one-to-many relationship is applied. The display is showing the Design view of relationships. One table is not joined to the other two tables. A join exists on two primary keys. (CO 4) When building a calculated field, formulas can be created using the (Points : 5) Form Wizard Expression Builder Report Builder Table Wizard (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? (Points : 5) Datasheet Form Multiple Items Form Split Form Subform (CO 5) A bound control (Points : 5) 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. (CO 6) Queries are objects in a database based on one or more underlying (Points : 5) Forms Modules Tables Macros (CO 6) The benefit of a relationship is to (Points : 5) Efficiently combine data from related tables. Facilitate how Access will manage the relationship. Determine which fields to include in each table. Minimize data redundancy. (CO 9) Default normalization form 4 takes place (Points : 5) when third normal-form has one and only one candidate key, which is a primary key. when third normal-form includes several candidate keys. when all candidate keys are identified. when all tables are related. (CO 2) A validation rule (Points : 5) Can prohibit values from being entered that may not meet a criterion. Compares a field to a table. Is an error message that appears when a value is incorrectly entered into a field. Makes a value entered into a field appear in a particular format. (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. (Points : 5) Form Utility Switchboard Object (CO 9) Open Exclusive means that (Points : 5) A password is required to open the Access database. Only one person has access to the Access database at any time. Only selected persons can have access to the Access database. Two or more people cannot open the same Access database at the same time. (CO 9) All of the following are true when a user creates his or her own self-signed digital signature EXCEPT (Points : 5) A time stamp is not required to go through a commercial service or local server for processing. A time stamp will prove when the file was last used. It is created through another software application. It will prove that the creator owns the database. (CO 10) After creating an ACCDE file, you (Points : 5) Can convert it back to its source format. Will see a “file already in use” message that continues to display to all other users. Will be able to modify forms and reports but not tables. Will need to go back to the original file if an underlying object requires a change. (CO 4) Which statement below is NOT true of the one-to-many relationships? 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. (Points : 5) 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. 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. (CO 1) What role do databases play in today’s business world and why are they important? Provide two specific examples of how a database might be used by a business. 40 pts (CO 1) Explain the organization of data in relational databases in terms of tables, records (rows), and fields (columns). Give an example of a table and specify its fields. Which field(s) would you choose as the primary key of that table? (Points : 40) (CO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database. (Points : 40) (CO 4) Explain the importance of determining relationships before establishing primary keys in the design sequence. (Points : 40) (CO 4) What is a relational database management system and how does it relate to a database administrator? (Points : 40) [Show More]

Last updated: 1 year ago

Preview 1 out of 7 pages