My Sql

Which command is used to display list of all databases.

• Display

• Display List

• Show Databases

• Show Database

Delete command is DDL command.

• True

• False

Which aggregate function is used to find sum of column in a table?

(a)  

Which is the correct statement from the following :

Delete table book;

• Delete book;

• Delete table book;

• Drop table book;

• Drop book;

Duplication of record is called___________

• Deficiency

• Redundancy

• Lack

• Addition

Which of the following is not the aggregate function?

• avg()

• max()

• round()

• sum()

Which command will delete all the records of table with its structure?

• Delete Table <Table Name>;

• Drop Table;

• Drop Table <Table Name>;

• Drop <Table Name>;

Which clause of Alter command can change the size of the Column?

• ADD

• MODIFY

• CHANGE

• COLUMN SIZE

Select max(marks), min(marks), avg(marks) from student;

Is the above query is correct?

• Yes

• We can not use three aggregate function in single query.

• No

Which of the following is not the clause in MySQL?

• Group By

• Order By

• Default

• Having