Question 1

________ is the process of converting a poorly- structured table into two or more well-structured tables.

Accepted Answer

A) Optimization 
B) Normalization 
C) Refactoring 
D) Standardization 
A) Optimization 
B) Normalization 
C) Refactoring 
D) Standardization

Question 2

A database is best described as a collection of tables which are not related to each other.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is an example of an enterprise DBMS?

Accepted Answer

A) Access 
B) SQL Server 
C) Paradox 
D) FoxPro 
A) Access 
B) SQL Server 
C) Paradox 
D) FoxPro

Question 4

1:N, N:M, and 1:1 are common examples of minimum cardinalities.

Accepted Answer

A) True 
 B)False

Question 5

A database design team transforms entities into tables and expresses relationships by defining ________.

Accepted Answer

A) cardinalities 
B) attributes 
C) foreign keys 
D) departments 
A) cardinalities 
B) attributes 
C) foreign keys 
D) departments

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

An organization buys a proprietary database application to be used by a small workgroup of five people.This is an example of a(n)________ DBMS.

Accepted Answer

A) enterprise 
B) interenterprise 
C) personal 
D) open source 
A) enterprise 
B) interenterprise 
C) personal 
D) open source

Question 8

Which of the following is an international standard language for processing a database?

Accepted Answer

A) Paradox 
B) DB2 
C) SQL 
D) MS Access 
A) Paradox 
B) DB2 
C) SQL 
D) MS Access

Question 9

In an E-R diagram, a line between two entities represents a(n)________.

Accepted Answer

A) attribute 
B) identifier 
C) cardinality 
D) relationship 
A) attribute 
B) identifier 
C) cardinality 
D) relationship

Question 10

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

Accepted Answer

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

Question 11

Which of the following is true about the database development process?

Accepted Answer

A) The database structure cannot be changed during the data modeling stage. 
B) Changing a relationship from 1:N to N:M is simply a matter of changing the notations. 
C) User review of the data model is avoided as it is not helpful in data modeling. 
D) A database is a model of how the developers view their business world. 
A) The database structure cannot be changed during the data modeling stage. 
B) Changing a relationship from 1:N to N:M is simply a matter of changing the notations. 
C) User review of the data model is avoided as it is not helpful in data modeling. 
D) A database is a model of how the developers view their business world.

Question 12

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Accepted Answer

A) True 
 B)False

Question 13

________ is the process of converting a data model into tables, relationships, and data constraints.

Accepted Answer

A) Database design 
B) Database querying 
C) Data mining 
D) Database aggregation 
A) Database design 
B) Database querying 
C) Data mining 
D) Database aggregation

Question 14

Which of the following is an example of a database management system?

Accepted Answer

A) MS Excel 
B) Unix 
C) Ubuntu 
D) Access 
A) MS Excel 
B) Unix 
C) Ubuntu 
D) Access

Question 15

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 16

Which of the following refers to the problem that exists in database applications when two users update 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 17

Describe a database and its various elements.

Accepted Answer

A database is a self-describing collecti

Question 18

Which of the following is the smallest data element in a database?

Accepted Answer

A) field 
B) record 
C) byte 
D) file 
A) field 
B) record 
C) byte 
D) file

Question 19

Microsoft's SQL Server is an example of a personal DBMS product.

Accepted Answer

A) True 
 B)False

Question 20

The format of metadata depends on the software product that is processing the database.

Accepted Answer

A) True 
 B)False

________ is the process of converting a poorly- structured table into two or more well-structured tables.

A database is best described as a collection of tables which are not related to each other.

Which of the following is an example of an enterprise DBMS?

1:N, N:M, and 1:1 are common examples of minimum cardinalities.

A database design team transforms entities into tables and expresses relationships by defining ________.

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

An organization buys a proprietary database application to be used by a small workgroup of five people.This is an example of a(n)________ DBMS.

Which of the following is an international standard language for processing a database?

In an E-R diagram, a line between two entities represents a(n)________.

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

Which of the following is true about the database development process?

The general goal of normalization is to construct tables such that every table has a single topic or theme.

________ is the process of converting a data model into tables, relationships, and data constraints.

Which of the following is an example of a database management system?

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

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

Describe a database and its various elements.

Which of the following is the smallest data element in a database?

Microsoft's SQL Server is an example of a personal DBMS product.

The format of metadata depends on the software product that is processing the database.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 5: Database Processing

________ is the process of converting a poorly- structured table into two or more well-structured tables.

A database is best described as a collection of tables which are not related to each other.

Which of the following is an example of an enterprise DBMS?

1:N, N:M, and 1:1 are common examples of minimum cardinalities.

A database design team transforms entities into tables and expresses relationships by defining ________.

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

An organization buys a proprietary database application to be used by a small workgroup of five people.This is an example of a(n)________ DBMS.

Which of the following is an international standard language for processing a database?

In an E-R diagram, a line between two entities represents a(n)________.

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

Which of the following is true about the database development process?

The general goal of normalization is to construct tables such that every table has a single topic or theme.

________ is the process of converting a data model into tables, relationships, and data constraints.

Which of the following is an example of a database management system?

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

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

Describe a database and its various elements.

Which of the following is the smallest data element in a database?

Microsoft's SQL Server is an example of a personal DBMS product.

The format of metadata depends on the software product that is processing the database.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters