Question

a). Which command is used to add new column to a table?
b) Which command is used to remove rows from a table?
c) Write any 2 aggregate functions used in MYSQL
d). Which of the following is NOT a part of DDL Commands in MySql
i) DROP , ii) SELECT, iii) MODIFY ,iv) CREATE​

Answer 1

Answer:

a ALTER TABLE command

b truncate command

c count(), sum()