In a double nested set of NOT EXISTS SELECT statements,________.
A)if a row does not match any row,then it matches every row
B)if a row matches any row,then it matches every row
C)if a row does not match any row,then it does not match every row
D)if a row matches any row,then it does not match every row
E)if a row does not match any row,then referential integrity has been broken

Question

Quizplus · Accepted Answer

In a double nested set of NOT EXISTS SELECT statements, if a row does not match any row in the innermost SELECT statement, then it satisfies the condition of the outer NOT EXISTS statement, making the entire expression true for that row. Therefore, it will match every row in the outer SELECT statement.

In a Double Nested Set of NOT EXISTS SELECT Statements,________