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

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

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 7 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.
Rahul, a freelance Network engineer has been assigned a task to design a Network for an Office. Help Rahul by clearly differentiating between router and switch on at least two points. So, that he can decide which is to be implemented. [2]
OR
Priyanka, a beginner in IT field has just started learning web technologies.
Help her in understanding the difference Plug-in and Add-on. [2]

Question 2.
(i) I:
(a) I am a way to communicate over Internet.
(b) I am a method of exchanging messages between people using electronic devices.
(c) I am usually encoded in American Standard Code for Information Interchange (ASCII) text.
Who am I?
(ii) Name any two popular network devices. [2]

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

Question 4.
Explain the term VoIP. [2]

Question 5.
Help Raj in predicting the output of the following queries:
SELECT ROUND (8459,2654);
SELECT ROUND (8459.2654, -2); [2]

Question 6.
Rohit, a database administrator, he wants to define the difference between ORDER BY clause and GROUP BY clause. Help him. [2]

Question 7.
Observe the table ‘STUD’ given below:

(i) SELECT MAX(PTl) FROM STUD WHERE NAME LIKE “% Sin%”;
(ii) SELECT AVG(PT3) FROM STUD WHERE LEFT(Member_Name,l) LIKE ‘R%’;
OR
Based on the table given above, write the queries for the following:
(i) To display the Total Marks with the heading “PTl_Total” amount for all the members For PT1 exam.
(ii) To display the minimum of PT2 Marks.

Section – B [3 marks each]

Question 8.
Predict the output of the following queries:
(i) SELECT TRUNCATE (192.672,2);
(ii) SELECT SUBSTR(‘MySQL’,3,3);
(iii) SELECT DATE (‘2022-01-26 13:16:43’) AS “REPUBLIC DAY”;
OR
Ms.ROY is working on a MySQL table named ‘CAR_Shop’ having following structure:

She need to perform following task on the table:
(i) To fetch FIRST 3 characters from the MODELNO column for SLNO = 4.
(ii) To display the values of CNAME column in lower case where cname starts with the letter ‘H’.
(iii) To display average Price of all CARS which are not manufactured in the year 2021.
(iii) To display the details of all cars from which the car name consist of 6 characters.
Suggest suitable SQL function for the same. Also write the query to achieve the desired task. [3]

Question 9.
Amit is working with functions of MySQL. Explain him following:
(i) What is the purpose of MID() function?
(ii) How many parameters does it accept?
(iii) What is the syntax?

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

Section – C [4 Marks each]

Question 11.
Table EMP is shown below. Write commands in SQL

(i) To list names and respective salaries in descending order of SALARY.
(ii) To count the number of employees with names starting with ‘K’.
(iii) To display the name and city of employees whose age is greater than 25?
(iv) To display City wise average salaries. [4]

Question 12.
Consider the table FLIGHT given below. Write SQL command for (i) to (iv).

(i) Display flight codes, starting place, destination, number of flights in descending order of number of flights.
(ii) Display flight codes and starting place whose destination is Jaipur according to Start place.
(iii) Display the Starting place wise Flight details without stop.
(iv) Display the total no of flights for all the destination ends with “pur”. [4]
OR
Based on the above given table named ‘FLIGHT’ solve the following queries:
SELECT MAX(NO_FLIGHTS) FROM FLIGHT;
SELECT MIN(NO_FLIGHTS) FROM FLIGHT;
Predict the output of the above given queries.
Also give proper justifications of the output generated through each query. [4]

Question 13.
Number of computers in each wings
JNV Hyderabad wants to set up a network with the following specification.

Distance between various wings are given below:

Between Wings	Distance (meters)
MESS to SCHOOL	60
MESS to DORMITORY	110
MESS to GATE	65
MESS to ADMIN	130
SCHOOL to DORMITORY	40
SCHOOL to GATE	50
SCHOOL to ADMIN	68
DORMITORY to GATE	115
DORMITORY to ADMIN	100
GATE to ADMIN	65

(i) Name the most suitable wing where the Server should be installed. Justify your answer.
(ii) Draw the cable layout to efficiently connect various wings of JNV, HYDERABAD and also write the topology.
(iii) Suggest a device/software and its placement that would provide data security for the entire network of the School.
(iv) (a) Which device will you suggest to be placed/installed in each these wing to efficiently connect all the computers within these wings.
(b) Suggest the placement of a Repeater in the network with justification.
(v) Suggest a device and protocol that shall be needed to provide wireless Internet access to all smartphone, laptop users in the campus of JNV, Hyderabad. [4]