Term 2 IP Paper Class 12 2021

Share with others

Sample Question Paper
INFORMATICS PRACTICES (Code : 065)

Maximum Marks: 35 Time: 2 hrs

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.

Q1. Ashish is preparing for his class 12^th IP Term 2 – Board Exam. He is doing revision of chapter “Computer Network”. He found two terms Web server and Web page, which is not very much clear to him. So he contacted you. Explain both the terms to Ashish.

Amulya is a business man. He wants to launch his business digitally across the world, so he decided to create a website for showcase his range of products. Now the website is ready to launch but he is confused about the term ‘hosting’. Being a technical person, help Amulya to understand clearly “What is web hosting” and also write any two web hosting service providers.

Q2. a. What do you mean by topology?

b. What is the full form of DNS?

Q3. Write the output of the following query:

Select power(3, 4);
Select mod(987, 2);

What is the difference between Single Row function and Multiple Row function in MySQL?

Q4. Identify the topology:

A topology in which each communicating device connects to a common wire called backbone.
A topology in which each communicating device is connected to a central device like hub/switch.

Q5. Write the output of the following:

Select round(34.546, 4)
Select round (34.546, 1)

Q6. Identify the errors in the following queries.

Select * from stock where price = NULL;
Select sum[price] from stock;

Q7. Mr. Das has created the following table ‘Furniture’

F_id	Type	Price	Qty	Date_of_purchase
F12	Double Bed	40000	3	2020-08-19
F22	Sofa	35000	4	2021-11-23
F41	Dining Table	20000	2	2021-12-30

Term 2 IP Paper Class 12 2021

Write the output of the following queries:

Select * from Furniture where month(Date_of_purchase) = 8;
Select F_id, Type from Furniture where year(Date_of_purchase) = 2021;

Write the queries of the following:

Display the details of furniture which are purchased in month of December.
Display the average price of furniture.

SECTION – B

Each question carries 3 marks

Q8. Write the output of the following:

Select substr(“BoardExam@2021”, 4, 7);
Select length(“BoardExam@2021”);
Select left(upper(“BoardExam@2021”),5);

Consider the table ‘School’ whose fields are shown below.

Admno, Class, Mobile, Fees, Name

Write the queries to perform the following task.

Display all names in uppercase.
Display the last two characters from column Name.
Display the lowest fees.

Q9. Identify the following functions:

I am a mathematical function and return the remainder.
I am a string function and help to convert lower case string to upper case.
I am a date and time function, returns the month name from the specified date.

Q10. Explain the following function with examples.

dayname( )
instr( )
now( )

SECTION – C

Each question carries 4 marks

Q11. Answer the following:

Explain the difference between group by and order by clause with example.
When we use having clause? Explain with example.

Q12. Write the queries for the following task.

Add a new column “Name” of data type Varchar(30) in table “Hotel”.
Delete a record from table “emp” whose empid is 101.
Delete all the records of table “stock” along with structure.
Display the total of column “Salary” from table “emp”.

Based on the table: “Emp” given below:

Empid	Salary
1	45000
2	50000
3	55000
4	40000
5	NULL

Term 2 IP Paper Class 12 2021

Write the output of the following:

Select mod(Salary, 100) from emp;
Select average(Salary) from emp;
Select sum(Salary) from emp where empid > 3;
Select max(Salary) from emp;

Q13. Admin, Account, Research, and Care-unit are four buildings of an IT company. Ms. Shalini want to connect all the four buildings.

The distance between various buildings are as follows:

Admin to Account – 200m

Admin to Research – 150m

Admin to Care-unit – 50m

Account to Research – 250m

Account to Care-unit – 350m

Research to Care-unit – 350m

Number of computers in each building are

Admin – 120

Account – 100

Research – 50

Care-unit – 50

Based on the above specifications, answer the following questions:

1. Suggest the cable layout of connections between the buildings.

2. Suggest the most suitable building to house the server, with suitable reason.

3. Suggest the placement of the following device with justification

i. Repeater

ii. Hub/Switch

4. Suggest any one application for VoIP.

Click to Go Back

Term 2 IP Paper Class 12 2021

Disclaimer : I tried to give you the correct format of ” Term 2 IP Paper Class 12 2021 ” , but if you feel that there is/are mistakes in the Questions of “ Term 2 IP Paper Class 12 2021 “ given above, you can directly contact me at csiplearninghub@gmail.com. NCERT book and CBSE study material is used to create “ Term 2 IP Paper Class 12 2021 “ questions.