Page 18 - IP

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

Ans HTML is used to create web page(s).
<P>​ tag is used to introduce a paragraph while <BR> tag is used to introduce a line
break on a web page.
Note: ​<P>​ as paragraph tag and ​<BR>​ as line break tag to be accepted as difference

(1 mark for stating the purpose)
( 1 mark for correct difference)
(e) Distinguish between ComboBox and ListBox. When would you prefer using them over 2
Radiobutton and Checkbox?
Ans A ComboBox allows selection of one item from a set of items .
while ListBox provides a scrollable set of items from which one or more item(s) may be
selected.
When the number of items are more Combobox or ListBox would be preferred over
Radiobutton and Checkbox.
(1 mark for correct difference)
(1 mark for stating the preference)
(f) Rewrite the following code using switch statement: 2
if ( code == ‘A’)
allowance = 3500;
else if ( code == ‘B’)
allowance = 3200 ;
else
allowance = 2000 ;

Ans switch(code)
{
case ‘A’ : allowance = 3500;
break ;
case ‘B’ : allowance = 3200;
break ;
default : allowance = 2000;
}
Note:65 in place of ‘A’ and 66 in place of ‘B’ should be accepted
(½ mark for correct use of switch)
(½ mark for correct use of case)
(½ mark for correct assigning of allowance)
(½ mark for correct use of default)
3 (a) What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain 1
the MySQL software ?
Ans i) MySQL is an open source RDBMS used for managing databases.
ii) For obtaining MySQL , Abhay has the following options :
● download from the website mysql.org
● download it from any website that offers MySQL.
● get the software from any source
(½ mark for part i)
(½ mark for stating any one valid option for part ii)
(b) In the table “Student”, ​Priya wanted to increase the Marks(Column Name:Marks) of those 1
students by 5 who have got Marks below 33. She has entered the following statement:

Page 3 of 13