Question 1

Which of the following is a database management system (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

Question 2

Define Structured Query Language (SQL).

Accepted Answer

Structured Query Language (SQL) is an in

Question 3

Traditional database application programs are written in object-oriented languages like ________.

Accepted Answer

A)  Pascal 
B)  Visual Basic 
C)  Datalog 
D)  Unigraphics 
A)  Pascal 
B)  Visual Basic 
C)  Datalog 
D)  Unigraphics

Question 4

NoSQL database management system products are very technical and can be used only by those with a deep background in computer science.

Accepted Answer

A) True 
 B)False

Question 5

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.

Accepted Answer

A)  processing 
B)  administration 
C)  creation 
D)  modification 
A)  processing 
B)  administration 
C)  creation 
D)  modification

Question 6

In a database, the collection of data for all columns is called a file.

Accepted Answer

A) True 
 B)False

Question 7

All of the following are elements of a database application EXCEPT ________.

Accepted Answer

A)  query applications 
B)  application programs 
C)  reports 
D)  data 
A)  query applications 
B)  application programs 
C)  reports 
D)  data

Question 8

Which of the following is a function of the database management system (DBMS)?

Accepted Answer

A)  implementing lean systems in workstations 
B)  eliminating bottlenecks in business processes 
C)  automating workflows in the databases of companies 
D)  processing a database by inserting or modifying data 
A)  implementing lean systems in workstations 
B)  eliminating bottlenecks in business processes 
C)  automating workflows in the databases of companies 
D)  processing a database by inserting or modifying data

Question 9

The conversion of the existing traditional databases in organizations to NoSQL databases is ________.

Accepted Answer

A)  highly efficient and is being practiced by many organizations 
B)  highly recommended because it is user friendly 
C)  very cost-effective but can be enormously disruptive 
D)  unnecessary when relational databases meet the needs of organizations 
A)  highly efficient and is being practiced by many organizations 
B)  highly recommended because it is user friendly 
C)  very cost-effective but can be enormously disruptive 
D)  unnecessary when relational databases meet the needs of organizations

Question 10

What is a database application?

Accepted Answer

A database application is a collection o

Question 11

Most organizations develop their own database management systems.

Accepted Answer

A) True 
 B)False

Question 12

The administrative functions of a database management system (DBMS) include backing up database data.

Accepted Answer

A) True 
 B)False

Question 13

In a database, columns are also called records.

Accepted Answer

A) True 
 B)False

Question 14

Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

Accepted Answer

A) True 
 B)False

Question 15

Microsoft Access does not have a graphical query interface.

Accepted Answer

A) True 
 B)False

Question 16

In the context of data storage, explain the difference between a spreadsheet and a database.

Accepted Answer

The purpose of both a spreadsheet and a

Question 17

The database management system (DBMS) can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.

Accepted Answer

A) True 
 B)False

Question 18

In a database, rows are also called ________.

Accepted Answer

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

Question 19

A task for the DBA during the development phase of the database is to validate the data model.

Accepted Answer

A) True 
 B)False

Question 20

Describe the functions of a database management system (DBMS).

Accepted Answer

A database management system (DBMS) is a

Exam 5: Database Processing

Which of the following is a database management system (DBMS) product from Microsoft?

Define Structured Query Language (SQL).

Traditional database application programs are written in object-oriented languages like ________.

NoSQL database management system products are very technical and can be used only by those with a deep background in computer science.

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.

In a database, the collection of data for all columns is called a file.

All of the following are elements of a database application EXCEPT ________.

Which of the following is a function of the database management system (DBMS)?

The conversion of the existing traditional databases in organizations to NoSQL databases is ________.

What is a database application?

Most organizations develop their own database management systems.

The administrative functions of a database management system (DBMS) include backing up database data.

In a database, columns are also called records.

Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

Microsoft Access does not have a graphical query interface.

In the context of data storage, explain the difference between a spreadsheet and a database.

The database management system (DBMS) can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.

In a database, rows are also called ________.

A task for the DBA during the development phase of the database is to validate the data model.

Describe the functions of a database management system (DBMS).

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2016

Database Design

Using Microsoft Access 2016

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters