MySQL Practice Test 3

1. The expression 'HI' LIKE NULL results in _____________

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

3. Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

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

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

6. STRICT_ALL_TABLES turns on stricter checking of data values.

7. What is the default format for “Date” data type?

8. When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________

9. In oracle database variable length column is declared by ____________

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