Examveda

The synonym for last_insert_id session variable is . . . . . . . .

A. insert_id

B. identity

C. sql_auto_is_null

D. sql_big_selects

Answer: Option B

Solution (By Examveda Team)

This question asks about a special variable in MySQL called last_insert_id. This variable holds the ID of the last row inserted into a table.
We need to find the synonym for this variable, which means another way of writing it.
Let's look at the options:
Option A: insert_id - This is the correct synonym for last_insert_id.
Option B: identity - This is not a synonym for last_insert_id. It is related to auto-incrementing columns.
Option C: sql_auto_is_null - This is not a synonym for last_insert_id. It is a system variable that controls the behavior of auto-incrementing columns.
Option D: sql_big_selects - This is not a synonym for last_insert_id. It is a system variable that controls the maximum number of rows allowed in a SELECT statement.
Therefore, the correct answer is Option A: insert_id.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous