Explore topic-wise MCQs in Mysql.

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

The AUTO_INCREMENT sequences normally begin at __________.

A. 2
B. -1
C. 1
D. 0
E. None of these
Answer» D. 0
Discussion
2.

The value of recently generated sequence number can be obtained by ____________.

A. LATEST_INSERT_ID()
B. INSERT_ID()
C. LAST_INSERT_ID()
D. INITIAL_INSERT_ID()
E. None of these
Answer» D. INITIAL_INSERT_ID()
Discussion
3.

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

A. -1
B. 0
C. arbitrary
D. 1
E. None of these
Answer» E. None of these
Discussion
4.

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

A. 2
B. 1
C. 0
D. -1
E. None of these
Answer» D. -1
Discussion
5.

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

A. 1
B. 12
C. 14
D. 13
E. None of these
Answer» E. None of these
Discussion
6.

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

A. 101
B. 100
C. 11
D. 1
E. None of these
Answer» E. None of these
Discussion
7.

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

A. 100
B. 32
C. 101
D. 33
E. None of these
Answer» D. 33
Discussion
8.

The LAST_INSERT_ID() is tied only to the AUTO_INCREMENT values generated during the current connection to the server.

A. False
B. True
C. NA
D. NA
E. NA
Answer» C. NA
Discussion