Question:You have to calculate the value 12* salary* commission_pct for all the employees in the EMP table. Which of the following statements ensures that a value is displayed in the calculated column for all the employees? 

A SELECT last_name, 12 * salary* commission_pct FROM emp; 
B SELECT last_name, 12 * salary* (commission_pct,0) FROM emp; 
C SELECT last_name, 12 * salary* (nvl(commission_pct,0) )FROM emp; 
D SELECT last_name, 12 * salary* (decode(commission_pct,0)) FROM emp; 

+ 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