MySQL Practice Test 3

1. There can be only one column per table with the AUTO_INCREMENT attribute.

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

3. A BIT value in a result set is displayed as a binary string.

4. How many of the following attributes are allowed only for numeric types?

UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE

5. To produce a stored function, which statement is used?

6. Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?

7. Which Numeric Data type has the largest range?

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

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

10. Which of the following characters cannot be used as a delimiter?