Author Question: What is the process for adding a NOT NULL column to a table? What will be an ideal ... (Read 58 times)

appyboo · **on:** Jul 7, 2018

What is the process for adding a NOT NULL column to a table?

What will be an ideal response?

Question 2

If you have a table with a set of columns named Child01, Child02 and Child03, the table is likely to have the multivalued, multicolumn problem.

Indicate whether the statement is true or false

chem1s3 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

There are three steps in adding a NOT NULL column to a table. First, the column is added as a NULL column. Second, data is added to the column using one or more UPDATE statements. Finally, the ALTER command is used to change the column from NULL to NOT NULL.

Answer to Question 2

TRUE