Question 1

What are relational databases? Discuss their drawbacks that led to the development of nonrelational style of database processing.

Accepted Answer

Databases that carry their data in the f

Question 2

Bytes are grouped into rows in a database.

Accepted Answer

A) True 
 B)False

Question 3

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

Accepted Answer

A) database application 
B) metadata table 
C) database hierarchy 
D) dimension table 
A) database application 
B) metadata table 
C) database hierarchy 
D) dimension table

Question 4

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 5

Discuss the creation of a database.Explain its working.

Accepted Answer

Database developers use the database man

Question 6

Define Structured Query Language (SQL).

Accepted Answer

Structured Query Language (SQL)is an int

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

What is an in-memory database management system?

Accepted Answer

An in-memory database management system

Question 12

Which of the following is considered an administrative function of the database management system (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 13

Which of the following elements of a database application provides security, data consistency, and special-purpose processing?

Accepted Answer

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

Question 14

One of the important functions of a database management system (DBMS)is to provide the necessary tools for ________.

Accepted Answer

A) encrypting emails 
B) encapsulating data objects 
C) administering the database 
D) testing program codes 
A) encrypting emails 
B) encapsulating data objects 
C) administering the database 
D) testing program codes

Question 15

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 16

Databases are required to keep track of lists with multiple themes.

Accepted Answer

A) True 
 B)False

Question 17

Google is a database that is used by Facebook and Twitter.

Accepted Answer

A) True 
 B)False

Question 18

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 19

In a database, columns are also called records.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is a major drawback of multi-user processing of a database?

Accepted Answer

A) lack of data integrity 
B) software redundancy 
C) lost-update problem 
D) limited access to data 
A) lack of data integrity 
B) software redundancy 
C) lost-update problem 
D) limited access to data

Exam 5: Database Processing

What are relational databases? Discuss their drawbacks that led to the development of nonrelational style of database processing.

Bytes are grouped into rows in a database.

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

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

Discuss the creation of a database.Explain its working.

Define Structured Query Language (SQL).

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

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

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

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

What is an in-memory database management system?

Which of the following is considered an administrative function of the database management system (DBMS)?

Which of the following elements of a database application provides security, data consistency, and special-purpose processing?

One of the important functions of a database management system (DBMS)is to provide the necessary tools for ________.

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

Databases are required to keep track of lists with multiple themes.

Google is a database that is used by Facebook and Twitter.

In a database, bytes are grouped into ________.

In a database, columns are also called records.

Which of the following is a major drawback of multi-user processing of a database?

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