dbms lab quiz

Storing of same data for multiple times in a same data file is called________.

• Atomic

• Integrity

• Server

• Redundancy

The description of the database is called ______

           

• Relation

• Schema

• construct

• database state

Another name for Row of a relation?

• tuple

• domain

• column

• attribute

________  is a method to remove all  anomalies and bring the database to a consistent  state

• Normalization

• updation

• dependancy

• delete

Which of the following is relational algebra operation?

• union

• Project

• matrix

• intersect

._________ attribute may be composed of several components.

   

• atomic

• derived

• composite

• simple

________ is a relation that does not contain non trivial multi-values dependencies.

 

• 2NF

• 5NF

• 3NF

• 4NF

________ problems occurs when two transaction that access the same database items have their operations interleaved in a way that makes the values of some database items incorrect.

• lost update

• temporary update

• disk failure

• wound die

   The transaction operation used to undo the transactions is _______.

• delete

• update

• rollback

• commit

    Find out the ACID property

• Constant

• Attribute

• Constraint

• Durability