Logo

Mysql Questions Set 35:

Quiz Mode

What does the mysql_query() function return on failure?

1
2
3
4

Solution:

Which SQL clause specifies periodic execution at fixed intervals?

1
2
3
4

Solution:

Which SQL statement is used to check how MySQL would execute a SELECT query?

1
2
3
4

Solution:

Which of the following statement can be used to change the table name?

1
2
3
4

Solution:

The “Mysql command line tool” format the results in which of the following format: 

1
2
3
4

Solution:

  The facility that allows nesting one select statement into another is called __________
 

1
2
3
4

Solution:

 Which statement is used to find out which character sets are available? 

1
2
3
4

Solution:

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

1
2
3
4

Solution:

Which of these statements about subqueries is true?

1
2
3
4

Solution:

 

What will be the result of the following query?


WHERE TITLE= ‘teller’ AND start_date < ’2007-01-01’

1
2
3
4

Solution: