R

Ravi Shankar • 4.19K Points
Extraordinary 

Q. Which of the following returns an SQLSTATE code?

  • (A) mysql_error()
  • (B) DISP WARNINGS
  • (C) mysql_sqlstate()
  • (D) mysql_close()
  • Correct Answer - Option(C)
  • Views: 10
  • Filed under category MySQL
Explanation by: Ravi Shankar 
This question is about how to get information about errors that happen when you're using MySQL.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. If our database name is 'schooldb' and we want to drop this database will the query work if we will write our database name in capital letters?

Q. Which of the following is the correct syntax to add a field using alter command?

Q. MySQL does not provide a date type that has an optional time part.

Q. The number of tables for which DELAYED works is . . . . . . . . MyISAM, MEMORY, ARCHIVE, BLACKHOLE

Q. Find the error in the following MySQL statement? SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;

Q. Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.

Q. Comparing a known value with NULL results into . . . . . . . .

Q. When building from source, the embedded server library is enabled by . . . . . . . .

Q. Which case does InnoDB store database names in?

Q. Which statement is used to create a trigger?

Learn All MySQL MCQs

Question analytics