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

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 10 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.
Suman, a freelance Network engineer has been assigned a task to design a Network for an Office.
Help suman by clearly differentiating between LAN, MAN and WAN on at least two points. So, that he can decide which is to be implemented. [2]
OR
Priyanka, a beginner in Networking has been assigned a task to design a Network for an Office. Help her in understanding the difference between Switch and Hub. [2]

Question 2.
(i) I:
(a) I am commonly known as the Web.
(b) I am an information system where documents and other web resources are identified by Uniform Resource Locators.
Who am I?
(ii) Name any two popular VoIP [2]

Question 3.
Predict the output of the following queries:
(i) Select power(3,2.5);
(ii) Select mod(-5,3); [2]
OR
Briefly explain the purpose of the following SQL functions:
(i) LEFT()
(ii) RIGHTO [2]

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

Question 4.
Priya is a network administrator help her to understand what is mesh topology with example? [2]

Question 5.
Help Ram in predicting the output of the following queries:
SELECT TRUNCATE (2345.1365,2);
SELECT ROUND (1254.48796542, -1); [2]

Question 6.
Ayus, a database administrator, he wants to put a condition on each group of employees (Department wise ) in a table Emp.
Suggest suitable command for it and properly explain it along with the syntax. [2]

Question 7.
Observe the table ‘Posting’ given below:
Table: Posting

P_ID Department Place
1 History Agra
2 Mathematics Raipur
3 Computer Science Delhi

(i) SELECT SUBSTR(Department, 10) FROM Posting WHERE Place LIKE “D%”;
(ii) SELECT LEN(Department) FROM Posting WHERE LEFT(Place,l) LIKE ‘R%’; [2]
OR
Based on the table given above, write the queries for the following:
(i) To display the Department names in uppercase.
(ii) To display the total number of records present in the Posting table.

Section – B [3 Marks Each]

Question 8.
Predict the output of the following queries:
(i) SELECT TRUNCATE (35.26,2);
(ii) select substr(‘Computer’,4,3);
(iii) SELECT DATE (‘2022-01-20 13:16:43’) AS “DAY”;
OR
A relation Vehicles is given below:
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 10 for Practice 1
Write SQL commands to: .
(i) Display the average price of each type of vehicle having quantity more than 20.
(ii) Count the type of vehicles manufactured by each company.
(iii) Display the total price of all the types of vehicles.

Question 9.
Ashim is working with functions of MySQL. Explain her following:
(i) What is the purpose of SYSDATE{) function?
(ii) I low many parameters does it accept?
(iii) W7hat is the syntax?

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

Question 10.
Considering the same string “Computer” Write SQL commands to display
(i) The position of the substring ‘put’ in the string “Computer”
(ii) The first 4 letters of the string.
(iii) Capitalized the string.

Section – C [4 Marks Each]

Question 11.
Write the SQL queries (i) to (iV) based on the relation Teacher given below
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 10 for Practice 2
(i) To display the department wise total number of teachers. .
(ii) To display the maximum and minimum date.
(iii) To display average Salary of all female teachers.
(iv) To display department wise total Salary. [4]

Question 12.
Consider a table SALESMAN with the following data:
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 10 for Practice 3
Write SQL queries using SQL functions to perform the following operations:
(i) Display salesman name and bonus after rounding off to zero decimal places.
(ii) Display the position of occurrence of the string “ta” in salesman names.
(iii) Display the four characters from salesman name starting from second character.
(iv) Display the month name for the date of join of salesman. [4]
OR
Based on the above given table named ‘SALESMAN’ solve the following queries:
(i) SELECT(date(DATE OF JOIN))FROM SALESMAN WHERE SNO=’A01′;
(ii) SELECT trim(” Panorama “);
Predict the output of the above given queries.
Also give proper justifications of the output generated through each query. [4]

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

Question 13.
MyPace University is setting up its academic blocks at Naya Raipur and is planning to set up a network. The University has 3 academic blocks and one Human Resource Center as shown in the diagram below:
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 10 for Practice 4
Center to Center distances between various blocks/center is as follows:

Law block to Technology Block 30 m
Law Block to HR center 105m
Business Block to technology Block 30 m
Business Block to HR Center 35 m
Technology block to HR center 15m

Number of computers in each of the blocks/Center is as follows:

Law Block 15
Technology Block 40
HR center 115
Business Block 25

(i) Suggest the most suitable place {i.e., Block-Center) to install the server of this University with a suitable reason
(ii) Suggest an ideal layout for connecting these blocks/centers for wired connectivity.
(iii) Which device will you suggest to be placed/installed in each of these blocks/centers to efficiently connect all the computers within these blocks/centers.