Which of the following operator is used to compare multiple values?
a) ANY operator
b) ALL operator
c) both a & b
d) none of these
Which operator compares the value to every value return by subquery?
a) ANY operator
b) ALL operator
c) both a & b
d) none of these
Which of the following clause is used in nested subqueries?
a) HAVING clause
b) WHERE clause
c) Order by clause
d) none of these
How many types of constraints?
a) one
b) two
c) three
d) four
Explanation: NULL/NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY
How many levels of constraints?
a) one
b) two
c) three
d) four
Explanation: column level constraint, row level constraint
Which of the following constraint restrict the duplication of rows?
a) NOT NULL
b) UNIQUE
c) PRIMARY KEY
d) FOREIGN KEY
