Deck 7: Dbms Functions

Question 1

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

Answer 1

True

Question 2

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.​

Answer 2

True

Question 3

In a PC-based DBMS,as long as one program has a row or table locked,no other program may access that row or table.​

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

A) Batch processing​
B) ​Biometrics
C) ​Journaling
D) ​Locking

Question 11

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

Question 12

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

Question 13

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

Question 14

Encrypted data can be read by a word processor program.​

Question 15

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

A) ​backups
B) ​locking
C) ​encryption
D) ​biometrics

Question 16

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 17

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

A) ​Biometrics
B) ​Catalogs
C) ​Workgroups
D) ​Journals

Question 18

PC-based DBMSs offer a data dictionary.​

Question 19

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 20

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

A) ​backup
B) ​hyperdata
C) ​metadata
D) ​rollback

Question 21

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 22

____ a database reverses encryption.​

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

Question 23

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

A) ​DBMS name
B) ​DBA right
C) ​password
D) ​table name

Question 24

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

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

Question 25

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

Question 26

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

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

Question 27

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

Question 28

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 29

​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 30

____ 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) ​Concurrent update
C) ​Encryption
D) ​Batch processing

Question 31

____ 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 32

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

A) ​Passwords
B) ​Data dictionaries
C) ​Econometrics
D) ​Biometrics

Question 33

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

A) ​log
B) ​victim
C) ​workgroup
D) ​backup

Question 34

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 35

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

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

Question 36

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

Question 37

The DBA usually creates groups of users called ____.​

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

Question 38

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

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

Question 39

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

Question 40

____________________ involves maintaining a log of all updates in the database.​

Question 41

Explain how a DBMS breaks a deadlock.​

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

Discuss the advantages and disadvantages of timestamping.​

Question 50

Explain how a database is updated using batch processing.​