DATABRICKS-DAA Question 18

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Correct answer : A — Every row in the table is deleted, since an omitted predicate is treated as matching all rows A . Databricks documentation states that when no predicate is provided, DELETE FROM deletes all rows in the table, so omitting WHERE clears the entire table rather than doing nothing or requiring extra syntax. B . Delta Lake does not enforce a mandatory WHERE predicate on DELETE statements; the syntax explicitly allows an optional predicate, so no validation error is raised. C . DELETE FROM has no special default behavior that targets only NULL-containing rows; without a predicate it applies to the entire table regardless of which columns hold NULLs. D . The statement executes immediately rather than staying inert, and its effect is to remove all rows, not to silently do nothing until a condition is supplied.