Question
a.
CASE
b.
IF()
c.
IFNULL()
d.
NULLIF()
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 function returns NULL if expr1 = expr2?
Similar Questions
Discover Related MCQs
Q. The server is told to accept spaces after function names by _____________
View solution
Q. The maximum non zero value for FLOAT is ______________
View solution
Q. ‘fetchrow_hashref()’ returns a reference to the hash of row values keyed by what?
View solution
Q. Which function returns a reference to hash of row values?
View solution
Q. Which function returns an array of row values?
View solution
Q. What does RTF refer to?
View solution
Q. Which operator compares sounds?
View solution
Q. The right shift operator is _____________
View solution
Q. Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?
View solution
Q. In which mode is the indicator of the presence/absence of a word in search used?
View solution
Q. The mode of search is the search string parsed into words and the search looks for rows is ______________
View solution
Q. What is the non handle array representing a row of values?
View solution
Q. What is the generic handle whose meaning depends on context?
View solution
Q. MySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.
View solution
Q. SPATIAL indexes cannot be created on NOT NULL spatial columns.
View solution
Q. Which type can store a collection of objects of any type?
View solution
Q. Which classes does spatial data types in MySQL correspond to?
View solution
Q. Which variable is a handle to a database object?
View solution
Q. The variable used as a handle to an open file is ______________
View solution
Q. The functions in Perl DBI called?
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!