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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Question text

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

Research essay writing02/18/2018

Hi, i have given them my research essay writing work and these guys are just awesome. They have some of the best UK writers. Just love them for their quality service and delivery.

Tani J.
so much perfection02/17/2018

They handle each order with so much perfection. I got the assignment well before the time and it was written nicely. I never knew they could be of such a great help, and after seeing the quality of their work I’ve decided to hire them only for future projects.

Charlie Cassandra
Management Assignment02/16/2018

The subject assigned to me was not clear and as I couldn’t take risk my marks, I made a decision to hire Management Assignment Help service. I got my assignment in time and it was written perfectly. All the important things and points were properly covered and wonderfully written.

Russell Ash
Accounting Assignment Help02/12/2018

I was searching Accounting Assignment Help. I got professionals help and their services are really very good. Thanks

Nadeem Aslam
Great Support Team02/09/2018

Great experience, great service!!

George

Read More...