Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What happens when a data engineer attempts to add a NOT NULL constraint to a Delta table's column that already contains null values, and then tries to insert another null value into that column?
A
The ALTER TABLE command fails, but new NULL values cannot be added to the location column.
B
The ALTER TABLE command returns an error, allowing new NULL values to be added to the location column.
C
The ALTER TABLE command executes successfully, yet new NULL values can still be added to the location column.
D
The ALTER TABLE command is successful, and no new NULL values will be accepted in the location column.
E
The ALTER TABLE command succeeds, and all previous and new NULL values are dropped.
