1 

What query do you use to show a list of database in MYSQL?

ans.

SHOW databases;

 2 

Write a sytax for removing a column in a table.

ans.

ALTER TABLE <table name> DROP <column name>;

 3 

MySQL update statement syntax is

ans.

UPDATE table_name
SET column1 = value1, column2 = value2, column3=value3
WHERE condition;

 4 

What SQL do you use to show the currently open MySQL connections?

ans.

SHOW STATUS WHERE `variable_name` = 'Threads_connected';