Logo

Mysql Questions Set 32:

Quiz Mode

How many common constraints are there in MySQL?

1
2
3
4

Solution:

 ‘1234’ is a ____________ 

1
2
3
4

Solution:

 Which command is used for taking “server side help” in Mysql command line tool? 

1
2
3

Solution:

Which of the following SQL commands is a Data Manipulation Language (DML)?

1
2
3
4

Solution:

The file created by the server to store the database attributes is __________ 

1
2
3
4

Solution:

 The MySQL server used in its client/server architecture is _______________
 

1
2
3
4

Solution:

  What sets the association between one or more MyISAM tables and the named key cache? 

1
2
3
4

Solution:

What can be used to check for views that have been invalidated by DROP or ALTER operations? 

1
2
3
4

Solution:

What is the SQL keyword that connects rows with foreign keys to the corresponding data in the table that the foreign key points to?

1
2
3
4
5

Solution:

 What is the need of “column Aliases” in “SELECT” clause?
 

1
2
3
4

Solution: