Logo

Mysql Questions Set 25:

Quiz Mode

Which SQL keyword is used to retrieve the maximum value of a column?

1
2
3
4

Solution:

What is the default format for “Time” data type? 

1
2
3
4

Solution:

Which key declares that an index in one table is related to that in another? 

1
2
3
4

Solution:

 Which command is used on Mysql command line tool to return to window command shell?
 

1
2
3
4

Solution:

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

1
2
3
4

Solution:

 Which option executes all SQL statements in a SQL script irrespective of the number of errors? 

1
2
3
4

Solution:

 

What is ‘xyz’ in the following statement?

SELECT xyz FROM table1 UNION xyz FROM table2;

1
2
3
4

Solution:

Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute” 

1
2
3
4

Solution:

How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data? 

1
2
3
4

Solution:

Display all the values of the “First_Name” column using the alias “Employee Name”.

1
2
3
4

Solution: