Question

We can test for the nonexistence of tuples in a subquery by using the _____ construct.
not exist,not exists,exists,exist?

Answer 1

$\large{\mathfrak{Answer -}}$

$\textbf{\underline{Exists}}$ is the correct answer.

We can test for the nonexistence of tuples in a subquery by using the $\textbf{\underline{exists}}$ construct.

Answer 2

The answer is exists.

We can test for the nonexistence of tuples in a subquery by using the exists construct.

The exists construct is used with a subquery and returns a positive result if the subquery operation returns at least a single row. The subquery executes a SELECT, UPDATE, INSERT or DELETE statement.

In other words, the clause checks for the presence of any record in the subquery.