Logo

Mysql Questions Set 33:

Quiz Mode

What cannot be done on a view? 

1
2
3
4

Solution:

   What does ‘mysql_query()’ return on failure?
 

1
2
3
4

Solution:

 The maximum length of the char columns is 

1
2
3
4

Solution:

What is abc in the following staTement?


DECLARE abc HANDLER FOR def ghi; 

1
2
3
4

Solution:

 The clause that is used to display information that matches a given pattern is _____________ 

1
2
3
4

Solution:

  What can be used in place of MYSQL_SERVER_VERSION?
 

1
2
3
4

Solution:

Which among the following are the correct definitions for “NULL” in Mysql? 

1
2
3
4

Solution:

In an existing table, ALTER command can be used to:

1
2
3
4
5

Solution:

 

What is the host name in the following command?

mysql -h cobra.snake.net -p -u sampadam

1
2
3
4

Solution:

To execute the contents of a query file ‘exec.sql’ by feeding it to MySQL, which command is used? 

1
2
3
4

Solution: