Q. ‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, results in ____________

View solution

Q. The expression ‘2 BETWEEN 2 AND 5’ results in ____________

View solution

Q. REGEXP takes collation into account.

View solution

Q. The expression ‘HI’ LIKE NULL results in _____________

View solution

Q. If the operands are non binary strings, LIKE compares them according to their collation.

View solution

Q. The number of strings among the following matched with ‘%all%’ is _____________

Ball, baller, tall, tallest

View solution

Q. Which of the following is the correct order of precedence (high to low)?

View solution

Q. 0x61 + 0 results in _____________

View solution

Q. The AUTO_INCREMENT column attribute is best used with which type?

View solution

Q. Which datatype is best suited to store currency values?

View solution

Q. MySQL provides a date type that has an optional time part.

View solution

Q. If a column is expected to store values up to 2 million, the best datatype for it is _____________

View solution

Q. Which of these types store the longest length of strings?

View solution

Q. AUTO_INCREMENT columns must be NOT NULL.

View solution

Q. Which of these values is not valid as an AUTO_INCREMENT value?

View solution

Q. If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________

View solution

Q. INT2 maps to MySQL type _____________

View solution

Q. INT3 maps to MySQL type _____________

View solution

Q. Which of these is not an exact numeric type?

View solution

Q. How many of the following do not support ‘BIT’ data type?

MyISAM, MEMORY, NDB

View solution