BIS 245 Quiz Week 3

$4.75

BIS 245 Quiz Week 3 
(CO 2) What is the special character called to represent one or more characters…

Description

BIS 245 Quiz Week 3

BIS 245 Quiz Week 3

A+

(CO 2) Physical design refers to

Developing a database model that will support company operations.

Purchasing your hardware components.

Selecting the specific hardware characteristics based on data storage and data access requirements.

The process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
(CO 2) A domain is a

Group of data types that describe what kind of information that may be stored in a field.

Model of the database.

Set of values.

The set of primary and foreign keys in a database.

(CO 2) A one-to-many relationship is

A relationship that guarantees that a record is unique.

An association between a record and its fields.

Used to describe attributes.

When a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.

(CO 2) An associative table is

used to identify primary keys between tables.

a child of two parent tables that are in a many-to-many relationship.

an integrity element within a table relationship.

a tool that allows you to locate an excel file.

(CO 3) What does not define a composite key?

Using two or more fields as a primary key

Using three fields as a primary key

Using two fields as a primary key

Using one field as a primary key

(CO 4) All of the following are examples of primary keys except

employee ID.

social security number.

ISBN number on a textbook.

last name.
(CO 2) Which of the following is an example of an entity in a business?

Company

Business owner

CEO

Employees

(CO 2) Which of the following is NOT a step in the database life cycle?

Database design

Maintenance and redevelopment

Performance

Testing

(CO 3) Database design refers to

Developing a database model that will support company operations.

Focusing on understanding the business and its functional areas or business processes.

Selecting the specific hardware characteristics based on data storage and data access requirements.

The process of converting your ERD into tables, and defining your rows and columns based your entities and attributes.

(CO 2) Which of the following is NOT a step in the database life cycle?

Database design

Maintenance and redevelopment

Performance

Testing

(CO 2) The term cardinality refers to

A count of the total records in a table.

A field which is a candidate for a primary key.

The number of records in a relationship.

The most important field in a table.

(CO 4) Which statement below is NOT true of one-to-many relationships?

It is the least-used type of relationship.

The table with the primary key must only have one occurrence of each value for the primary key.

The foreign key in the related table may have repeating values for the foreign key.

An example is that one employee may take multiple orders.

(CO 4) Which is NOT true of validation rules?

They enforce a size limit.

They check authenticity of data entered in a field.

An error message will appear if a rule is violated.

They protect from fraudulent practices.

(TCO 2) All of the following are questions to ask in the process of identifying entities EXCEPT:

Can you envision more than one instance of the entity?

Is there a variation over time?

Is the item to be modeled a person, place, thing, or an event?

Is the item to be modeled an attribute?

(TCO 2) Logical design refers to

Developing a database model that will support company operations.

Developing a thorough understanding of what needs to be done in developing a database.

Translating the conceptual design into the selected model for use in a database system.

Understanding the business and its functional areas or business processes.

(TCO 3) When troubleshooting a relationship, all of the following should be done EXCEPT

Creating a relationship between like data types.

Checking the size of fields to be used in the relationship.

Checking that the correct type of relationship is established.

Deleting the relationship and field, and then rebuilding.

(TCO 2) All of the following should be considered in designing a relational database EXCEPT

Compliance with PNPI regulations.

Design for safety with redundant data.

Design your database for 100-year usage.

Store data in its smallest parts.

(TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT

A junction (associative) table is used.

Many matching records are found in each direction between tables.

May be used to connect to Oracle and other databases.

There must be at least two tables.

(TCO 2) A primary key

Can be computer generated.

Consists of one field only that uniquely identifies each record in a table.

Is a relationship between two or more tables.

All of the above

(TCO 3) Which of the following does NOT describe data redundancy?

The same data exists in multiple tables.

The data is always in linked tables.

Data updating must be done in multiple table locations.

Data redundancy can result in data anomalies.

(TCO 4) To which of the following does the term cascading refer?

Data changes travel from one table to another.

Data is put in sequential order.

Queries can retrieve data at a faster rate.

Records are arranged in order.

(TCO 4) Which is NOT true of a calculated field?

It cannot be added to queries or reports.

The value of a calculated field is produced from an expression.

A calculated field references other fields.

The result is useful at the moment the calculation is made.

(TCO 4) Which of the following is a special-definition setting used on a field containing an employee’s date of hire?

Date arithmetic

Constant

Date/time field

Calculated field