Question 1

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Accepted Answer

A) True 
 B)False

Question 2

A foreign key is essential in relational databases to represent the relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 3

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

First, the database designer creates a t

Question 4

A group of similar rows or records in a table is called a field.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

Accepted Answer

A)  lost-update problem 
B)  crow's-foot paradigm 
C)  bullwhip effect 
D)  update query problem 
A)  lost-update problem 
B)  crow's-foot paradigm 
C)  bullwhip effect 
D)  update query problem

Question 6

A user does not need user account credentials to access and process a database.

Accepted Answer

A) True 
 B)False

Question 7

When using the relational model to represent two tables, one must ________.

Accepted Answer

A)  add a foreign key to one of the tables 
B)  have more than two identifiers in the model 
C)  establish only N:M relationships between the tables 
D)  use metadata instead of foreign keys 
A)  add a foreign key to one of the tables 
B)  have more than two identifiers in the model 
C)  establish only N:M relationships between the tables 
D)  use metadata instead of foreign keys

Question 8

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A) True 
 B)False

Question 9

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

Accepted Answer

A) True 
 B)False

Question 10

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

Accepted Answer

A) True 
 B)False

Question 11

Explain the role of users in the database development process.

Accepted Answer

A database is a model of how the users v

Question 12

A data model describes data and relationships that will be stored in the database.

Accepted Answer

A) True 
 B)False

Question 13

Identify the open source DBMS product among the following.

Accepted Answer

A)  MySQL 
B)  DB2 
C)  Access 
D)  Oracle Database 
A)  MySQL 
B)  DB2 
C)  Access 
D)  Oracle Database

Question 14

Special data that describes the structure of a database is called metadata.

Accepted Answer

A) True 
 B)False

Question 15

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

Accepted Answer

A) True 
 B)False

Question 16

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

Accepted Answer

A)  development 
B)  recovery 
C)  adaptation 
D)  operational 
A)  development 
B)  recovery 
C)  adaptation 
D)  operational

Question 17

Columns that are keys to different tables than the ones in which they reside are called ________.

Accepted Answer

A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records 
A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records

Question 18

Browser-based applications are more dynamic and better suited to today's world than older database applications.

Accepted Answer

A) True 
 B)False

Question 19

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Accepted Answer

A) True 
 B)False

Question 20

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

Accepted Answer

A)  primary key 
B)  identifier 
C)  foreign key 
D)  functionally dependent record 
A)  primary key 
B)  identifier 
C)  foreign key 
D)  functionally dependent record

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

A foreign key is essential in relational databases to represent the relationship between two tables.

What are the steps involved in transforming a data model into a relational database design?

A group of similar rows or records in a table is called a field.

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

A user does not need user account credentials to access and process a database.

When using the relational model to represent two tables, one must ________.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

Explain the role of users in the database development process.

A data model describes data and relationships that will be stored in the database.

Identify the open source DBMS product among the following.

Special data that describes the structure of a database is called metadata.

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

Columns that are keys to different tables than the ones in which they reside are called ________.

Browser-based applications are more dynamic and better suited to today's world than older database applications.

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

The Importance of MIS

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

The International Dimension

Filters

Exam 5: Database Processing

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

A foreign key is essential in relational databases to represent the relationship between two tables.

What are the steps involved in transforming a data model into a relational database design?

A group of similar rows or records in a table is called a field.

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

A user does not need user account credentials to access and process a database.

When using the relational model to represent two tables, one must ________.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

Explain the role of users in the database development process.

A data model describes data and relationships that will be stored in the database.

Identify the open source DBMS product among the following.

Special data that describes the structure of a database is called metadata.

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

Columns that are keys to different tables than the ones in which they reside are called ________.

Browser-based applications are more dynamic and better suited to today's world than older database applications.

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

The Importance of MIS

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

The International Dimension

Filters