11) Which of the following operations is not part of the five basic set operations in relational algebra?
a) Union
b) Division
c) Cartesian Product
d) Set Difference
\
12) A lack of normalization can lead to which one of the following problems?
a) Insertion problems
b) Deadlock
c) Lost Updates
d) Deferred Updates
13) Which of the following relational algebraic operation is not a commutative operation?
a) Union
b) Intersection
c) Selection
d) Project
14) Constraints are specified as a part of
a) Data definition
b) Data Manipulation
c) Data Control
d) None of the above
15) Which of the following is not a file operation?
a) FindNext
b) Find
c) Reset
d) None of the above
16) Relations produced from an E-R model will always be in
a) First normal form
b) Second normal form
c) third normal form
d) Fourth normal form
17) If the precedency graph of a given schedule is acyclic, then schedule—
a) will be always serializable
b) will never serializable
c) may be serializable
d) can’t say
18) What is the goal of concurrency control protocol?
a) schedule should be serializable
b) schedule should be recoverable
c) both (a) and (b)
d) none of these
19) Student and courses enrolled, is an example of
a) one-to-one relationship
b) one-to-many relationship
c) many-to-many relationship
d)many-to-one relationship
20) Which of the following is generally a benefit of normalization??
a) performance is improved
b) insertion anomalies are avoided
c) Selection anomalies are avoided
d) number of tables is reduced