21

Which one of the following is NOT a part of the ACID properties of database transaction??

a Atomicity
b Consistency
c Instance
d Durability
Correct: (C) Instance
22

Which of the following statement is a part of Data Manipulative Language in Structured Query Language??

a Delete
b Alter Table
c Copy
d Paste
Correct: (A) Delete
23

The left-hand side and right-hand sides of a functional dependency are sometimes called _________ and _______ respectively.?

a Domain; attribute
b Determinant; dependent
c Range; table
d Tuple; relation
Correct: (B) Determinant; dependent
24

All candidate keys other than primary keys are known as________?

a Foregin Key
b Secondary Key
c Alternate Key
d Remaining Key
Correct: (C) Alternate Key
25

Which of the following category of join returns all records when there is a match in either left of right table??

a Inner Join
b Left Outer Join
c Right Outer Join
d Full Outer join
Correct: (D) Full Outer join
26

Which of the following is FALSE??

a A relation (table) may have multiple secondary keys
b The value of primary key can't be NULL
c Secondary key is also a candidate key
d Super key satisfies the 'minimality' condition
Correct: (D) Super key satisfies the 'minimality' condition
27

Which of the following is an Aggregate operator in structures Query Language??

a Minus
b Intersect
c Union
d Count
Correct: (D) Count
28

Which of the following is NOT an aggregate function in SQL??

a Cross Product
b Maximum
c Count
d Sum
Correct: (A) Cross Product
29

The operations of a ________ require that the first element that is inserted is the first one to be removed??

a Union
b Graph
c Queue
d Stack
Correct: (C) Queue
30

Which of the following algorithm design techniques is used in the merge sort algorithm??

a Greedy Algorithm
b Backtracking
c Divide and Conquer
d Divide and Conquer, backtracking and greedy algorithm
Correct: (C) Divide and Conquer