Question 1

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Question 2

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Accepted Answer

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Question 3

Structured query language compiles all of the metadata about the data elements in the data model.

Accepted Answer

Data dictionary compiles all of the metadata about the data elements in the data model.

Question 4

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

Accepted Answer

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Question 5

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Accepted Answer

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Question 6

Integrity constraints are rules that help ensure the quality of information.

Accepted Answer

Integrity constraints are rules that help ensure the quality of information.

Question 7

A DBMS provides details about data.

Accepted Answer

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

Question 8

The physical view of information deals with the physical storage of information on a storage device.

Accepted Answer

The physical view of information deals with the physical storage of information on a storage device.

Question 9

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Question 10

Information integrity is a measure of the quality of information.

Accepted Answer

Information integrity is a measure of the quality of information.

Question 11

A foreign key uniquely identifies a given record in a table.

Accepted Answer

Primary key is a field (or group of fields)that uniquely identifies a given record in a table.

Question 12

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Accepted Answer

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Question 13

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Accepted Answer

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Question 14

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Question 15

A field is a collection of related data elements

Accepted Answer

Record is a collection of related data elements

Question 16

hierarchical database model stores information in the form of logically related two-dimensional tables.

Accepted Answer

Relational database model stores information in the form of logically related two-dimensional tables.

Question 17

The logical view of information deals with the physical storage of information on a storage device.

Accepted Answer

The physical view of information deals with the physical storage of information on a storage device.

Question 18

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Accepted Answer

Foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Question 19

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Accepted Answer

Relational databases offer many advantages over using a text document or a spreadsheet, which include increased flexibility and increased scalability and performance.

Question 20

Entities are the data elements associated with an attribute.

Accepted Answer

Attributes (also called columns or fields)are the data elements associated with an entity.

Quiz 6: Data: Business Intelligence

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Structured query language compiles all of the metadata about the data elements in the data model.

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Integrity constraints are rules that help ensure the quality of information.

A DBMS provides details about data.

The physical view of information deals with the physical storage of information on a storage device.

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Information integrity is a measure of the quality of information.

A foreign key uniquely identifies a given record in a table.

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

A field is a collection of related data elements

hierarchical database model stores information in the form of logically related two-dimensional tables.

The logical view of information deals with the physical storage of information on a storage device.

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Entities are the data elements associated with an attribute.