Question 1

Which of the following describes a byte?

Accepted Answer

A)  a character of data
B)  a group of rows
C)  a collection of data
D)  a group of columnsE) A) and B)
F) None of the above

Question 2

________ is an example of a personal DBMS product.

Accepted Answer

A)  DB2
B)  FoxPro
C)  Oracle Database
D)  SQL ServerE) C) and D)
F) A) and B)

Question 3

To locate something in the database,one must type the keyword into the ________ of the application.

Accepted Answer

A)  report
B)  query form
C)  data entry form
D)  data access columnE) C) and D)
F) None of the above

Question 4

________ is a popular enterprise DBMS product from IBM.

Accepted Answer

A)  DB2
B)  Access
C)  SQL Server
D)  MySQLE) All of the above
F) A) and B) A

Question 5

________ is an international standard language for processing a database.

Accepted Answer

A)  Hypertext Markup Language
B)  Dynamic HTML
C)  Structured Query Language
D)  Sybase LanguageE) All of the above
F) A) and C)

Question 6

The collection of data for all columns is called a ________.

Accepted Answer

A)  record
B)  field
C)  file
D)  tableE) C) and D)
F) All of the above

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

How can one prevent the lost-update problem of multi-user processing?

Accepted Answer

The lost-update problem exemplifies one ...

Question 9

How are database application programs useful?

Accepted Answer

Most applications have unique requiremen...

Question 10

Enterprise DBMS products are designed for smaller,simpler database applications.

Accepted Answer

A) True 
 B)False

Question 11

A table is also called a ________.

Accepted Answer

A)  record
B)  matrix
C)  file
D)  fieldE) A) and B)
F) None of the above

Question 12

Each of the elements of the database application system calls on the database management system to process the database tables.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is true of enterprise DBMS products?

Accepted Answer

A)  Enterprise DBMS products are designed for small and simple database applications.
B)  Enterprise DBMS products manage databases that span dozens of different magnetic disks.
C)  Paradox is an example of an enterprise DBMS product.
D)  The great bulk of databases in enterprise DBMS products have only a single user.E) B) and C)
F) None of the above

Question 14

Explain database management systems.

Accepted Answer

A database management system (DBMS)is a ...

Question 15

Bytes,which are characters of data,are grouped into rows.

Accepted Answer

A) True 
 B)False  False

Question 16

A key is a column or a group of columns that identifies a unique row in a table.

Accepted Answer

A) True 
 B)False

Question 17

The great bulk of databases in personal DBMS products have only a single user.

Accepted Answer

A) True 
 B)False

Question 18

The application program serves as an intermediary between the Web server and the database.

Accepted Answer

A) True 
 B)False  True

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

To prevent the ________ problem,locking must be used to coordinate the activities of users who know nothing about one another.

Accepted Answer

A)  data integrity
B)  redundancy
C)  lost-update
D)  data accessE) A) and C)
F) None of the above

Exam 5: Database Processing

Which of the following describes a byte?

Correct AnswerverifiedShow Answer

________ is an example of a personal DBMS product.

Correct AnswerverifiedShow Answer

To locate something in the database,one must type the keyword into the ________ of the application.

Correct AnswerverifiedShow Answer

________ is a popular enterprise DBMS product from IBM.

Correct AnswerverifiedA

________ is an international standard language for processing a database.

Correct AnswerverifiedShow Answer

The collection of data for all columns is called a ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How can one prevent the lost-update problem of multi-user processing?

Correct AnswerverifiedThe lost-update problem exemplifies one ...View AnswerShow Answer

How are database application programs useful?

Correct AnswerverifiedMost applications have unique requiremen...View AnswerShow Answer

Enterprise DBMS products are designed for smaller,simpler database applications.

Correct AnswerverifiedShow Answer

A table is also called a ________.

Correct AnswerverifiedShow Answer

Each of the elements of the database application system calls on the database management system to process the database tables.

Correct AnswerverifiedShow Answer

Which of the following is true of enterprise DBMS products?

Correct AnswerverifiedShow Answer

Explain database management systems.

Correct AnswerverifiedA database management system (DBMS)is a ...View AnswerShow Answer

Bytes,which are characters of data,are grouped into rows.

Correct AnswerverifiedFalse

A key is a column or a group of columns that identifies a unique row in a table.

Correct AnswerverifiedShow Answer

The great bulk of databases in personal DBMS products have only a single user.

Correct AnswerverifiedShow Answer

The application program serves as an intermediary between the Web server and the database.

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

To prevent the ________ problem,locking must be used to coordinate the activities of users who know nothing about one another.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The lost-update problem exemplifies one ...
View Answer

Correct Answer
verified
Most applications have unique requiremen...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database management system (DBMS)is a ...
View Answer

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified