Question
a.
ALLOW_DATES_INVALID
b.
ALLOW_INVALID_DATES
c.
PREVENT_DATE_CHECK
d.
STOP_DATES_CHECK
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 mode prevents MySQL to perform full checking of date parts?
Similar Questions
Discover Related MCQs
Q. Which keyword suppresses errors?
View solution
Q. Which mode prevents entry of the ‘zero’ date value in strict mode?
View solution
Q. STRICT_ALL_TABLES turns on stricter checking of data values.
View solution
Q. Which column attribute provides unique numbers for identification?
View solution
Q. There can be only one column per table with the AUTO_INCREMENT attribute.
View solution
Q. The AUTO_INCREMENT sequences normally begin at __________
View solution
Q. The value of recently generated sequence number can be obtained by ____________
View solution
Q. When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________
View solution
Q. The ‘LAST_INSERT_ID()’ is tied only to the ‘AUTO_INCREMENT’ values generated during the current connection to the server.
View solution
Q. Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value _____________
View solution
Q. The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number _____________
View solution
Q. In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is _____________
View solution
Q. In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________
View solution
Q. The expression 12 DIV 5 evaluates to ____________
View solution
Q. If the PIPES_AS_CONCAT is disabled, ‘abc’ || ‘xyz’ results in ____________
View solution
Q. ‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, results in ____________
View solution
Q. The expression ‘2 BETWEEN 2 AND 5’ results in ____________
View solution
Q. REGEXP takes collation into account.
View solution
Q. The expression ‘HI’ LIKE NULL results in _____________
View solution
Q. If the operands are non binary strings, LIKE compares them according to their collation.
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!
.png)
