RDBMS (UNIT 3 & 4)

A functional dependency is a relationship between or among

• Entities

• Tuples

• Attributes

• Tables

If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be:

• 1 NF

• 2 NF

• 3 NF

• BCNF

Anomalies are avoided by splitting the relation into multiple relations, is also known as

• Dependency

• Decompostition

• Functional Dependency

• Redundency

In the functional dependency X -> Y, X is called as

• Dependent

• Independent

• Determinant

• Variable

Which of the following is a type of Normal Form?

• ACNF

• BCNF

• ECNF

• PCNF

When a relation is in 2NF and there is ___, it is in 3NF.

• 1. Transition Dependency

• 1. No Transitive Dependency

• 1. Relational Dependency

• 1. No Relational Dependency

A _________ consists of a sequence of query and/or update statements.

• Transaction

• Commit

• Rollback

• Local Memory

Which of the following occurs when a transaction cannot proceed for an indefinite period of time while other transactions in the system continue normally?

• 1. Starvation 

• 1. Deadlock 

• 1. Wait - Restart

• 1. Wait – die

Which of the following is a conflict pair?

• R(A), R(A)

• R(A), W(B)

• R(A), W(A)

• W(A), W(B)

In the ACID properties C stands for

• Concurrent

• Consistency

• Commit

• Control