Which statement is true?

You issue the following command to alter the country column in the departments table:

Which statement is true?

You issue the following command to alter the country column in the departments table:

Which statement is true?

A.
It produces an error because column definitions cannot be altered to add default values.

B.
It executes successfully and all the rows that have a null value for the country column will
be updated with the value ‘USA’.

C.
It executes successfully. The modification to add the default value takes effect only from
subsequent insertions to the table.

D.
It produces an error because the data type for the column is not specified.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


donald

donald

Correct answer is C. Try it.

Surersh

Surersh

Yes C is correct

Sendestaz

Sendestaz

I TRIED IT @DONALD YES SURE THE CORRECT ANSWER IS C