Microsoft Technology Associate Mta · Free Practice Question Hard
Question 14
Which one of the following statements best defines a predicate sub-query?
-
A
It uses extended logical constructs in the WHERE clause using AND, OR, LIKE, BETWEEN, AS, and TOP
-
B
It returns a single value and can be used in CASE expressions, WHERE clauses, ORDER BY, and SELECT.
-
C
It returns a table based on the queries nested in the FROM clause
-
D
It helps a user create a table faster
Reveal correct answer
Correct answer: A
Explanation
A predicate defines a logical condition being applied to rows in a table.
A predicate sub-query uses extended logical constructs in the WHERE clause using AND, OR, LIKE, BETWEEN, AS, and TOP.
These operators (AND, OR, etc.) are logical or boolean operators, that can be used with comparison predicates (=, <=, <>, !=, >=, etc.). They allow us to apply logical conditions to a group of rows, with the sole purpose of filtering, whether that is for data retrieval or data manipulation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
