Deck 7: Dbms Functions

Question 1

In two-phase locking,the second phase is the shrinking phase.

Answer 1

True

Question 2

When the DBMS locks more rows and releases none of the locks,this is called an expanding phase.

Answer 2

False

Question 3

In some database systems,such as Microsoft Access,users can access and update metadata about fields,tables,relationships,and indexes.

Answer 3

True

Question 4

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

A)Timestamping
B)Committing
C)Journaling
D)Locking

Question 5

PC-based DBMSs offer both a data dictionary and a catalog.

Question 6

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

A)basedata
B)hyperdata
C)metadata
D)universaldata

Question 7

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

A)Datalists
B)Catalogs
C)Workgroups
D)Journals

Question 8

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

Question 9

Concentric update occurs when multiple users make updates to the same database at the same time.

Question 10

The more important it is to avoid redoing work,the more often you should make backups.

Question 11

Each user transaction requires only one lock.

Question 12

Additional disk and memory space are not required to store timestamp values.

Question 13

Smart cards have built-in circuits containing processing logic to identify the cardholder.

Question 14

In order to accomplish serial processing of updates,many DBMSs use ____.

A)backups
B)locking
C)encryption
D)reversing

Question 15

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

Question 16

One strategy to manage deadlocks is to let them occur and then have the DBMS detect and break any deadlock.

Question 17

Legal values is a type of key integrity constraint.

Question 18

One guideline for writing programs for concurrent updates in a PC-based DBMS states that if an update transaction must lock more than one row in the same table,the whole table must be locked.

Question 19

The catalog is maintained by ____.

A)the user
B)the database administrator
C)the author of the tables in the database
D)the DBMS

Question 20

The most common security features used by DBMSs are locking,journaling,and timestamping.

Question 21

____ is the process of returning the database to a state that is known to be correct from a state known to be incorrect.

A)Recovery
B)Replication
C)Rollback
D)Commit

Question 22

After a DBMS detects a deadlock,the ____ should break the deadlock.

A)first user
B)second user
C)database administrator
D)DBMS

Question 23

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

A)Passwords
B)Visualizations
C)Econometrics
D)Biometrics

Question 24

____ integrity implies that the value entered for any field should be consistent with the data type for that field.

A)Data type
B)Legal value
C)Format
D)Secondary

Question 25

The DBMS accomplishes ____ by reading the log for the problem transactions and applying the before images to undo their updates.

A)concurrent update
B)backward recovery
C)authentication
D)batch processing

Question 26

____________________ is the prevention of unauthorized access,either intentional or accidental.

Question 27

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

A)Field
B)Value
C)Key
D)Data

Question 28

A(n) ____________________ is a set of steps completed by a DBMS to accomplish a single user task.

Question 29

A(n) ____ is a snapshot of certain data in a database at a given moment in time.

A)encryption
B)authentication
C)authorization
D)view

Question 30

A string of characters assigned by the DBA to a database that the user must enter to access the database is known as a database ____.

A)name
B)right
C)password
D)privilege

Question 31

The DBA usually creates groups of users called ____.

A)networks
B)communities
C)workgroups
D)clusters

Question 32

____ a database reverses encryption.

A)Locking
B)Decrypting
C)Synchronizing
D)Timestamping

Question 33

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

Question 34

To break a deadlock,the DBMS chooses one deadlocked user to be the ____.

A)lostlock
B)victim
C)participant
D)principal

Question 35

If two or more users are waiting for the other user to release a lock before they can proceed,this is known as a ____.

A)commit
B)timestamp
C)deadlock
D)transaction

Question 36

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

A)encryption
B)authentication
C)authorization
D)viewing

Question 37

A backward recovery is also called a(n) ____________________.

Question 38

____________________ involves maintaining a log of all updates to the database.

Question 39

____ refers to the right of individuals to have certain information about them kept confidential.

A)Legalities
B)Privacy
C)Confidentiality
D)Consumerism

Question 40

____ rules specify which users have what type of access to which data in the database.

A)Encryption
B)Authentication
C)Authorization
D)View

Question 41

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

Question 42

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

Question 43

Discuss the four ways in which integrity constraints can be handled.

Question 44

Discuss the advantages and disadvantages of timestamping.

Question 45

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

Question 46

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

Question 47

What is two-phase locking?

Question 48

Explain how a database is updated using batch processing.

Question 49

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

Question 50

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