Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/17

Click to flip

17 Cards in this Set

  • Front
  • Back
In general, the overall responsibility of the DBA is to facilitate the development and use of the database system.
True
One important reason for documenting changes to the database structure is for diagnosing errors.
True
In general, optimistic locking is the preferred technique for Internet databases.
True
A "dirty read" happens when one transaction reads a changed record that has not been committed to the database.
True
The DBA should periodically analyze run-time statistics of database performance to help manage the DBMS.
True
Which of the following is not a database administration responsibility of a DBA?
a) Managing the database structure
b) Managing data activity
c) Managing the DBMS
d) Maintaining the data repository
e) All of the above are database administration responsibilities of a DBA
e) All of the above are database administration responsibilities of a DBA
Measures that are taken to prevent one user's work from inappropriately influencing another user's work are called:
a) concurrency control
b) checkpoint
c) database recovery
d) database logging
e) interleaving
a) concurrency control
A lock placed automatically by the DBMS is called a(n) _______ lock.
a) exclusive
b) explicit
c) granular
d) implicit
e) shared
d) implicit
Which type of lock still allows other transactions to have read-only access to the locked resource?
a) exclusive lock
b) shared lock
c) two-phased lock
d) explicit lock
e) implicit lock
b) shared lock
Locks that are placed assuming that a conflict will occur are called:
a) dynamic locks
b) explicit locks
c) implicit locks
d) optimistic locks
e) pessimistic locks
e) pessimistic locks
Locks that are placed assuming that a conflict will not occur are called:
a) dynamic
b) explicit
c) implicit
d) optimistic
e) pessimistic
d) optimistic
A(n) ________ is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.
transaction
The size of a lock is referred to as the lock _______.
granularity
A(n) ________ transaction is one for which all committed changes are permanent.
durable
A(n) _______ cursor saves primary key values when the cursor is opened and retrieves the values for each row as the application program accesses it.
keyset
To support rollforward and rollback recovery, transactions must be written to a(n) _______ before they are applied to the database.
log
The overall responsibility of the _______ is to facilitate the development and use of the database.
DBA