You issue the following command to alter the country column in the departments table: Which statement is true?

Question

Options

• AIt produces an error because column definitions cannot be altered to add default values.
• BIt executes successfully and all the rows that have a null value for the country column will be updated
• CIt executes successfully. The modification to add the default value takes effect only from subsequent
• DIt produces an error because the data type for the column is not specified.

• A
  17% (4)
• B
  71% (17)
• C
  8% (2)
• D
  4% (1)

No community discussion yet for this question.