To disallow zero month or day parts in dates, the option used is _____________(a) NO_ZERO_IN_DATE(b) NO_DATE_WITH_ZERO(c) ZERO_IN_DATE(d) DATE_WITH_ZEROThis question was addressed to me in an internship interview.This intriguing question comes from Date and Time Data Types topic in chapter Data Type Reference, Operators and Functions of MySQL

To disallow zero month or day parts in dates, the option used is _____

1.	To disallow zero month or day parts in dates, the option used is _____________(a) NO_ZERO_IN_DATE(b) NO_DATE_WITH_ZERO(c) ZERO_IN_DATE(d) DATE_WITH_ZEROThis question was addressed to me in an internship interview.This intriguing question comes from Date and Time Data Types topic in chapter Data Type Reference, Operators and Functions of MySQL
Answer» The CORRECT answer is (a) NO_ZERO_IN_DATE Explanation: MySQL permits to store the DATES where the day or MONTH and day are zero in a DATE or DATETIME COLUMN. This is helpful for applications that need to store birthdates for which the exact date is unknown.

Discussion

No Comment Found

Related InterviewSolutions

The facility that allows nesting one select statement into another is ______________(a) nesting(b) binding(c) subquerying(d) encapsulatingI got this question in an interview for job.The origin of the question is Functions in section Data Type Reference, Operators and Functions of MySQL
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________(a) CARTESIAN JOIN(b) CROSS JOIN(c) INNER JOIN(d) RIGHT JOINI had been asked this question in examination.My doubt is from Functions in portion Data Type Reference, Operators and Functions of MySQL
What does the AUTO_INCREMENT sequences begin at by default?(a) 0(b) 1(c) -1(d) 2The question was posed to me by my school teacher while I was bunking the class.My question is from Functions in section Data Type Reference, Operators and Functions of MySQL
There cannot be more than one column per table with the AUTO_INCREMENT attribute.(a) True(b) FalseI got this question by my college professor while I was bunking the class.The origin of the question is Functions in portion Data Type Reference, Operators and Functions of MySQL
CGI.pm does not support an object oriented style of use.(a) True(b) FalseThe question was asked in a national level competition.Question is from Functions topic in division Data Type Reference, Operators and Functions of MySQL
The string function that returns the index of the first occurrence of substring is _____________(a) INSERT()(b) INSTR()(c) INSTRING()(d) INFSTR()I got this question in examination.The origin of the question is Functions topic in section Data Type Reference, Operators and Functions of MySQL
The operator that compares sounds is _____________(a) MATCH SOUNDS(b) CHECK SOUNDS(c) SOUNDS LIKE(d) SOUNDS SIMILARThe question was asked in exam.The question is from Functions topic in division Data Type Reference, Operators and Functions of MySQL
Which function returns NULL if expr1 = expr2?(a) CASE(b) IF()(c) IFNULL()(d) NULLIF()I had been asked this question during a job interview.I would like to ask this question from Functions topic in portion Data Type Reference, Operators and Functions of MySQL
The server is told to accept spaces after function names by _____________(a) –sql-mode=SKIP_SPACE(b) –sql-mode=IGNORE_SPACE(c) –sql-mode=SPACE_IGNORE(d) –sql-mode=SPACE_SKIPI have been asked this question by my college director while I was bunking the class.Origin of the question is Functions topic in portion Data Type Reference, Operators and Functions of MySQL
The maximum non zero value for FLOAT is ______________(a) 3.402823466E+38(b) 3.402823466E+37(c) 3.402823466E+39(d) 3.402823466E+35This question was addressed to me in an online quiz.I would like to ask this question from Operators in chapter Data Type Reference, Operators and Functions of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment