Database Quiz

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

 

CallTutors Guarantees

  • Work Within Deadline
  • Lowest Price Guranteed
  • Plagiarism Free Guranteed
  • 24 * 7 Availability
  • Native Experienced Experts
  • Free Revisions

Reviews

Total Reviews: 190

Awesome term paper writing04/26/2018

All the details in my term paper writings fully satisfied me. I was very much worried about my paper, but your writers vanished all my worries. Thanks to your master writers.

Samantha Ji
Management Assignment04/26/2018

It’s very useful for my work I’ll introduce to my friends. It’s very useful for my work I’ll introduce to my friends.It’s very useful for my work I’ll introduce to my friends.It’s very useful for my work I’ll introduce to my friends.

Alan Dunn
Management Essays04/26/2018

great assignment and definitely I will use your service again. this will help me a lot during my education and be looking forward to getting more help for assignment

Jane Walker
Great reflective essay work04/24/2018

The reflective essay your writers wrote was excellent. I would like to give my all assignments to him/her. I have placed some new orders. Thanks, team! God bless you!

Grace Ling
Significant sociology assignment04/24/2018

I would like to say that the sociology assignments your writer provided were beneficial for me. I would want the same writer for my next assignment if possible. Thanks a lot!

Claudia Jaime

Read More...