Question 66
Which SQL function returns the first non-null expression among its arguments?
COALESCE(val1, val2, ..., valN) evaluates expressions in order and returns the first non-null argument encountered.
Which SQL function returns the first non-null expression among its arguments?
COALESCE(val1, val2, ..., valN) evaluates expressions in order and returns the first non-null argument encountered.
What does NULLIF(expression1, expression2) return in SQL if both expressions are equal?
NULLIF(e1, e2) returns NULL if e1 equals e2; otherwise it returns e1.
Which type of subquery executes once for each candidate row processed by the outer query?
A Correlated Subquery references attributes from the outer query, requiring re-evaluation for every outer table row.
In Relational Calculus, Tuple Relational Calculus (TRC) is based on finding -
TRC expressions specify queries of the form { t | P(t) }, seeking all tuples t for which predicate P(t) is true.
Which relational query language is non-procedural (declarative)?
Relational Calculus specifies 'WHAT' data to retrieve without describing 'HOW' to retrieve it (declarative/non-procedural).