Question
a.
error_count
b.
identity
c.
foreign_key_checks
d.
autocommit
Posted under MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which variable when set to 1 would enable foreign key checking for InnoDB tables?
Similar Questions
Discover Related MCQs
Q. The synonym for last_insert_id session variable is _____________
View solution
Q. When building from source, the embedded server library is enabled by what?
View solution
Q. What returns a string containing an error message?
View solution
Q. The statement that views status variables by aggregating the values over all connections is _____________
View solution
Q. Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?
View solution
Q. What is the synonym for last_insert_id session variable?
View solution
Q. The Audit_log_events system variable is of type _____________
View solution
Q. mysql_next_result() does not return a status.
View solution
Q. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________
View solution
Q. How many of the following do not return rows?
SELECT, SHOW, DESCRIBE
View solution
Q. What does mysql_fetch_row() return?
View solution
Q. The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.
View solution
Q. User defined variables are session specific.
View solution
Q. Hexadecimal values assigned to user variables are treated as _____________
View solution
Q. What is the type of Audit_log_events system variable?
View solution
Q. Multiple statement execution is disabled by default.
View solution
Q. The option that enables multiple-statement execution is ____________
View solution
Q. What does mysql_query() return on failure?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
