Comparing a known value with NULL results into _______________(a) null(b) zero(c) a positive value(d) a negative valueThe question was asked during an online exam.The question is from Using the Embedded Server Library topic in division MySQL Programs Using C of MySQL

Comparing a known value with NULL results into _______________(a) null

1.	Comparing a known value with NULL results into _______________(a) null(b) zero(c) a positive value(d) a negative valueThe question was asked during an online exam.The question is from Using the Embedded Server Library topic in division MySQL Programs Using C of MySQL
Answer» Correct option is (a) NULL For explanation I WOULD SAY: In MySQL, NULL is not comparable to other KNOWN values. It will result in a NULL when COMPARED to any value. The following statement would result in four NULLs: ‘SELECT NULL = 0, NULL < 0, NULL <> 0, NULL > 0′.

Discussion

No Comment Found

Related InterviewSolutions

What is the general term for information about databases and the objects in MySQL?(a) datum(b) info(c) record(d) metadataI had been asked this question in a national level competition.I need to ask this question from Using Server-Side Prepared Statements in division MySQL Programs Using C of MySQL
The statement used to change the table name is __________(a) RENAME(b) CHANGE(c) CHANGENAME(d) CHANGENMThis question was posed to me by my school teacher while I was bunking the class.Enquiry is from Using Server-Side Prepared Statements in division MySQL Programs Using C of MySQL
The statement used to remove indexes on tables is ______________(a) DROP INDEX(b) DELETE INDEX(c) REMOVE INDEX(d) FLUSH INDEXI have been asked this question during an interview.This is a very interesting question from Using Server-Side Prepared Statements topic in division MySQL Programs Using C of MySQL
The statement that makes changes to the global attributes of the database is ______________(a) CHANGE(b) ALTER(c) ALTERNATE(d) UPDATEThis question was addressed to me in a national level competition.Question is from Using Server-Side Prepared Statements in portion MySQL Programs Using C of MySQL
The statement used to select a default database is ______________(a) USE(b) CREATE(c) DROP(d) SCHEMAThis question was addressed to me in an international level competition.Question is taken from Using Server-Side Prepared Statements in portion MySQL Programs Using C of MySQL
A synonym for CHARACTER SET is ______________(a) CSET(b) CHSET(c) CHARSET(d) CHCSETI got this question in a national level competition.The question is from Using Server-Side Prepared Statements topic in chapter MySQL Programs Using C of MySQL
The maximum collations a character set can have is ______________(a) 0(b) 1(c) 2(d) more than 1This question was posed to me in an interview for internship.Query is from Using Server-Side Prepared Statements topic in division MySQL Programs Using C of MySQL
The binary protocol is more difficult to use.(a) True(b) FalseThe question was posed to me in an online quiz.This intriguing question comes from Using Server-Side Prepared Statements topic in division MySQL Programs Using C of MySQL
The binary protocol does not support all statements.(a) True(b) FalseThis question was posed to me in examination.I'd like to ask this question from Using Server-Side Prepared Statements in chapter MySQL Programs Using C of MySQL
The default case sensitivity of the database and table names depends on ___________(a) Server SQL mode(b) Operating system of machine(c) Does not depend on anything(d) SQL serverThis question was posed to me in final exam.My doubt stems from Using Multiple-Statement Execution topic in section MySQL Programs Using C of MySQL

Comparing a known value with NULL results into _______________(a) null(b) zero(c) a positive value(d) a negative valueThe question was asked during an online exam.The question is from Using the Embedded Server Library topic in division MySQL Programs Using C of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment