What is the SQL mode to check for divide by zero error? – McqOptions

MCQOPTIONS

1.	What is the SQL mode to check for divide by zero error?
A.	STRICT_ALL_TABLES
B.	ERROR_FOR_DIVISION_BY_ZERO
C.	ERROR_DIVIDE_BY_ZERO
D.	ERROR_WHEN_DIVIDE_BY_ZERO
Answer» C. ERROR_DIVIDE_BY_ZERO

Discussion

No Comment Found

Related MCQs

The privilege that must be given to the database to create a stored function or procedure is ____________
How would a stored function named PI() written in the database ‘sampdb’ be called?
THE_PRIVILEGE_THAT_MUST_BE_GIVEN_TO_THE_DATABASE_TO_CREATE_A_STORED_FUNCTION_OR_PROCEDURE_IS_____________?$
How would a stored function named PI() written in the database ‚Äö√Ñ√∂‚àö√ë‚àö‚â§sampdb‚Äö√Ñ√∂‚àö√ë‚àö¬• be called?#
The number of values returned from a stored procedure can be _______________
The mode used to turn on strict mode and all of the additional restrictions is _____________
What is the SQL mode to check for divide by zero error?
The command to see the warning messages is ______________
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.
Slow shutdown can be performed by setting innodb_fast_shutdown to _____________