Question 1

What is a NoSQL database management system?

Accepted Answer

A few years back,Amazon.com determined t

Question 2

Browser-based database applications differ from traditional applications in that they ________.

Accepted Answer

A) have no security requirements 
B) are used only by corporates 
C) are usually open to the public 
D) fail to support graphical queries 
A) have no security requirements 
B) are used only by corporates 
C) are usually open to the public 
D) fail to support graphical queries

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

Discuss the creation of a database.Explain its working.

Accepted Answer

Database developers use the database man

Question 5

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 6

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 7

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

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

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

Accepted Answer

A) True 
 B)False

Question 10

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) alternate 
C) relational 
D) candidate 
A) foreign 
B) alternate 
C) relational 
D) candidate

Question 11

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

Accepted Answer

A) hierarchical 
B) network 
C) relational 
D) object 
A) hierarchical 
B) network 
C) relational 
D) object

Question 12

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 13

Which of the following best describes a byte in a database?

Accepted Answer

A) It is a character of data. 
B) It is a group of rows. 
C) It is a collection of data. 
D) It is a group of columns. 
A) It is a character of data. 
B) It is a group of rows. 
C) It is a collection of data. 
D) It is a group of columns.

Question 14

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 15

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 16

Define Structured Query Language (SQL).

Accepted Answer

Structured Query Language (SQL)is an int

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

In a database,a table is also called a ________.

Accepted Answer

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

Question 19

The database management system (DBMS)provides applications for processing operations such as ________.

Accepted Answer

A) sending and receiving emails 
B) generating software codes 
C) inserting or deleting information 
D) automating business processes 
A) sending and receiving emails 
B) generating software codes 
C) inserting or deleting information 
D) automating business processes

Question 20

Database management system (DBMS)administrative functions include adding structures to improve the performance of database applications.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

What is a NoSQL database management system?

Browser-based database applications differ from traditional applications in that they ________.

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

Discuss the creation of a database.Explain its working.

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

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

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

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

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

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

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

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

Which of the following best describes a byte in a database?

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

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

Define Structured Query Language (SQL).

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

In a database,a table is also called a ________.

The database management system (DBMS)provides applications for processing operations such as ________.

Database management system (DBMS)administrative functions include adding structures to improve the performance of database applications.

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 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 2013

Database Design

Using Microsoft Access 2013

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

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters