Students can access the CBSE Sample Papers for Class 12 Informatics Practices with Solutions and marking scheme Term 2 Set 6 will help students in understanding the difficulty level of the exam.

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 6 for Practice

Time: 2 Hours
Maximum Marks: 35

General Instructions :

  • The. question paper is divided into 3 sections – A, B and C
  • Section A, consists of 7 questions (1-7). Each question carries 2 marks.
  • Section B, consists of 3 questions (8-10). Each question carries 3 marks.
  • Section C, consists of 3 questions(11-13). Each question carries 4 marks.
  • Internal choices have been given for question numbers -1,3, 8 and 12.

Section – A [2 marks each]

Question 1.
AYAN, a Network administrator, Help Ayan by clearly differentiating between WWW and URL. [2]
OR
State the difference between Email and Chat [2]

Question 2.
(i) I:
(a) am a technology that allows you to make voice calls using a broadband internet connection instead of a regular phone line.
(b) provides significant cost savings over a traditional phone system.
Who am I?
(ii) Name any two popular protocols. [2]

Question 3.
Predict the output of the following queries:
(i) Select TRUNCATE(6.25698,2);
(ii) Select ROUND(6.25698,2); [2]
OR
Briefly explain the purpose of the following SQL functions:
(i) TRUNCATE ()
(ii) ROUND () [2]

Question 4.
XYZ consultancy is planning to link its branch office in Delhi to its head office in London. Write one way to connect. What type of network (out of LAN/WAN/MAN) will be formed? [2]

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 6 for Practice

Question 5.
predict the output of the following queries:
SELECT Mon Ihf2022-01-29′);
SELECT Day(‘2022-01-29’); [2]

Question 6.
Ashok , a database administrator,want to cut a substring from a word without using SUBSTRQ,/ SUBSTRINGQ function.
Suggest suitable command/function/clause for it and properly explain its usage with the help of an example. [2]

Question 7.
Consider the table Organisation
Table: Organisation

OrgCode Salary
C101 13000
C102 5000
C104 7000
C105 4000

(i) With SQL, how can you find the number of rows (records) in the Organisation table?
(ii) With SQL, how can you find the minimum salary from the Organisation table?

OR

What Output will be displayed by the following SQL statements :
(i) Select AVG (Salary) FROM Organisation;
(ii) Select MAX (Salary) FROM Organisation;

Section – B [3 Marks Each]

Question 8.
What will be the output of
(i) SELECT ROUND (124.44) + MOD (1200.87, 3);
(ii) SELECT MOD (30.500, 5) + ROUND (100.50,1);
(iii) SELECT POWER(2,10) + ROUND (100.50,1); [3]
OR
What will be the output of the following queries on the basis of Employee table :

EmpId EName Salary
A001 Bob 5600
A002 John NULL
A003 Tom 5000

(i) SELECT AVG(Salary) FROM Employee;
(ii) SELECT Salary FROM Employee WHERE Empld = ‘A002’;
(iii) SELECT MAX(Salary) FROM Employee; [3]

Question 9.
What is math function? Explain any two math functions with an example. [3]

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 6 for Practice

Question 10.
Given Employee table as follows:

EmpId Name Commission
101 Rahul Verma NULL
102 Divya Arora 8900
103 Faizal zaildi NULL

What values will the following statements return?
(i) SELECT COUNT(*) FROM Employee;
(ii) SELECT COUNT(commission) FROM Employee;
(iii) SELECT COUNT( DISTINCT(Emp Id)) FORM Employee;

Section – C [4 Marks Each]

Question 11.
Give the output of following sql statement based on table GRADUATE
TABLE: GRADUATE
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 6 for Practice 1
(i) SELECT MIN (AVERAGE) FROM GRADUATE WHERE SUBJECT=”PHYSICS”;
(ii) SELECT SUM (STIPEND) FROM GRADUATE WHERE DIV=TI’;
(iii) SELECT AVG (STIPEND) FROM GRADUATE WHERE AVERAGE> =65;
(iv) SELECT COUNT (DISTINCT SUBJECT) FROM GRADUATE; = [4]

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 6 for Practice

Question 12.
Consider the following table Activity. Write SQL commands for the statements (i) to (iv).
Table: Activity
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 6 for Practice 2
(i) To display names of Participants and points in descending order of points,
(ii) To display House wise total points scored along with House name. (i.e. display the HOUSE and total points scored by each HOUSE.)
(iii) To display Event wise result where point is more than 200.
(iv) To display the details of candidates who’s name is either starts with ‘Raj’ or ends with ‘Raj’.
OR
Based on the above given table named ‘ACTIVITY’, execute following queries:
(i) SELECT AVERAGE (POINTS) FROM Activity WHERE HOUSE = ‘Gandhi’ or HOUSE = ‘Bose’;
(ii) SELECT COUNT (DISTINCT POINTS) FROM ACTIVITY;
Predict the output of the above given queries.
Also give proper justifications of the output generated through each query. [4]

Question 13.
Delhi Public School in Meerut is starting up the network between its different wings. There are four building named as S, J, A and H.

The distance between various buildings is as follows :

A to S 200 mt
A to J 150 mt
A to H 50 mt
S to T 250 mt
S to H 350 mt
J to H 350 mt

Number of computers in each building :

S 130
J 50
A 160
H 50

(i) Suggest the cable layout of connections between the buildings.
(ii) Suggest the most suitable place (i.e. building) to house the server of this school, provide a suitable reason.
(iii) Suggest the placement of the following devices with justification.
(a) Repeater
(b) Hub/switch
(iv) The organisation also has enquiry office in another
City about 50-60 km away in hilly region. Suggest the suitable transmission media to inter¬connect school and enquiry office out of the following :
(a) Fibre optic cable
(b) Micro wave
(c) Radio wave [4]