Sub Queries MCQ

1. The SQL _______ Query is used to delete the existing records from a table.

        DELETE
        REMOVE
        DELETIT


2. Subqueries that return more than one row can only be used with multiple value operators, such as the IN operator.
   state True or False:

        True
        False


3. Which one of the following sorts rows in SQL?

        SORT BY
        ALIGN BY
        ORDER BY
        GROUP BY


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

        EXISTS
        NOT EXISTS

5. Subquery is usually added in the WHERE Clause of the SQL statement.
   state True or False:
   
           True
           False