Intermediate MySQL MCQ Interview Question’s & Answer’s

Intermediate MySQL

1 / 10

Is it important to provide where condition with update statement in MYSQL?

2 / 10

What does the show tables command do?

3 / 10

Suppose you are asked to drop a column using alter statement then which syntax you will follow?

4 / 10

Suppose you have a table named to test and inside this table you have a column named CGPA now if you are asked to change the column named CGPA to total percentage, using alter command then which of the following statement you will write?

5 / 10

Can you change the column name using alter command?

6 / 10

Which of the following is the correct syntax to add a field using alter command?

7 / 10

ALTER command is a type of which SQL command?

8 / 10

Which of the following command is used to delete a database?

9 / 10

If our database name is 'schooldb' and we want to drop this database will the query work if we will write our database name in capital letters?

10 / 10

In the following statement, what do you mean by the 'student'?

Your score is

The average score is 0%