Question 1

How does normalization resolve the data integrity problem?

Accepted Answer

Normalization is the process of converting a poorly-structured table into two or more well-structured tables. If an attribute is entered correctly in one row and incorrectly in another, this leads to a problem called a data integrity problem.
The data integrity problem can occur only if data are duplicated. Because of this, one easy way to eliminate the problem is to eliminate the duplication of data. The general goal of normalization is to construct tables such that every table has a single topic or theme. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table.

Question 2

The accuracy of a database design is independent of the corresponding data model.

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the following is true of single-user databases?

Accepted Answer

A)  They are displayed and processed using html5, css3, and JavaScript. 
B)  They use JavaScript for user-side processing. 
C)  The Internet is used to access the DBMS server computer. 
D)  The application, the DBMS, and the database all reside on the user's computer. 
A)  They are displayed and processed using html5, css3, and JavaScript. 
B)  They use JavaScript for user-side processing. 
C)  The Internet is used to access the DBMS server computer. 
D)  The application, the DBMS, and the database all reside on the user's computer. D

Question 4

The data integrity problem occurs only if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 5

Describe a DBMS and its functions. List some of the popular DBMS products.

Accepted Answer

A database management system (DBMS) is a

Question 6

________ 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 7

Which of the following is true of MySQL?

Accepted Answer

A)  It is offered by Oracle. 
B)  It is license-free for most applications. 
C)  It is a closed-source database product. 
D)  It is yet to be widely adopted. 
A)  It is offered by Oracle. 
B)  It is license-free for most applications. 
C)  It is a closed-source database product. 
D)  It is yet to be widely adopted.

Question 8

A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

Accepted Answer

A) True 
 B)False

Question 9

The lost-update problem can be resolved by implementing multi-user database processing.

Accepted Answer

A) True 
 B)False

Question 10

Browser-based applications ________.

Accepted Answer

A)  are thick-client applications 
B)  can only display static content 
C)  support querying using graphics 
D)  process queries using C++ 
A)  are thick-client applications 
B)  can only display static content 
C)  support querying using graphics 
D)  process queries using C++

Question 11

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

Accepted Answer

A)  1:N 
B)  1:1 
C)  N:M 
D)  M:1 
A)  1:N 
B)  1:1 
C)  N:M 
D)  M:1

Question 12

A(n) ________ is a program used to create, process, and administer a database.

Accepted Answer

A)  operating system 
B)  DBMS 
C)  information system 
D)  data mart 
A)  operating system 
B)  DBMS 
C)  information system 
D)  data mart

Question 13

In a database, ________ are grouped into columns.

Accepted Answer

A)  fields 
B)  records 
C)  bytes 
D)  files 
A)  fields 
B)  records 
C)  bytes 
D)  files

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

MySQL is an open source DBMS product that is license-free for most database applications.

Accepted Answer

A) True 
 B)False

Question 16

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M.

Accepted Answer

A) True 
 B)False

Question 17

The purpose of a database is to keep track of things that involve a single theme.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is true of traditional database application programs?

Accepted Answer

A)  Application forms, reports, and queries are displayed and processed using a browser. 
B)  All of the application logic is contained in a program on the database server. 
C)  They are written in object-oriented languages such as C++ and VisualBasic. 
D)  They are thin-client applications that need not be pre-installed on the users' computers. 
A)  Application forms, reports, and queries are displayed and processed using a browser. 
B)  All of the application logic is contained in a program on the database server. 
C)  They are written in object-oriented languages such as C++ and VisualBasic. 
D)  They are thin-client applications that need not be pre-installed on the users' computers.

Question 19

In a data model, a(n) ________ is something that a user wants to track.

Accepted Answer

A)  record 
B)  byte 
C)  entity 
D)  primary key 
A)  record 
B)  byte 
C)  entity 
D)  primary key

Question 20

Normalized tables are faster to process than tables that haven't been normalized.

Accepted Answer

A) True 
 B)False

How does normalization resolve the data integrity problem?

The accuracy of a database design is independent of the corresponding data model.

Which of the following is true of single-user databases?

The data integrity problem occurs only if data are duplicated.

Describe a DBMS and its functions. List some of the popular DBMS products.

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

Which of the following is true of MySQL?

A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

The lost-update problem can be resolved by implementing multi-user database processing.

Browser-based applications ________.

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

A(n) ________ is a program used to create, process, and administer a database.

In a database, ________ are grouped into columns.

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

MySQL is an open source DBMS product that is license-free for most database applications.

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M.

The purpose of a database is to keep track of things that involve a single theme.

Which of the following is true of traditional database application programs?

In a data model, a(n) ________ is something that a user wants to track.

Normalized tables are faster to process than tables that haven't been normalized.

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

How does normalization resolve the data integrity problem?

The accuracy of a database design is independent of the corresponding data model.

Which of the following is true of single-user databases?

The data integrity problem occurs only if data are duplicated.

Describe a DBMS and its functions. List some of the popular DBMS products.

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

Which of the following is true of MySQL?

A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

The lost-update problem can be resolved by implementing multi-user database processing.

Browser-based applications ________.

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

A(n) ________ is a program used to create, process, and administer a database.

In a database, ________ are grouped into columns.

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

MySQL is an open source DBMS product that is license-free for most database applications.

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M.

The purpose of a database is to keep track of things that involve a single theme.

Which of the following is true of traditional database application programs?

In a data model, a(n) ________ is something that a user wants to track.

Normalized tables are faster to process than tables that haven't been normalized.

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