CS 3306: DATABASES 2

The overall design of the database is called the database __________.

Select one:

1. DDL
2. DML
3. schema 
4. entity-relationship (E-R) data model

The correct answer is: schema

Question 2

A database system has several subsystems except?

Select one:

1. storage director
2. query processor
3. storage manager 
4. transaction manager

The correct answer is: storage director

Question 3

Which is NOT a Mapping Cardinality?

Select one:

1. One to many.
2. Many to any. 
3. One to one.
4. Many to one.

The correct answer is: Many to any.

Question 4

Which of the following is NOT A type of database key?

Select one:

1. primary key
2. superkey
3. candidate key
4. database key 

The correct answer is: database key

Question 5

One can modify the database by all methods except?

Select one:

1. insertion
2. retrieving 
3. deletion
4. updating

The correct answer is: retrieving

Question 6

Relational algebraic operations include all of the following except:

Select one:

1. Rename
2. Cartesian product
3. Project I 
4. Select

The correct answer is: Project I

Question 7

The query "select max (salary) from instructor" will result in:

Select one:

1. Find instructors earning the higher salary 
2. Find the instructor earning the higher salary
3. No results
4. Find instructors earning the lowest salary

The correct answer is: Find instructors earning the higher salary

Question 8

Database applications are typically broken up into a front-end part that runs on server machines and a part that runs at the back end.

Select one:

True

False 

The correct answer is 'False'.

Question 9

The entity-relationship (E-R) data model perceives the real world as consisting of basic objects, called entities, NOT the relationships among these objects.

Select one:

True

False 

The correct answer is 'False'.

Question 10

Methods to organize records in files are heap, sequential, hasing.

Select one:

True 

False

The correct answer is 'True'.

 

Top of Form

Which of the following is NOT a property of the transactions?

Select one:

1. Atomicity
2. Dependability 
3. Isolation
4. Consistency

The correct answer is: Dependability

Question 2

Precedence graph T2 ---> T1?

Select one:

1. All T2 instructions must execute before the first T1 instruction executes 
2. Not all T2 instructions must execute before the first T1 instruction executes
3. All T1 instructions must execute before the first T2 instruction executes
4. Not all T1 instructions must execute before the first T2 instruction executes

The correct answer is: All T2 instructions must execute before the first T1 instruction executes

Question 3

The tree protocol does not ensure ________________. To ensure the _______________ the protocol can be modified to not permit release of exclusive locks until the end of the transaction:

Select one:

1. recoverability
2. recoverability and cascadelessness 
3. proper locking of the transaction
4. cascadelessness.

The correct answer is: recoverability and cascadelessness

Question 4

The difference between the Thomas' write rule and the timestamp-ordering protocol is:

Select one:

1. The timestamp-ordering protocol requires that Ti be rolled back if Ti issues write(Q) and TS(Ti) < W-timestamp(Q).
2. Thomas' write rule makes use of view serializability by NOT deleting obsolete transactions.
3. Thomas' write rule is not conflict serializable
4. Thomas' write rule is a modification of the timestamp-ordering protocol issues. 

The correct answer is: Thomas' write rule is a modification of the timestamp-ordering protocol issues.

Question 5

There are two principal methods for dealing with the deadlock problem, which prevents the deadlock condition. The deadlock prevention protocol to ensure that the system will never enter a deadlock detection is:

Select one:

1. deadlock prevention protocol 
2. deadlock recovery scheme
3. deadlock prevention and recovery

The correct answer is: deadlock prevention protocol

Question 6

Three storage types include all of the following except:

Select one:

1. Stable storage.
2. Nonvolatile storage.
3. Offsite 
4. Volatile storage.

The correct answer is: Offsite

Question 7

ARIES recovers from a crash in three passes which include all of the following except:

Select one:

1. Recovery pass 
2. Redo pass
3. Undo pass
4. Analysis pass

The correct answer is: Recovery pass

Question 8

Reduced waiting time is a good reason to allow concurrency in transaction processes to occur.

Select one:

True 

False

The correct answer is 'True'.

Question 9

Locks ensure serializability by NOT allowing a transaction to access a data item only if it is currently holding a lock on that item.

Select one:

True

False 

The correct answer is 'False'.

Question 10

Recovery actions, when the database system is restarted after a failure, take place in one of two phases.

Select one:

True

False 

The correct answer is 'False'.

Bottom of Form