Please refer to Class 12 Informatics Practices Sample Paper with solutions provided below. All class 12 Informatics Practices sample papers have been provided below based on the latest CBSE pattern and examination guidelines issued for the current academic year. Students must practice a lot of CBSE Sample Papers for Class 12 Informatics Practices as it will help them to clear all doubts. Practicing more guess papers for Standard 12 Informatics Practices will help them to get more marks.

CBSE Sample Paper for Class 12 Informatics Practices

Class 12 Informatics Practices Sample Paper Term 2 Set A

SECTION – B

1. Differentiate between web server and web browsers.
(i) Name the protocol that is used to upload and download files on internet.
(ii) Name the protocol that is used to send emails.
Answer: Web Browser : A web browser is a software application for accessing information on the World Wide Web. When a user requests a web page from a particular website, the web browser retrieves the necessary content from a web server and then displays the page on the user‟s device.
Web Server : A web server is a computer that runs websites. The basic objective of the webserver is to store, process and deliver web pages to the users. This intercommunication is done using Hypertext Transfer Protocol (HTTP).
OR
Answer: (i) FTP or HTTP
(ii) SMTP

2. (i) Rearrange the following terms in increasing order of speedy medium of data transfer:
Telephone line, Fiber Optics, Coaxial Cable, Twisted Paired Cable 
(ii) Somesh has purchased a new Smart TV and wants to cast a video from his mobile to his new Smart TV. Identify the type of network he is using and explain it 
Answer: (i) Telephone line, Twisted Pair Cable, Coaxial Cable, Fiber Optics 
(ii) Somesh is using PAN-Personal Area Network. It is a private network which is setup by an individual to transfer data among his personal devices of home.

3. Consider the following SQL string:
“fortuner” Write commands to display:
a. “tuner” b. “for”
Answer: a. select substr(“fortuner”, 4);
or select right(“fortuner “,4);
b. select left(“fortuner”, 3);
OR
Considering the same string “fortuner” Write SQL commands to display:
a. the position of the substring ‘for’ in the string “fortuner”  b. the last 4 letters of the string
Answer: a. select instr (‘fortuner’ , ‘tuner’));
b. select right (‘fortuner’,4);

4. What is the difference between hub and switch?
Which is more preferable in a large network of computers and why?
Answer: Hub forwards the message to every node connected and create a huge traffic in the network hence reduces efficiency whereas a Switch (also called intelligent hub) redirects the received information/ packet to the intended node(s). In a large network a switch is preferred to reduce the unwanted traffic in the network.
It makes the network much more efficient

5. Consider the decimal number x with value 8459.2654. Write commands in SQL to:
i. round it off to a whole number
ii. round it to 2 places before the decimal.
Answer: Output:
i. select round(8459.2654);
ii. select round(8459.2654,-2);

6. State any two differences between single row functions and multiple row functions.
Answer: Differences between single row functions and multiple row functions.
(i) Single row functions work on one row only whereas multiple row functions group rows
(ii) Single row functions
return one output per row whereas multiple row functions return only one output for a specified group of rows.

7. Consider the following table GAMES and Write SQL commands for the following:-

(i) To display details of those games which are having PrizeMoney more than 7000.
(ii) To display sum of PrizeMoney for each of the Number of participation groupings (as shown in column Number 2 or 4)
Answer: (i) SELECT * FROM GAMES WHERE PrizeMoney>7000;
(ii) SELECT SUM(PrizeMoney),Number FROM GAMES GROUP BY Number;
OR
(a) A table “Animals” in a database has 3 columns and 10 records.
What is the degree and cardinality of this table?
(b) Which keyword is used to remove redundant data from a relation?
Answer: a) degree 10 and cardinality 3
½ mark for each answer
b) distinct

SECTION – B

8. Predict the output of the following queries:
i. select instr(‘EK BHARAT SHRESHTHA BHARAT @ CBSE’,’A’);
ii. select CURDATE( )+5; (Assume today’s date is 10th Jan)
iii. select lcase(‘ACCountancy AND Business Studies’);
Answer: Output:
iv. 6
v. 15
iii. accountancy and business studies
OR
Mrs. Sunita is working on a MySQL table named ‘Hometown’ having following structure:

She needs to perform following task on the table:
i. To display the sign of the marks from the table.
ii. To display the total no of characters in each city.
iii. To display last 3 letters extracted from the names of students.
Suggest suitable SQL function for the same. Also write the query to achieve the desired task.
Answer: iv. Sign()
select sign(marks) from hometown;
v. length()
select city, length(city) from hometown;
vi. right()
Select right(name,3) from hometown

9. Explain the difference between Update and Alter command
with help of an example.
Answer: UPDATE command is a part of DML command and used to update the data of rows of a table. While ALTER command is a part of DDL command and used to change the structure of a table like adding column, removing it or modifying the datatype of columns

10. (i) What is the difference between CHAR & VARCHAR data types in SQL?
(ii) Write full form of DDL and DML.
Answer: CHAR is used to occupy fixed memory irrespective of the actual values but VARCHAR uses only that much memory which is used actually for the entered values. E.g. CHAR(10) will occupy always 10 bytes in memory no matter how many characters are used in values. But VARCHAR will uses only
that much bytes of memory whose values are passed.

Section C

11. Give the output for the following queries based on table GARMENT:

(i) SELECT COUNT(DISTINCT SIZE) FROM GRAMENT;
(ii) SELECT AVG(PRICE) FROM GRAMENT;
(iii) SELECT GNAME,COLOUR FROM GRAMENT WHERE SIZE=’M’;
(iv) SELECT GANEME,COLOUR FROM GRAMENT WHERE PRICE>=3000;
Answer: (i) COUNT(DISTINCT SIZE)
3
(ii) AVG(PRICE)
1800
(iii) GNAME COLOUR
Skirt Black
(iv) GNAME COLOUR
Ladies Jacket Blue

12. Consider the table TEACHER given below:

Write commands in SQL for (i) to (iv) . Note: Hiredate is in mm/dd/yyyy format .
i. To display all information about teachers of Female PGT Teachers.
ii. To list names, departments and date of hiring of all the teachers in descending order of date of joining.
iii. To count the number of teachers and sum of their salary department wise.
iv. To display the hiredate of senior most teacher in male and in female.
Answer: Output:
i. Select * from Teacher where Category= “PGT” and Gender=’F’;
ii. Select Name, Department, Hiredate from Teacher order by Hiredate desc;
iii. Select count(*), sum(salary) from Teacher group by Department;
iv. SELECT MAX(Hiredate) ,Gender FROM Teacher group by Gender;
OR
Write a MySQL command for creating a table “PAYMENT” whose structure is given below:

Also explain the difference between primary key and foreign key.
Answer: Mysql> create table payment (loan_number int(5) primary key, payment_number varchar(7), payment_date date, paymentamount int(6) not null); A primary key is a special key in a relational database that acts as a unique identifier for each record meaning it uniquely identifies each row/record in a table and its value should be unique for each row of the table. A foreign key, on the other hand, is a field in one table that link two tables together. It refers to a column or a group of columns that uniquely identifies a row of another table or same table.

13.

Answer: (i)Finance block because it has the maximum numbers of computers
(ii) Cable Layout:

(iii) satellite link.
(iv) switch.