Question 1

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 any technology-tolerant business professional can use NoSQL 
C)  very cost-effective, but can be enormously disruptive 
D)  unnecessary in cases where relational databases meet the needs of organizations 
A)  highly efficient and is being practiced by many organizations 
B)  highly recommended because any technology-tolerant business professional can use NoSQL 
C)  very cost-effective, but can be enormously disruptive 
D)  unnecessary in cases where relational databases meet the needs of organizations

Question 2

Which of the following is considered an administrative function of the DBMS?

Accepted Answer

A)  adding structures to improve the performance of database applications 
B)  testing program codes in the system for errors 
C)  creating tables, relationships, and other structures in databases 
D)  using international standard languages for processing database applications 
A)  adding structures to improve the performance of database applications 
B)  testing program codes in the system for errors 
C)  creating tables, relationships, and other structures in databases 
D)  using international standard languages for processing database applications

Question 3

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 4

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

Accepted Answer

A)  foreign 
B)  continuous 
C)  relational 
D)  discrete 
A)  foreign 
B)  continuous 
C)  relational 
D)  discrete

Question 5

A database application serves as an intermediary between users and database data.

Accepted Answer

A) True 
 B)False

Question 6

Most organizations develop their own database management systems.

Accepted Answer

A) True 
 B)False

Question 7

Describe the usefulness of metadata.

Accepted Answer

A database is self-describing in that it

Question 8

Which of the following is a function of the DBMS?

Accepted Answer

A)  analyzing business data to predict future performance 
B)  eliminating bottlenecks in business processes 
C)  automating workflows in companies 
D)  processing a database by inserting or modifying data 
A)  analyzing business data to predict future performance 
B)  eliminating bottlenecks in business processes 
C)  automating workflows in companies 
D)  processing a database by inserting or modifying data

Question 9

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

Accepted Answer

A) True 
 B)False

Question 10

SQL stands for ________.

Accepted Answer

A)  Standard Query Language 
B)  Secondary Query Language 
C)  Structured Query Language 
D)  Simplified Query Language 
A)  Standard Query Language 
B)  Secondary Query Language 
C)  Structured Query Language 
D)  Simplified Query Language

Question 11

In a database,columns that are keys of a different table than the one in which they reside are known as ________ keys.

Accepted Answer

A)  foreign 
B)  discrete 
C)  relational 
D)  continuous 
A)  foreign 
B)  discrete 
C)  relational 
D)  continuous

Question 12

Hypertext Markup Language is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

Which of the following elements of a database application presents data in a structured manner using sorting,grouping,filtering,and other operations?

Accepted Answer

A)  queries 
B)  forms 
C)  reports 
D)  application programs 
A)  queries 
B)  forms 
C)  reports 
D)  application programs

Question 15

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

Accepted Answer

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

Question 16

In a database,bytes are grouped into ________.

Accepted Answer

A)  tables 
B)  columns 
C)  rows 
D)  records 
A)  tables 
B)  columns 
C)  rows 
D)  records

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer.

Accepted Answer

A) True 
 B)False

Question 19

What is a NoSQL DBMS?

Accepted Answer

A few years back,Amazon.com determined t

Question 20

Security requirements are more stringent for traditional applications than for browser-based ones.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

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

Which of the following is considered an administrative function of the DBMS?

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

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

A database application serves as an intermediary between users and database data.

Most organizations develop their own database management systems.

Describe the usefulness of metadata.

Which of the following is a function of the DBMS?

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

SQL stands for ________.

In a database,columns that are keys of a different table than the one in which they reside are known as ________ keys.

Hypertext Markup Language is an international standard language for processing a database.

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

Which of the following elements of a database application presents data in a structured manner using sorting,grouping,filtering,and other operations?

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

In a database,bytes are grouped into ________.

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

All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer.

What is a NoSQL DBMS?

Security requirements are more stringent for traditional applications than for browser-based ones.

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