Font size
WorksheetsMy Sql
Total questions: 10
Worksheet time: 2mins
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
