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 B

Question 2

A spreadsheet should be used to store data with multiple themes.

Accepted Answer

A) True 
 B)False  False

Question 3

A ________ is a collection of forms, reports, queries, and programs that process a database.

Accepted Answer

A)  database application 
B)  database design 
C)  data field 
D)  data model 
A)  database application 
B)  database design 
C)  data field 
D)  data model A

Question 4

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 5

A data model describes data, whereas a database explains the relationships among the data that will be stored in the database.

Accepted Answer

A) True 
 B)False

Question 6

________ is an example of a personal DBMS.

Accepted Answer

A)  SQL Server 
B)  DB2 
C)  Oracle Database 
D)  Access 
A)  SQL Server 
B)  DB2 
C)  Oracle Database 
D)  Access

Question 7

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which of the following database administration tasks is related to adaptation?

Accepted Answer

A)  monitoring backup procedures 
B)  conducting training for users 
C)  monitoring database performance 
D)  managing configuration changes in systems 
A)  monitoring backup procedures 
B)  conducting training for users 
C)  monitoring database performance 
D)  managing configuration changes in systems

Question 10

A data model is a ________.

Accepted Answer

A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs to retrieve data 
A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs to retrieve data

Question 11

SQL is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The rows in a database are called ________.

Accepted Answer

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

Question 14

In a database, when data items disagree with one another, this leads to a(n)________.

Accepted Answer

A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  lost-update problem 
A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  lost-update problem

Question 15

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 16

A DBMS is a software that helps to manage the operating system.

Accepted Answer

A) True 
 B)False

Question 17

Data entry forms are used to read, insert, modify, and delete data.

Accepted Answer

A) True 
 B)False

Question 18

A database must have only one application, though the application can have one or more users.

Accepted Answer

A) True 
 B)False

Question 19

When you modify or delete data present in a database, you are ________.

Accepted Answer

A)  creating a new database 
B)  forming a data model 
C)  simplifying the data structure 
D)  processing the database 
A)  creating a new database 
B)  forming a data model 
C)  simplifying the data structure 
D)  processing the database

Question 20

A(n)________ DBMS is designed to process large organizational and workgroup databases.

Accepted Answer

A)  operational 
B)  process 
C)  personal 
D)  enterprise 
A)  operational 
B)  process 
C)  personal 
D)  enterprise

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

A spreadsheet should be used to store data with multiple themes.

A ________ is a collection of forms, reports, queries, and programs that process a database.

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

A data model describes data, whereas a database explains the relationships among the data that will be stored in the database.

________ is an example of a personal DBMS.

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

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

Which of the following database administration tasks is related to adaptation?

A data model is a ________.

SQL is an international standard language for processing a database.

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

The rows in a database are called ________.

In a database, when data items disagree with one another, this leads to a(n)________.

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

A DBMS is a software that helps to manage the operating system.

Data entry forms are used to read, insert, modify, and delete data.

A database must have only one application, though the application can have one or more users.

When you modify or delete data present in a database, you are ________.

A(n)________ DBMS is designed to process large organizational and workgroup databases.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Structured Processes and Information Systems

Social Media Information Systems

Business Intelligence Systems

Business Process and Information Systems Development

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 spreadsheet should be used to store data with multiple themes.

A ________ is a collection of forms, reports, queries, and programs that process a database.

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

A data model describes data, whereas a database explains the relationships among the data that will be stored in the database.

________ is an example of a personal DBMS.

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

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

Which of the following database administration tasks is related to adaptation?

A data model is a ________.

SQL is an international standard language for processing a database.

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

The rows in a database are called ________.

In a database, when data items disagree with one another, this leads to a(n)________.

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

A DBMS is a software that helps to manage the operating system.

Data entry forms are used to read, insert, modify, and delete data.

A database must have only one application, though the application can have one or more users.

When you modify or delete data present in a database, you are ________.

A(n)________ DBMS is designed to process large organizational and workgroup databases.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Structured Processes and Information Systems

Social Media Information Systems

Business Intelligence Systems

Business Process and Information Systems Development

Information Systems Management

Information Security Management

The International Dimension

Filters