• Description: Oracle 1z0-007 Introduction to Oracle9i: SQL
• Passing Score: 75%
• Practice Test - Number of questions: 195 questions
• Simulation Test - Number of questions: 195 questions
• Simulation Test Duration: 41 minutes
• Has explanations: Yes

The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); What is true about your ALTER statement?

Answer(s)

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 at 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.

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