Question

"Your supervisor has asked you to modify the AMOUNT column in the ORDERS table. He wants the column to be configured to accept a default value of 250. The table contains data that you need to keep. Which statement should you issue to accomplish this task?"

Answer 1

Answer:

ALTER TABLE orders

MODIFY (amount DEFAULT 250)

Explanation:

• ALTER TABLE statement is used to modify "amount" column in the existing "orders" table  
• MODIFY (amount DEFAULT 250) is used to set the default value 250 of the "amount" column.

Therefore if the supervisor wants the amount column to be configured to accept a default value of 250, then "ALTER TABLE orders MODIFY (amount DEFAULT 250) " statement should be issued.