gs gs113 Data Types - How MySQL Handles Invalid Data Values - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Types. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 2: For which type are illegal values converted to the appropriate ‘zero’ value?
Numeric
String
ENUM
TIME
Question 3: What is the command to see the warning messages?
DISPLAY WARNINGS
DISP WARNINGS
DISP WARNING
SHOW WARNINGS
Question 4: The SQL mode to check for divide by zero error is ________________
STRICT_ALL_TABLES
ERROR_FOR_DIVISION_BY_ZERO
ERROR_DIVIDE_BY_ZERO
ERROR_WHEN_DIVIDE_BY_ZERO
Question 5: Which mode is used to turn on strict mode and all of the additional restrictions?
STRICT_ALL_TABLES
ERROR_FOR_DIVISION_BY_ZERO
TRADITIONAL
ERROR_WHEN_DIVIDE_BY_ZERO
Question 6: Which mode is a shorthand for ‘both strict modes plus a bunch of other restrictions’?
STRICT_ALL_TABLES
STRICT_TRANS_TABLES
TRADITIONAL
ERROR_WHEN_DIVIDE_BY_ZERO
Question 7: Which mode prevents MySQL to perform full checking of date parts?
ALLOW_DATES_INVALID
ALLOW_INVALID_DATES
PREVENT_DATE_CHECK
STOP_DATES_CHECK
Question 8: Which keyword suppresses errors?
SUPPRESS
STOP
PREVENT
IGNORE
Question 9: Which mode prevents entry of the ‘zero’ date value in strict mode?
SUPPRESS
NO_ZERO_DATE
PREVENT
NO_ZERO_IN_DATE
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
