Question 1

____ a database reverses encryption.​

Accepted Answer

A)   ​Locking
B)   ​Decrypting
C)   ​Synchronizing
D)   ​TimestampingE) A) and B)
F) C) and D)

Question 2

Explain the difference between a procedural language and a nonprocedural language.Give at least one example of each type of language.​

Accepted Answer

With a procedural language,you must tell...

Question 3

Each job that a user completes,such as filling an order,is called a user task.

Accepted Answer

A) True 
 B)False

Question 4

____________________ integrity constraints consist of primary key constraints and foreign key constraints.​

Accepted Answer

The answer of ____________________ integrity constraints consist of primary key...

Question 5

____ contain information about table relationships,views,indexes,users,privileges,and replicated data.​

Accepted Answer

A)   ​Biometrics
B)   ​Catalogs
C)   ​Workgroups
D)   ​JournalsE) A) and B)
F) A) and C)

Question 6

PC-based DBMSs offer a data dictionary.​

Accepted Answer

A) True 
 B)False  False

Question 7

A user's ____________________ specify what kind of access the user has to objects in the database.​

Accepted Answer

permissions​

Question 8

​____________________ occurs when the DBMS exchanges all updated data between the master database and a replica.

Accepted Answer

The answer of ​____________________ occurs when the DBMS exchanges all...

Question 9

​The technique for identifying the person who is attempting to access the DBMS is known as ____.

Accepted Answer

A)   ​encryption
B)   ​authentication
C)   ​authorization
D)   ​viewingE) All of the above
F) None of the above

Question 10

​____ integrity constraints help to ensure the accuracy and consistency of individual field values.

Accepted Answer

A)   ​Field
B)   ​Value
C)   ​Key
D)   ​DataE) All of the above
F) B) and C)

Question 11

____________________ are rules that the DBMS must be follow in order to update data accurately and consistently.​

Accepted Answer

​Integrity...

Question 12

____ identify users by physical characteristics such as fingerprints,voiceprints,handwritten signatures,and facial characteristics.​

Accepted Answer

A)   ​Passwords
B)   ​Data dictionaries
C)   ​Econometrics
D)   ​BiometricsE) A) and D)
F) None of the above

Question 13

Explain how a database is updated using batch processing.​

Accepted Answer

When users need to update the database,s...

Question 14

Data about the data in a database is known as ____.​

Accepted Answer

A)   ​backup
B)   ​hyperdata
C)   ​metadata
D)   ​rollbackE) None of the above
F) A) and B) C

Question 15

The catalog is maintained by ____.​

Accepted Answer

A)   ​the user
B)   ​the database administrator
C)   ​the author of the tables in the database
D)   ​the DBMSE) A) and B)
F) None of the above

Question 16

A DBMS must provide ways to ensure that only authorized users can access the database.

Accepted Answer

A) True 
 B)False

Question 17

The successful completion of a transaction is known as an after image.​

Accepted Answer

A) True 
 B)False

Question 18

____ denies access by other users to data while the DBMS processes one user's updates to the database.​

Accepted Answer

A)   Batch processing​
B)   ​Biometrics
C)   ​Journaling
D)   ​LockingE) A) and B)
F) A) and D)

Question 19

_________________________ is a property that lets you change the database structure without requiring you to change the programs that access the database.​

Accepted Answer

The answer of _________________________ is a property that lets you...

Question 20

​____________________ key constraints are governed by entity integrity and enforce the uniqueness of the primary key.

Accepted Answer

The answer of ​____________________ key constraints are governed by entity...

Exam 7: Dbms Functions

____ a database reverses encryption.​

Correct AnswerverifiedShow Answer

Explain the difference between a procedural language and a nonprocedural language.Give at least one example of each type of language.​

Correct AnswerverifiedWith a procedural language,you must tell...View AnswerShow Answer

Each job that a user completes,such as filling an order,is called a user task.

Correct AnswerverifiedShow Answer

____________________ integrity constraints consist of primary key constraints and foreign key constraints.​

Correct AnswerverifiedShow Answer

____ contain information about table relationships,views,indexes,users,privileges,and replicated data.​

Correct AnswerverifiedShow Answer

PC-based DBMSs offer a data dictionary.​

Correct AnswerverifiedFalse

A user's ____________________ specify what kind of access the user has to objects in the database.​

Correct Answerverifiedpermissions​

​____________________ occurs when the DBMS exchanges all updated data between the master database and a replica.

Correct AnswerverifiedShow Answer

​The technique for identifying the person who is attempting to access the DBMS is known as ____.

Correct AnswerverifiedShow Answer

​____ integrity constraints help to ensure the accuracy and consistency of individual field values.

Correct AnswerverifiedShow Answer

____________________ are rules that the DBMS must be follow in order to update data accurately and consistently.​

Correct Answerverified​Integrity...View AnswerShow Answer

____ identify users by physical characteristics such as fingerprints,voiceprints,handwritten signatures,and facial characteristics.​

Correct AnswerverifiedShow Answer

Explain how a database is updated using batch processing.​

Correct AnswerverifiedWhen users need to update the database,s...View AnswerShow Answer

Data about the data in a database is known as ____.​

Correct AnswerverifiedC

The catalog is maintained by ____.​

Correct AnswerverifiedShow Answer

A DBMS must provide ways to ensure that only authorized users can access the database.

Correct AnswerverifiedShow Answer

The successful completion of a transaction is known as an after image.​

Correct AnswerverifiedShow Answer

____ denies access by other users to data while the DBMS processes one user's updates to the database.​

Correct AnswerverifiedShow Answer

_________________________ is a property that lets you change the database structure without requiring you to change the programs that access the database.​

Correct AnswerverifiedShow Answer

​____________________ key constraints are governed by entity integrity and enforce the uniqueness of the primary key.

Correct AnswerverifiedShow Answer

____ a database reverses encryption.

Correct Answer
verified

Explain the difference between a procedural language and a nonprocedural language.Give at least one example of each type of language.

Correct Answer
verified
With a procedural language,you must tell...
View Answer

Correct Answer
verified

____________________ integrity constraints consist of primary key constraints and foreign key constraints.

Correct Answer
verified

____ contain information about table relationships,views,indexes,users,privileges,and replicated data.

Correct Answer
verified

PC-based DBMSs offer a data dictionary.

Correct Answer
verified
False

A user's ____________________ specify what kind of access the user has to objects in the database.

Correct Answer
verified
permissions

____________________ occurs when the DBMS exchanges all updated data between the master database and a replica.

Correct Answer
verified

The technique for identifying the person who is attempting to access the DBMS is known as ____.

Correct Answer
verified

____ integrity constraints help to ensure the accuracy and consistency of individual field values.

Correct Answer
verified

____________________ are rules that the DBMS must be follow in order to update data accurately and consistently.

Correct Answer
verified
Integrity...
View Answer

____ identify users by physical characteristics such as fingerprints,voiceprints,handwritten signatures,and facial characteristics.

Correct Answer
verified

Explain how a database is updated using batch processing.

Correct Answer
verified
When users need to update the database,s...
View Answer

Data about the data in a database is known as ____.

Correct Answer
verified
C

The catalog is maintained by ____.

Correct Answer
verified

Correct Answer
verified

The successful completion of a transaction is known as an after image.

Correct Answer
verified

____ denies access by other users to data while the DBMS processes one user's updates to the database.

Correct Answer
verified

_________________________ is a property that lets you change the database structure without requiring you to change the programs that access the database.

Correct Answer
verified

____________________ key constraints are governed by entity integrity and enforce the uniqueness of the primary key.

Correct Answer
verified