Which qualifier returns all values by default?

• A. Where
• B. All
• C. Distinct
• D. From

Answer: (B)

In SQL, the default behavior of a SELECT statement is to return every row from the specified source unless you apply a filter or a modifier. The ALL qualifier explicitly means “include all rows,” but since that’s already the default behavior, it has no effect beyond being explicit. Distinct would remove duplicates, reducing the set rather than returning all values. The WHERE clause filters rows, so it narrows the results. The FROM clause just identifies where to read the data; it doesn’t by itself change how many rows are returned. Therefore, the qualifier that returns all values by default is All.