CBSE · 083Class XII · 2025Section B1 mark
Question 27ii
4 March 2025 · Computer Science (083)
(ii) (a) Write the SQL command to change the size of the attribute BASICSAL in the table EMPLOYEES to allow the maximum value of 99999.99 to be stored in it.
Answer
ALTER TABLE EMPLOYEES MODIFY BASICSAL DECIMAL(7,2);
Explanation
ALTER TABLE MODIFY is used to change column definitions. (7,2) allows 5 digits before decimal and 2 after.