Students can access the CBSE Sample Papers for Class 12 Informatics Practices with Solutions and marking scheme Term 2 Set 9 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 9 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.
Sudhanshu is a fresher in Vibrant Networking Company. He has been given the task of fixing Hub and Repeater in the client’s Network. Help Sudhanshu in knowing two main differences between Hub and Repeater. [2]
OR
Raman needs to connect the internal Network of his organization with the outside world. He thinks Gateway is appropriate while some friend said to get a Router. Help him to by giving two important differences between Gateway and Router. [2]
Question 2.
(i) It is required to be typed in the address bar of a browser, in the format below.
Which particular term describes it? “https://www.cbse.gov.in/cbsenew/history.html”
(ii) Write the types of software which follow HTTP [2]
Question 3.
Predict output for the following MySQL functions:
(i) SELECT POW(25,0.5);
(ii) SELECT MOD(2.25,0.5); [2]
OR
Describe role of the following: MySQL functions:
(i) POWO
(ii) MODO [2]
Question 4.
Explain the importance of cookies. [2]
Question 5.
Anubhav is trying to get of following MySQL functions, help him.
(i) SELECT POWi(3-1,2);
(ii) SELECT ROUND(0.675,0); [2]
Question 6.
Avinash has written a query for showing all records from EMP table grouped on the basis of field values of DEPT field.
He has to view only the records NAMES of all those that begins with letter A in each of the DEPT. He has written the query using GROUP BY clause.
What you suggest further to improve the query? Write the query on the table EMP to view all records grouped DEPT wise only showing NAMES beginning with letter ‘A’. [2]
Question 7.
The table CARED is created by Sankalp. He populated the table as shown below.
What is output of these queries that Sankalp has written?
(i) SELECT DAY (MIN (TRE AT_DT))+MONTH(MAX(TREAT_DT)) FROM CARED;
(ii) SELECT * FROM CARED WHERE YEAR(TREAT_DT)=2021 AND CHARGE <1750; [2]
OR
Which MySQL queries would be tried by Sankalp for following:
(i) Display the oldest record in the table.
(ii) Display all the records for month of TREAT_DT is 12.
Section – B [3 Marks each]
Question 8.
Predict output for the following:
(i) SELECT INSTR(‘Happy Days’, ‘a’);
(ii) SELECT SUBSTRf MOTHEATEN COAT’,7);
(iii) SELECT UCASE(Anton’); [3]
OR
Look the structure of GUARD table given below, on basis of the structure write queries (i) to (iii)
(i) Display first 4 letters of FNAME of this table.
(ii) Display SNAME in Capital letters.
(iii) Display only the position of blank space in ADDRESS. [3]
Suggest suitable SQL function for the same. Also write the query to achieve the desired task.
Question 9.
Harsh needs help in converting the string “2022-02-26″ into MySQL Date type. Which MySQL function will do the conversion of such string value into Date type value?
He is using DAY function for finding the name of the week-day. He is not able to get desired result. Describe DAY function.
Question 10.
Rita is experiencing string handling in MySQL. She is amused with the output of the following MySQL query. Help her in predicting output and also to write more efficient function for same task. SELECT LENGTH(RTRIM(LTRIM(” Golden age “))); [3]
Section – C [4 Marks each]
Question 11.
Write SQL query based on table PRIZE
Write SQL queries for the following:
(i) Display all records in descending order of GRADE.
(ii) Display total PRIZE RS in each CATEGORY.
(iii) Display CATEGORY, average PRIZE RS, in each category for GRADE XII
(iv) Display total PRIZE_RS, GRADE for each GRADE . [4]
Question 12.
Consider the ‘Staff’ table as shown below and answer.
Predict output for the following queries:
(i) SELECT SUM(SALARY) FROM Staff WHERE DEPT=’Computer’ AND JOB LIKE ‘A%’;
(ii) SELECT MIN(SALARY)+MAX(SALARY) FROM Staff WHERE DEPT-‘Admin’
(iii) SELECT LENGTH(JOB) FROM Staff WHERE SALARY IS NULL AND NAMES LIKE ‘A%’;
(iv) SELECT AVG(SALARY) FROM Staff; [4]
OR
Predict output for the following queries, also write reasons.
(i) SELECT COUNT (SALARY) FROM Staff;
(ii) SELECT COUNTgOB) FROM Staff;
Also give proper justifications of the output generated through each query. [4]
Question 13.
Abhinav Builders have planned to set up secured network connections in their Noida office and the main office at Hyderabad. Their Noida office is scattered in three places not very far from each other. Refer to the rough layout and related information and answer the questions (i) to (iv) given below.
Distance between building at Noida
| Building A to Building E | 120 meters |
| Building A to Building D | 45 meters |
| Building E to Building D | 65 meters |
| Noida to Hyderabad | 1545 Km |
Number of Computers in the premises
| Noida Building A | 31 |
| Noida Building D | 112 |
| Noida Building E | 45 |
| Hyderabad | 11 |
(i) Which building is most suitable for placing the server of the network? Give reason.
(ii) Which device is required in the network connection between building A and building E? Give a reason.
(iii) Suggesf a device in each building of Noida.
(a) Repeater
(b) Router
(c) Switch
(iv) Suggest a high-speed link between the Hyderabad office and Noida office.
(a) Ethernet cable
(b) Co-axial cable
(c) Optical fibre [4]