What is the synonym for last_insert_id session variable?(a) insert_id(b) identity(c) sql_auto_is_null(d) sql_big_selectsThis question was addressed to me in unit test.The origin of the question is Status Variables in chapter System, Status and User Variables of MySQL

What is the synonym for last_insert_id session variable?(a) insert_id(

1.	What is the synonym for last_insert_id session variable?(a) insert_id(b) identity(c) sql_auto_is_null(d) sql_big_selectsThis question was addressed to me in unit test.The origin of the question is Status Variables in chapter System, Status and User Variables of MySQL
Answer» The CORRECT option is (b) identity The explanation: The SESSION only system VARIABLE ‘identity’ is a synonym for the ‘last_insert_id’ session variable. Setting ‘last_insert_id’ specifies the VALUE to be returned by the function ‘LAST_INSERT_ID()’.

Discussion

No Comment Found

Related InterviewSolutions

What does mysql_query() return on failure?(a) 0(b) 1(c) -1(d) a non-zeroI got this question in an internship interview.This key question is from User-Defined Variables in division System, Status and User Variables of MySQL
The option that enables multiple-statement execution is ____________(a) CLIENT_MULTI_STATEMENTS(b) CLIENT_STATEMENTS_MULTI(c) MULTI_STATEMENTS_CLIENT(d) MULTI_CLIENTS_STATEMENTSThe question was posed to me in a national level competition.I want to ask this question from User-Defined Variables in division System, Status and User Variables of MySQL
Multiple statement execution is disabled by default.(a) True(b) FalseI got this question during an internship interview.My question is taken from User-Defined Variables topic in chapter System, Status and User Variables of MySQL
What is the type of Audit_log_events system variable?(a) string(b) integer(c) float(d) doubleThe question was asked during an online interview.Question is taken from User-Defined Variables topic in chapter System, Status and User Variables of MySQL
Hexadecimal values assigned to user variables are treated as _____________(a) strings(b) non binary strings(c) binary strings(d) integersThis question was posed to me in class test.I would like to ask this question from User-Defined Variables topic in section System, Status and User Variables of MySQL
User defined variables are session specific.(a) True(b) FalseI got this question during a job interview.Question is from User-Defined Variables in portion System, Status and User Variables of MySQL
The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.(a) True(b) FalseI have been asked this question during an interview.My question is taken from Status Variables topic in section System, Status and User Variables of MySQL
What does mysql_fetch_row() return?(a) integer(b) float(c) structure(d) pointerThe question was posed to me during an interview for a job.The doubt is from Status Variables topic in division System, Status and User Variables of MySQL
The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________(a) –ensure(b) –force(c) –violent(d) –runThis question was posed to me during an interview.My enquiry is from Status Variables topic in section System, Status and User Variables of MySQL
mysql_next_result() does not return a status.(a) True(b) FalseThe question was asked in an online interview.I want to ask this question from Status Variables in chapter System, Status and User Variables of MySQL

What is the synonym for last_insert_id session variable?(a) insert_id(b) identity(c) sql_auto_is_null(d) sql_big_selectsThis question was addressed to me in unit test.The origin of the question is Status Variables in chapter System, Status and User Variables of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment