Page 20 - IP

CBSE AISSCE 2018 Marking Scheme for Informatics Practices
(​Sub Code: 065 Paper Code 90​)

Ans (Case 1​: If RNO is treated as ID, the following solution should be accepted:)
Output of SELECT statement 1 :
RNO NAME
5 Rajeev
6 Chris

7 Feroze

O​utput of SELECT statement 2 :
RNO NAME
5 Rajeev
6 Chris

(Case 2 :​ If RNO is ​NOT​ treated as ID, the following should be accepted:)
Output of SELECT statement 1 :
RNO NAME
5 Rajiv
6 Chris
7 Feroze
O​utput of SELECT statement 2 :

RNO NAME
5 Rajiv
6 Chris

Case 1 and 2 : ( 2 mark for output of ​any one​ of the​ SELECT​ statement)
Note : 2 marks for mentioning column name error
(f) Name SQL Single Row functions (for each of the following) that 2
(i) returns a number.
(ii) returns lowercase letters.
(iii) returns names of days. For example: “Monday “, “Tuesday”.
(iv) returns weekday number. For example : 1 for Sunday , 2 for Monday , 3 for
Tuesday.
Ans (i) ​length()/ instr()/ round()/ truncate()​ or any other correct Single
Row Function that returns a number
(ii) ​lower() / lcase()
(iii) ​dayname()
(iv)​ ​dayofweek()
(½ mark for each part)
4 (a) Identify the error in the following code: 1

switch(c)
{
case 9.0 : a= a+2;
break;
case 8.0 : a=a+3;
break;
}

Page 5 of 13