Logo

Mysql Questions Set 23:

Quiz Mode

What value does a successful SQL query return?

1
2
3
4

Solution:

How many values can be returned from a stored procedure? 

1
2
3
4

Solution:

 The MySQL double dashed comment style is same as the SQL standard. 

1
2

Solution:

What does ‘A’ stand for in the ACID property of transactions? 

1
2
3
4

Solution:

  What will be the output of the following statement “false AND Null”?
 

1
2
3
4

Solution:

 Which value of event_scheduler enables checking status but not changing it at runtime? 

1
2
3
4

Solution:

 What is used to produce a new string from an old string in the desired character set? 

1
2
3
4

Solution:

   In MySQL databases, the structure representing the organizational views of the entire databases is ____________

1
2
3
4

Solution:

What is the correct syntax to rename a column of any table in MySQL?

1
2
3
4

Solution:

What is the major difference between the TRUNCATE and DROP commands?

1
2
3
4

Solution: