Question 1

What is a NoSQL DBMS?

Accepted Answer

A few years back,Amazon.com determined that relational database technology wouldn't meet its processing needs,and it developed a nonrelational data store called Dynamo.Google (developed Bigtable)and Facebook (developed Cassandra)also followed suit.Such nonrelational DBMS have come to be called NoSQL DBMS.This term refers to software systems that support very high transaction rates processing relatively simple data structures,replicated on many servers in the cloud.The rise of NoSQL does mean that,for large organisational IS,choosing a relational DBMS is no longer automatic.NoSQL DBMS products are very technical and can be used only by those with a deep background in computer science.

Question 2

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  False

Question 3

________ is an international standard language that is used for processing a database.

Accepted Answer

A) Structured Query Language 
B) Sybase Language 
C) Dynamic HTML 
D) Hypertext Markup Language 
A) Structured Query Language 
B) Sybase Language 
C) Dynamic HTML 
D) Hypertext Markup Language A

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

NoSQL DBMS 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 7

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

Accepted Answer

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

Question 8

DBMS administrative functions include adding structures to improve the performance of database applications.

Accepted Answer

A) True 
 B)False

Question 9

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) continuous 
D) relational 
A) foreign 
B) discrete 
C) continuous 
D) relational

Question 10

Describe the functions of a database management system.

Accepted Answer

A database management system (DBMS)is a

Question 11

________ is a popular enterprise DBMS product from IBM.

Accepted Answer

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

Question 12

The DBMS provides applications for processing operations such as ________.

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true of the relational database processing model?

Accepted Answer

A) It helps organisations store new data types such as images,audio,and videos. 
B) It can efficiently store files with large collections of bits. 
C) It supports very high transaction rates. 
D) It represents relationships with the help of foreign keys. 
A) It helps organisations store new data types such as images,audio,and videos. 
B) It can efficiently store files with large collections of bits. 
C) It supports very high transaction rates. 
D) It represents relationships with the help of foreign keys.

Question 15

A(n)________ is a program that is used to create,process,and administer a collection of self-describing integrated records.

Accepted Answer

A) knowledge management system (KMS) 
B) enterprise planning system (EPS) 
C) decision support system (DSS) 
D) database management system (DBMS) 
A) knowledge management system (KMS) 
B) enterprise planning system (EPS) 
C) decision support system (DSS) 
D) database management system (DBMS)

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

In a database,rows are also called ________.

Accepted Answer

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

Question 19

Browser applications are thin-client applications that need not be pre-installed on the users' computers.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?

Accepted Answer

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

Exam 5: Database Processing

What is a NoSQL DBMS?

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

________ is an international standard language that is used for processing a database.

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

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

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

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

DBMS administrative functions include adding structures to improve the performance of database applications.

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

Describe the functions of a database management system.

________ is a popular enterprise DBMS product from IBM.

The DBMS provides applications for processing operations such as ________.

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

Which of the following is true of the relational database processing model?

A(n)________ is a program that is used to create,process,and administer a collection of self-describing integrated records.

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

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

In a database,rows are also called ________.

Browser applications are thin-client applications that need not be pre-installed on the users' computers.

Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

The Cloud

Organisations 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

Collaboration 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 Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters