Question 1

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  True

Question 2

In a database, a column or group of columns that identifies a unique row in a table is known as a ________.

Accepted Answer

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

Question 3

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS)server computer.

Accepted Answer

A) True 
 B)False  False

Question 4

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) NoSQL DBMS 
B) MySQL DBMS 
C) Traditional DBMS 
D) Relational DBMS 
A) NoSQL DBMS 
B) MySQL DBMS 
C) Traditional DBMS 
D) Relational DBMS

Question 6

In a database, a table is formally referred to as a ________.

Accepted Answer

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

Question 7

________ is a popular enterprise database management system (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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is a nonrelational data store developed by Amazon.com?

Accepted Answer

A) Bigtable 
B) Dynamo 
C) Cassandra 
D) MongoDB 
A) Bigtable 
B) Dynamo 
C) Cassandra 
D) MongoDB

Question 10

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 11

Reports in database applications provide security, data consistency, and special-purpose processing.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Describe the elements in a database.

Accepted Answer

A database is a self-describing collecti

Question 14

Databases are static and it is only the information systems that change.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is an international standard language for querying databases?

Accepted Answer

A) C++ 
B) SQL 
C) Python 
D) Visual Basic 
A) C++ 
B) SQL 
C) Python 
D) Visual Basic

Question 16

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

Accepted Answer

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

Question 17

Most organizations develop their own database management systems.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The purpose of a database is to ________.

Accepted Answer

A) test and troubleshoot newly installed software 
B) design the source code for computer programs 
C) describe and build computer architectures 
D) store lists of data involving multiple themes 
A) test and troubleshoot newly installed software 
B) design the source code for computer programs 
C) describe and build computer architectures 
D) store lists of data involving multiple themes

Question 20

Which of the following is an open source document-oriented NoSQL DBMS product?

Accepted Answer

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

Exam 5: Database Processing

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

In a database, a column or group of columns that identifies a unique row in a table is known as a ________.

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS)server computer.

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

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

In a database, a table is formally referred to as a ________.

________ is a popular enterprise database management system (DBMS)product from IBM.

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

Which of the following is a nonrelational data store developed by Amazon.com?

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

Reports in database applications provide security, data consistency, and special-purpose processing.

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

Describe the elements in a database.

Databases are static and it is only the information systems that change.

Which of the following is an international standard language for querying databases?

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

Most organizations develop their own database management systems.

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

The purpose of a database is to ________.

Which of the following is an open source document-oriented NoSQL DBMS product?

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

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

Collaboration Information Systems for Decision Making

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 Erpsystems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters