BIS 245 Final Exam

$29.00

BIS 245 Final Exam 
(CO 4) What is a relational database management system and how does it relate to a database administrator? (Points : 40)…

SKU: BIS 245 Final Exam DeVry Categories: , Tags: , ,

Description

BIS 245 Final Exam

BIS 245 Final Exam

A+

(CO 1) A primary key is

A field or set of fields that uniquely identifies a record

The key used to uniquely identify a record in a table

A key that uniquely identifies columns in a table

A nonunique value

(CO 1) The navigation pane allows you to

Open tables

Open views

Filter by datatype

Filter by group and navigate to category

(CO 1) A detail line is used to

Print more detailed information on one record only

Provide additional field information on a record

Repeat data for each record in the record source

All of the above

(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 value 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) A single crow’s foot at the left-most end of a relationship line would indicate

A many-to-many relationship

A one-to-many relationship

A one-to-one relationship

No relationship

(CO 2) Which of the following is NOT a database system?

Relational

Network

SQL

Hierarchical

(CO 3) All of the following are reasons to save first name and last name as separate fields except

Fewer fields are used

First name could be used in a salutation

Last name could be used in a salutation

You can sort on last name then first name

(CO 3) The following data type would appear as a checkbox in a table

Group of answer choices

Attribute

Number

Text

Yes/No

(CO 3) Which of the following does NOT describe a caption property?

 A label can substitute for a field name in datasheet view

The caption appears in datasheet view, form, and report

The label allows spaces between words

The label can be used in place of a field name in an expression

(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) Which of the following does NOT describe the following description of a one-to-one relationship?

Description:
Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols

The tables must have exactly the same fields

The Employees and NewEmployees tables use the same primary key

More tables can be joined to either table

It may be used for security reasons to protect data availability

(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 describes a poor design consideration for a form?

Arrange controls closely together or in a sequence that is easy to read by the user with consistent formatting

Each form should have a different theme

Make labels descriptive and clear

Right-align labels followed by a colon and left-align bound controls

(CO 6) After running a query, which view will be shown?

Datasheet

Design

Query

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 8) All of the following describe how a Navigation Form is used except

Click the create tab and then navigation in the forms group to create a navigation form

Is another term for a specific report

Helps users open forms and reports

Has the look and feel of a web form

(CO 9) A digital signature

Helps confirm who created the file, that the file is valid, and that no changes have been made to the file once it is authenticated

Is used with database files exclusively

Is a tracking system of a file activity

Must be obtained from a certification authority, such as VeriSign

BIS 245 Final Exam

(CO 9) An encrypted file is

Created by scrambling the content

Protected by a password

Saved with a specific file extension

Unreadable if it is opened through a tampering tool or another program

(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.

BIS 245 Final Exam

(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) To examine the efficiency and performance of an Access database, you should

Migrate the database out of Access and into a larger DBMS

Move the database to its own dedicated server

Redesign your database applying 3NF principles

Use the performance analyzer and table analyzer to optimize the performance of the database

BIS 245 Final Exam

 (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.

BIS 245 Final Exam

(CO 1) Describe three-tier architecture. Explain the functions performed by each tier

(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) Conceptual design begins with a big-picture view and details gradually added before the implementation process begins. With this in mind, what is the first step in the conceptual design process for ERD construction? In your own words, describe how you would accomplish this first step

(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 4) Explain a one-to-many relationship, and provide two examples

(TCO 1) Which object would you use to enter, delete, or modify data? (Points : 5)

Criteria

Form
Query

Table

(TCO 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

(TCO 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

(TCO 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.

BIS 245 Final Exam

(TCO 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

(TCO 2) A field that uniquely identifies each record in a table is a (Points : 5)

Link

Relationship

Primary key

Foreign key

(TCO 2) A symbol used in ER diagrams for an entity is a (Points : 5)

Box

Diamond

Line

Triangle

(TCO 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.

(TCO 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.

BIS 245 Final Exam

(TCO 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.
(TCO 4) When building a calculated field, formulas can be created using the (Points : 5)

Form Wizard

Expression Builder

Report Builder

Table Wizard

(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 : 5)

Datasheet Form

Multiple Items Form

Split Form

Subform

(TCO 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.

BIS 245 Final Exam

(TCO 6) Queries are objects in a database based on one or more underlying (Points : 5)

Forms

Modules

Tables

Macros

(TCO 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.

(TCO 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.
(TCO 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.

(TCO 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

(TCO 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.

BIS 245 Final Exam

(TCO 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.
(TCO 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.

(TCO 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.

BIS 245 Final Exam

(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)

BIS 245 Final Exam

DeVry