Multiple choice

The EMPLOYEES table has these columns:

LAST_NAME VARCHAR2 (35) SALARY NUMBER (8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. It was planned to alter the table by using the following SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which of the following options is true about the ALTER statement?

  1. Column definitions cannot be altered to add DEFAULT values.

  2. A change to the DEFAULT value affects only subsequent insertions to the table.

  3. Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

  4. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A change to the DEFAULT value affects only subsequent insertions to the table.

Keep practicing — related questions