Q. Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value _____________

View solution

Q. The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number _____________

View solution

Q. In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is _____________

View solution

Q. In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________

View solution

Q. The expression 12 DIV 5 evaluates to ____________

View solution

Q. If the PIPES_AS_CONCAT is disabled, ‘abc’ || ‘xyz’ results in ____________

View solution

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