Question
a.
0
b.
1
c.
-1
d.
2
Posted under MySQL Data Types and Operators MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The AUTO_INCREMENT sequences normally begin at __________
Similar Questions
Discover Related MCQs
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
Q. The number of strings among the following matched with ‘%all%’ is _____________
Ball, baller, tall, tallest
View solution
Q. Which of the following is the correct order of precedence (high to low)?
View solution
Q. 0x61 + 0 results in _____________
View solution
Q. The AUTO_INCREMENT column attribute is best used with which type?
View solution
Q. Which datatype is best suited to store currency values?
View solution
Q. MySQL provides a date type that has an optional time part.
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!
