When EXISTS or NOT EXISTS is used in a subquery, the select list of the subquery will usually just select all columns as a placeholder because it doesn't matter which columns are returned.
Correct Answer:
Verified
Q72: In order to find out what customers
Q73: A correlated subquery is executed once for
Q74: A routine is a named set of
Q75: A materialized view is not persistent.
Q76: When a subquery is used in the
Q78: The advantages of SQL-invoked routines are flexibility,
Q79: Constraints are a special case of triggers.
Q80: Triggers can be used to ensure referential
Q81: What is a self-join and how is
Q82: When is it better to use a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents