Question 1

The DBMS provides applications for processing operations such as ________.

Accepted Answer

A)  sending and receiving emails 
B)  writing software programs 
C)  inserting or deleting data 
D)  automating business processes 
A)  sending and receiving emails 
B)  writing software programs 
C)  inserting or deleting data 
D)  automating business processes C

Question 2

Which of the following is a DBMS product from Microsoft?

Accepted Answer

A)  MySQL 
B)  SQL Server 
C)  DB2 
D)  Sybase ASE 
A)  MySQL 
B)  SQL Server 
C)  DB2 
D)  Sybase ASE B

Question 3

A database is a self-describing collection of integrated records.

Accepted Answer

A) True 
 B)False  True

Question 4

A ________ is a self-describing collection of integrated records.

Accepted Answer

A)  datasheet 
B)  spreadmart 
C)  database 
D)  dataspace 
A)  datasheet 
B)  spreadmart 
C)  database 
D)  dataspace

Question 5

MySQL DBMS refers to software systems 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 6

What are the differences between a spreadsheet and a database?

Accepted Answer

The purpose of both a spreadsheet and a

Question 7

Which of the following is a major problem posed by multi-user processing of a database?

Accepted Answer

A)  lack of data integrity 
B)  software redundancy 
C)  lost-update problem 
D)  limited access to data 
A)  lack of data integrity 
B)  software redundancy 
C)  lost-update problem 
D)  limited access to data

Question 8

Which of the following is a drawback of the relational database processing model?

Accepted Answer

A)  It utilizes an extensive amount of storage space. 
B)  It requires powerful processors to function. 
C)  It was never a natural fit with business documents. 
D)  It does not enable document piece-making via normalization. 
A)  It utilizes an extensive amount of storage space. 
B)  It requires powerful processors to function. 
C)  It was never a natural fit with business documents. 
D)  It does not enable document piece-making via normalization.

Question 9

Bytes,which are characters of data,are grouped into rows in a database.

Accepted Answer

A) True 
 B)False

Question 10

Describe the functions of a database management system.

Accepted Answer

A database management system (DBMS)is a

Question 11

Browser database application forms,reports,and queries are displayed and processed using html.

Accepted Answer

A) True 
 B)False

Question 12

In a database,columns are also called ________.

Accepted Answer

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

Question 13

Traditional database application programs are written in object-oriented languages such as C++.

Accepted Answer

A) True 
 B)False

Question 14

To find out what a database contains,one can look at the metadata inside the database.

Accepted Answer

A) True 
 B)False

Question 15

In single-user databases,the application,the DBMS,and the database all reside on a user's computer.

Accepted Answer

A) True 
 B)False

Question 16

How does one create a database and its structures?

Accepted Answer

Database developers use the DBMS to crea

Question 17

One of the important functions of a DBMS is to provide the necessary tools for ________.

Accepted Answer

A)  encrypting e-mails 
B)  encapsulating data objects 
C)  administering the database 
D)  testing program codes 
A)  encrypting e-mails 
B)  encapsulating data objects 
C)  administering the database 
D)  testing program codes

Question 18

In a database,a table,which is a group of similar rows,is also called a ________.

Accepted Answer

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

Question 19

________ is a popular enterprise DBMS product from IBM.

Accepted Answer

A)  DB2 
B)  Access 
C)  SQL Server 
D)  MySQL 
A)  DB2 
B)  Access 
C)  SQL Server 
D)  MySQL

Question 20

Monitoring the performance of a database after providing solutions for improving its performance is a(n)________ of the DBMS.

Accepted Answer

A)  creation function 
B)  modification function 
C)  processing operation 
D)  administrative function 
A)  creation function 
B)  modification function 
C)  processing operation 
D)  administrative function

Exam 5: Database Processing

The DBMS provides applications for processing operations such as ________.

Which of the following is a DBMS product from Microsoft?

A database is a self-describing collection of integrated records.

A ________ is a self-describing collection of integrated records.

MySQL DBMS refers to software systems that support very high transaction rates,processing relatively simple data structures,replicated on many servers in the cloud.

What are the differences between a spreadsheet and a database?

Which of the following is a major problem posed by multi-user processing of a database?

Which of the following is a drawback of the relational database processing model?

Bytes,which are characters of data,are grouped into rows in a database.

Describe the functions of a database management system.

Browser database application forms,reports,and queries are displayed and processed using html.

In a database,columns are also called ________.

Traditional database application programs are written in object-oriented languages such as C++.

To find out what a database contains,one can look at the metadata inside the database.

In single-user databases,the application,the DBMS,and the database all reside on a user's computer.

How does one create a database and its structures?

One of the important functions of a DBMS is to provide the necessary tools for ________.

In a database,a table,which is a group of similar rows,is also called a ________.

________ is a popular enterprise DBMS product from IBM.

Monitoring the performance of a database after providing solutions for improving its performance is a(n)________ of the DBMS.

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 Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters