Logo

Mysql Questions Set 52:

Quiz Mode

 What is the maximum collations a character set can have? 

1
2
3
4

Solution:

Which of the given options prints output in table-format when MySQL is ran interactively?

1
2
3
4

Solution:

Which keyword is used to specify the foreign key after the table is created? 

1
2
3
4

Solution:

Which among the following is the correct syntax for showing all tables in the database? 

1
2
3
4

Solution:

 

What is the host name in the following command?


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

1
2
3
4

Solution:

If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________ 

1
2
3
4

Solution:

  What is the role of “CONSTRAINS” in defining a table in Mysql? 

1
2
3
4

Solution:

SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? 

1
2
3
4

Solution:

 What is the use of “VIEW” in Mysql? 

1
2
3
4

Solution:

 

What will be the output of the following query?


 SELECT * FROM employee WHERE lname LIKE %t%f%n%; 

1
2
3
4

Solution: