The operators that are used when a subquery returns multiple rows to b – McqOptions

MCQOPTIONS

1.	The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________
A.	IN and NOT IN
B.	EXISTS and NOT EXISTS
C.	OUTER JOIN and INNER JOIN
D.	LEFT JOIN and RIGHT JOIN
Answer» B. EXISTS and NOT EXISTS

Discussion

No Comment Found

Related MCQs

What is the property of InnoDB that enforces foreign key relationships stay intact?
The storage engine in MySQL that provides foreign key support is ___________
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?
The default value in seconds in the system variable ‘long_query_time’ is ______________
THE_STORAGE_ENGINE_IN_MYSQL_THAT_PROVIDES_FOREIGN_KEY_SUPPORT_IS____________?$
What_is_the_property_of_InnoDB_that_enforces_foreign_key_relationships_stay_intact?$
What is the kind of delete when deletion of an employee from table also deletes that employee from another table?
The ALL subquery performs operations on _____________
The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________
Usage of aggregates in WHERE clause is not allowed.