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: 301

Tutors are just amazing06/19/2018

Calltutors.com tutors are just amazing. They taught me about operating system scheduling algorithms and also helped me to complete my 20 homework questions on First Come First Serve (FCFS), Short Job First (SJF) and Priority algorithms in few hours. Earlier these questions were big blunder for me but after learning about the subject I found these questions quiet interesting/

Mike Canavan
Healthcare Homework help06/19/2018

This piece of work was very well done. Except for few grammatical mistakes, everything was answered correctly. They kept to the word count and referenced it as asked for. A very exceptional piece of work and I thank 'calltutors.com' for their assistance and I would surely recommend my friends to this.

Ashley Ying
Nursing Home Work help06/19/2018

This is the best paper I've received from you guys so far. The wrier is prompt and knowledgeable. I'll use this writer again.Thanks so much!

Walter Alcazar
chemistry and physic Assignment help06/18/2018

My ward was very weak in chemistry and physics and scored very poorly in these subjects ,but thanks to exceptional assignment help and online tutoring services provided by calltutors.com now he can ace all these subjects quite comfortably without much difficulty. Well trained experts along with exceptional knowledge in various disciplines along with regular practice sessions through various assignments indeed provided the necessary guidance needed.

Tasha E.
physics Assignment Help06/18/2018

The online tutoring services provided by Calltutors.com are of immense importance and greatly assisted my ward in overcoming his maths and physics phobia. Also, the facility of continuous self evaluation wherein your assignments are submitted after paying a nominal fee and are evaluated even before the deadline expires.

Julien Clerc

Read More...