# CBSE Class-12 Question Papers for IOP/Comptt Examination 2017 : All India Scheme, Informatics Practices

Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in

## All India Scheme, (Informatics Practices)

### CBSE Class-12 Question Papers for IOP/Cmptt Examination :  Informatics Practices

INFORMATICS PRACTICES

Time allowed : 3 hours

Maximum Marks : 70

General Instructions :

(i) All questions are compulsory.

1. (a) What happens to the Network with Star topology if the following happens : 2
(i) One of the computers on the network fails ?
(ii) The central hub or switch to which all computers are connected, fails ?
(b) Write the purpose of http. 2
(c) Write the purpose of the following devices : 2
Network Interface Card
Repeater
(d) How does Open source software emphasize collaboration and sharing ? 2
(e) Explain 2 measures that a school should take to ensure security of their computer network.

2. (a) Write the value that will be assigned to variable x after executing the following statement : 1
x = 3 + 36/12 + 2*5;
(b) Distinguish between parselnt() and parseDouble() methods. 1
(c) What is the difference between a PasswordField and a TextField ? 1
(d) Consider the statement : 1 fname = “Rishabh”;
(i) What is the datatype of fname ?
(ii) Is 456 the same as “456” ? Give reason.
(e) Given below is HTML code. Rewrite code after correcting errors. Underline
each correction. 2
<html>
<title>HTML
<body>
</title>
<p>Learning HTML is fun
(f) Expand XML. How are XML tags different from HTML tags ? Write two points. 2
(g) What values will be assigned to b, r and t after execution of the following code : 2
for(int i = 0; i <= 2; i++) {
switch(i) {
case 1:
{
b=i;
break;
}
case 2:
{
r=i;
break;
}
default:{
t=i; }
}
}

3. (a) What is the relationship between SQL and MySQL ? 1
(b) Define the term ‘database transaction’. 1
(c) Rashi wants to add another column ‘Hobbies’ with datatype and size as VARCHAR(50) in the already existing table ‘Student’. She has written the following statement. However it has errors. Rewrite the correct statement.

MODIFY TABLE Student Hobbies VARCHAR;
(d) Write SQL query to display employee details from table named ‘Employee’ whose ‘firstname’ ends with ‘n’ and firstname contains a total of 4 characters (including n). 1
(e) Identify Single Row functions of MySQL amongst the following : 1
TRIM(), MAX(), COUNT(*), ROUND()
(f) Write the following statement using ‘OR’ logical operator : 1
SELECT first_name, last_name, subject
FROM studentdetails
WHERE subject IN (‘Maths’, ‘Science’);
(g) Consider an “Employee” table with “Location” column. Entering data for the Location column is optional. 2
If one enters data for a row with no value for the “Location” column, what value will be saved in the “Location” column ?

Write SQL statement to display the details of rows in the “employee” table whose location is left blank.

(h) Given below is the ‘Department’ table : 2
DEPCODE DEPNAME
102 RECEPTION
103 PERSONNEL
SET AUTOCOMMIT = 0;
UPDATE Department SET DEPNAME = ‘OFFICE’ WHERE
INSERT INTO Department VALUES (104, ‘HRD’);
UPDATE Department SET DEPNAME = ‘FRONT OFFICE’ WHERE
DEPNAME = ‘RECEPTION’;
COMMIT;
DELETE FROM Department WHERE DEPNAME = ‘FRONT OFFICE’;
ROLLBACK;
SELECT * FROM Department;
What will be the output of the above given SELECT statement ?
4. (a) Write the values of num2 and num3 after execution of following code : 1
int num1, num2, num3;
num1 = 100;
num2 = ++num1;
num3 = num2++ + ++num1;