MySQL Mock Test 3 - Sanfoundry

10%

Question 1 of 10

1. 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 _____________

101

100

Question 1 of 10

Question 2 of 10

2. If the PIPES_AS_CONCAT is disabled, 'abc' || 'xyz' results in ____________

error

-1

Question 2 of 10

Question 3 of 10

3. Stored routines refers to stored functions and procedures.

False

True

Question 3 of 10

Question 4 of 10

4. The AUTO_INCREMENT sequences normally begin at __________

-1

Question 4 of 10

Question 5 of 10

5. The bit-field values are prefixed with __________

bit-

0bit

'bit'

Question 5 of 10

Question 6 of 10

6. MEMORY tables do not support BLOB and TEXT indexes.

False

True

Question 6 of 10

Question 7 of 10

7. Which of these return a result to the client?

Stored functions

Triggers

Events

Stored procedures

Question 7 of 10

Question 8 of 10

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

-1

Question 8 of 10

Question 9 of 10

9. If a string is to be converted to a number, it is converted into a _____________

hexadecimal integer

decimal integer

double precision floating point

single precision floating point

Question 9 of 10

Question 10 of 10

10. The BIGINT precision is of bit _________

128

Question 10 of 10