What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL

What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
A . An error is returned and no changes are applied to the column
B. Snowflake automatically assigns a default value and let the change happen
C. Snowflake drops the row and let the change happen

Answer: A

Explanation:

When setting a column to NOT NULL, if the column contains NULL values, an error is returned and no

changes are applied to the column.

https://docs.snowflake.com/en/sql-reference/sql/alter-table-column.html#usage-notes

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments