Question:Consider the following table:

Order
- - - - -
Orderid
Customerid
Orderdate
Comments

Select ISNULL (Comments, 'No comments') AS comments From Order

What will be the output of the above query? 

A The output will always be "No comments" irrespective of the value in the Comments field 
B The output will be null in all the rows 
C The output will be "No comments", when the database entry is Null 
D The output will be "No comments", when the database entry is Not Null 
E This query is erroneous 

+ Answer
C 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description