MySQL server mode values are case insensitive. 

  Which option is used for specifying the executable name while compiling with gcc?
 

  What does ‘C’ stand for in the ACID property of transactions? 

What is ‘tamp’ in the following command?

mysql -h xyz.host.try.net -p -u tamp

 The best datatype for a column that is expected to store values up to 2 million is _________
 

Which of the following WHERE clauses are faster?

1. WHERE col * 3 < 9
2. WHERE col < 9 / 3

 Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?
 

What does a fully qualified table name consist of? 

In the SQL code provided, what is the purpose of the ENGINE = InnoDB clause?

Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?