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

Avg Client Rating: 4.8/5

Total Reviews: 9,835

Linux Software Assignment Help04/21/2019

I ordered a Linux software development assignment from you last week. It was an urgent service so I was kinda hoping for on-time delivery, not very much about the content quality. The assignment I got was worthy of my money. I loved the content, the examples in it. There was no mistake in the work.

Eversons B
On Time Delivery and Professional Support04/21/2019

Thanks to experts for making my computer science assignment a piece of perfection. I loved everything about it. Even my teacher praised me.

Nancy Mehta
SQL Assignment Help04/19/2019

I am satisfied with your work. And thanks to your tutors who have been completed my assignment on time. But some instructions are not used well.

Hermer Bell
Psychology Assignment Help04/19/2019

Usually, I try to write papers on my own, but this time I had no time for this that is why I started asking my friends which writing service they use. So I ordered my Psychology assignment from your expert. And its quality was good.

Hanink
A Grade Assignment Help04/18/2019

Just wanted to say thanks on the great efforts you guys put in completing my Econometric Assignment and provide me authentic sources as my professor want. My professor was appreciated me a lot.

Vendramelli

Read More...