CBSE Informatics Practices (IP) Sample Paper Class 12 Term 2 with Solutions

Informatics Practices Sample Paper Class 12 Term 2

The Central Board of Secondary Education has released the CBSE Class 12 Term 2 Informatics Practices Sample Paper 2022 on its official website. To ease of students we have covered the CBSE Class 12 Term 2 Informatics Practices Sample Paper 2022 with solutions on this page. Furthermore, the candidates must check the exam pattern of Informatics Practices given on this page to know the marking scheme. Bookmark this page to get all the latest updates from Central Board of Secondary Education Study related topics.

Class 12 Informatics Practices Term 2 Sample paper: Exam Pattern

As per the CBSE Class 12 Term 2 Informatics Practices Sample Paper 2022 released by the board, the question paper consists of 35 marks and students will get 2 hours to solve the question paper. The CBSE Class 12 Term 2 Informatics Practices question paper divided into three sections, the details of all three section is listed below:

Section A: This section consists of 7 questions. Each question carries 2 marks.
Section B: This section consists of 3 questions. Each question carries 3 marks.
Section C: This section consists of 3 questions. Each question carries 4 marks.

Class 12 Informatics Practices (IP) Term 2 Sample Paper with Solutions

Q.1 Aman, a freelance web site developer, has been assigned a task to design few web pages for a book shop. Help Aman in deciding out of static web page and dynamic web page, what kind of web pages should be designed by clearly differentiating between static and dynamic web pages on at least two points. 

OR

Priyanka, a beginner in IT field has just started learning web technologies. Help her in understanding the difference between website and web pages with the help of a suitable general example of each

Differentiation between static and dynamic web pages:

1 mark each for each correct differentiation mentioned above or any other relevant point of differentiation.
OR
The difference between a website and a web page is that a website is a collection of different web pages containing information on a particular topic. A web page is an individual page of a big website usually containing more specific information. If we compare a website with a book, then a webpage can be compared with a single page of that book.
2 marks for correct answer

Q.2(i)

• am a small text file
• created on a user’s computer
• contain small pieces of data — like a username, password and user’s browsing history as well as preferences
• may help to improve user’s web browsing experience.
  Who am I?

i) Cookies

ii) Name any two popular web browsers. 

Name of any two popular web browsers:

• Mozilla firefox
• Google Chrome
  OR

Any other correct name

3. Predict the output of the following queries:
i. Select power(5,3);
ii. Select mod(5,3);
OR
Briefly explain the purpose of the following SQL functions:
i. power()
ii. mod()

Output:
i. 125
ii. 2
1 Mark for each correct answer
OR
i. power(): It returns the value of a number raised to the power
of another number.
For example:
Select power(5,3);
Output: 125
ii. mod(): It returns the remainder of a number divided by
another number.
For example:
Select mod(5,3);
Output: 2
Q.4 Navya has just created a website for her company and now need to host it. Briefly discuss the role of a web server in hosting a website.

Role of web server in hosting a website:

A web server is the main centralized computer system that hosts and runs the websites. It has a computer program that distributes web pages as they are requisitioned. The basic role of the web server is to store, process and deliver the web pages to the users as and when required.

Q.5 Help Reshma in predicting the output of the following queries:
i) select round(8.72,3);
ii) select round(9.8);

Output:
i) 8.720
ii) 10

Q.6 Aryan, a database administrator, has grouped records of a table with the help of group by clause. He needs to further filter groups of records generated through group by clause. Suggest suitable clause for it and properly explain its usage with the help of an example.

Having clause is used to further filter those groups of records which will be generated through group by clause.
For example:
Select max(marks) from student group by classes having classes in (10,12); Above given query will arrange records in groups according to the classes. Further filtering on these groups will happen through having clause, which will finally display the highest marks from classes 10 and 12.

Q.7 Mr. Som, a HR Manager in a multinational company “Star-X world” has created the following table to store the records of employees:
Table: Emp

He has written following queries:
i) select max(year(DOB)) from emp;
ii) select ENAME from emp where month(DOJ)=11;
Predict the output.

OR

Based on the table given above, help Mr. Som writing queries for the following task:
i) To display the name of eldest employee and his/her date of birth.
ii) To display the name of those employees whose joining month is May.

Mr. Som, a HR Manager in a multinational company “Star-X world” has created the following table to store the records of employees:
Table: Emp

Output:
i) 2001
ii) Melinda
1 Mark for each correct answer
OR
Queries:

i) select ENAME,min(year(DOB)) from emp;
ii) select ENAME from emp where month(DOJ)=5;

Q.8 Predict the output of the following queries:
i. select instr(‘exams@cbse.nic.in’,’.’);
ii. select substr(‘exams@cbse.nic.in’,7,4);
iii. select left(‘exams@cbse.nic.in’,5);
OR
Ms.Saumya is working on a MySQL table named ‘Hotel’ having following structure:

She need to perform following task on the table:
i. To fetch last 2 characters from the user_id column.
ii. To display the values of name column in lower case.
iii. To display 3 characters from 3rd place from the column city.
Suggest suitable SQL function for the same. Also write the query to achieve the desired task.

Output:
i. 11
ii. cbse
iii. exams
1 Mark for each correct answer
OR
i. right()
select right(user_id,2) from hotel;
ii. lower()
select lower(name) from hotel;
iii. mid()/substr()/substring()
Select mid(city,3,3) from hotel;

Q.9 Reena is working with functions of MySQL. Explain her following:
i. What is the purpose of now () function?
ii. How many parameters does it accept?
iii. What is the general format of its return type?

i. It returns the current date and time.
ii. None
iii. The return type for NOW() function is either in ‘YYYYMM-DD HH:MM:SS’ format or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.

Q.10 While dealing with string data type in MySQL, its observed that sometimes unnecessary space character comes in between which hampers the successful execution of a string manipulation module. Name the suitable MySQL function (s) to remove leading, trailing and both type of space characters from a string. Also give MySQL queries to depict the same.

i. To remove leading space characters: ltrim()
ii. To remove trailing space characters: rtrim()
iii. To remove both type of space characters: trim()
MySQL Queries:
Select ltrim(‘ Hello ’);
Select rtrim(‘ Hello ’);
Select trim(‘ Hello ’);

Output:

Hello

Q.11 Carefully observe the following table named ‘stock’:
Table: stock

Write SQL queries for the following:
(a) To display the records in decreasing order of price.
(b) To display category and category wise total quantities of products.
(c) To display the category and its average price.
(d) To display category and category wise highest price of the products.

(a) select * from stock order by price desc;
(b) select category, sum(qty) from stock group by category;
(c) select category,avg(price) from stock group by category;
(d) select category, max(price) from stock group by category;

Q.12 Satyam, a database analyst has created the following table:
Table: Student

He has written following queries:
( a) select sum(MARKS) from student where OPTIONAL= ‘IP’ and STREAM= ‘Commerce’;
(b) select max(MARKS)+min(MARKS) from student where OPTIONAL= ‘CS’;
(c) select avg(MARKS) from student where OPTIONAL= ‘IP’;
(d) select length(SNAME) from student where MARKS is NULL;

Help him in predicting the output of the above given queries.
OR
Based on the above given table named ‘Student’, Satyam has executed following queries:
Select count(*) from student;
Select count(MARKS) from student;
Predict the output of the above given queries.
Also give proper justifications of the output generated through each query.

Output:
(a) 193
(b) 194
(c) 93.75
(d) 6

OR

First query will produce the output 7.
Justification: count (*) will count and display total number of rows (irrespective of any null value present in any of the column).
Second query will produce the output 6.
Justification: count (col_name) will count and display total number of not null values in the specified column.

Q.13 “Anutulya Creations”-A start-up fashion house has set up its main centre at Kanpur, Uttar Pradesh for its dress designing, production and dress supplying activities. It has 4 blocks of buildings.
Distance between the various blocks is as follows:
A to D       50 m
A to P        60 m
A to S       110m
D to S        60m
P to S         50m
P to D        150m
Numbers of computers in each block
Block A – 20
Block D – 80
Block P – 15
Block S – 8

(a) LAN
As computers are placed with-in the same campus within a small range.
(b) Star topology
Cable Layout:

(c) i. Repeater should be placed in between Block ‘D’ (Design) and Block ‘P’ as distance is more.
ii. Hub/Switch should be placed in each building to connect various computers
together.
(d) Video Conferencing software: Teams, Zoom, Skype etc. (Any one)
Protocol of Video Conferencing software: VOIP

Related Post:

CBSE Informatics Practices (IP) Sample Paper Class 12 Term 2 with Solutions: FAQs

Q. Where can I get CBSE Class 12th Informatics Practices Sample Paper 2022?

On this page, you will get CBSE Class 12th Informatics Practices Sample Paper 2022.

Q. What are the passing criteria of the CBSE Term 2 exam?

To pass the CBSE Term 2 Examination, students must have scored 33% of the total marks in each subject.

Q. How much time will be given to solve the Informatics Practices question paper of CBSE Term 2 Exam 2022?

The students will be given 2 hours to solve the Informatics Practices question paper of CBSE Term 2 Exam 2022.

Q. What is the subject code of CBSE Class 12 Informatics Practices?

The subject code of CBSE Class 12 Informatics Practices is 065.

Sharing is caring!