Question 1

Which of the following is true of browser-based database applications?

Accepted Answer

A)  They are written in object-oriented languages like Structured Query Language. 
B)  The application, DBMS, and the database all reside on the user's computer. 
C)  They are thin-client applications that need not be pre-installed on a user's computer. 
D)  They use C++ as the standard language for user-side processing.

Question 2

Special data that describe the data contained in a database are called ________.

Accepted Answer

A)  open matrices 
B)  primary data 
C)  metadata 
D)  closed matrices

Question 3

In a database,columns are also called ________.

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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 6

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

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)  file 
D)  field

Question 8

SQL statements can be issued directly to the DBMS by an application program.

Accepted Answer

A) True 
 B)False

Question 9

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)  database administrator 
C)  knowledge management system 
D)  dimension table

Question 10

Queries in database applications present data in a structured manner using operations such as sorting,grouping,and filtering.

Accepted Answer

A) True 
 B)False

Question 11

Bytes,which are characters of data,are grouped into rows in a database.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

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

Question 14

Which of the following is a DBMS product from Microsoft?

Accepted Answer

A)  MySQL 
B)  SQL Server 
C)  DB2 
D)  Sybase ASE

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n)________ of the DBMS.

Accepted Answer

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

Question 18

How does one create a database and its structures?

Accepted Answer

The answer of How does one create a database and...

Question 19

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 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)  application programs 
C)  queries 
D)  forms

Exam 5: Database Processing

Which of the following is true of browser-based database applications?

Special data that describe the data contained in a database are called ________.

In a database,columns are also called ________.

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

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

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

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

SQL statements can be issued directly to the DBMS by an application program.

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

Queries in database applications present data in a structured manner using operations such as sorting,grouping,and filtering.

Bytes,which are characters of data,are grouped into rows in a database.

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 drawback of the relational database processing model?

Which of the following is a DBMS product from Microsoft?

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

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

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n) ________ of the DBMS.

How does one create a database and its structures?

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

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