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

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solutions

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 beginner in IT field and wants to send some to his colleagues digitally. His one of friendssuggested him to use E-mail. Help him to find the advantages of E-mail. [2]
OR
Nisha has just created a website for her company and now need to host it. Briefly discuss the purpose of website. [2]
Answer:
Advantages of E-mail:

  • E-mails provides faster and easy mean of communication. One can send message to any person at any place of world by just clicking mouse.
  • Various folders and sub-folders can be created within inbox of mail, so it provide management of messages.
  • It is effective and cheap means of communication because single message can be send to multiple people at same time.
  • E-mails are very easy to filter. User according to his/her priority can prioritize e-mail by specifying subject of e-mail.

OR

  • Purpose of a website can be different for everyone. Some businesses have a website to increase their business, reach their customers and target audience, establish themselves in the online space and ultimately increase their revenues.
  • Similarly, bloggers start websites as blogs in which they share useful information with their readers.
  • Some do it because of their passion while some do it just to earn some money. If you have just started your startup then your purpose with your website will to get yourself and your startup some online visibility, get some customers and Market your product in your industry

Question 2.
(i) I: [1]
(a) am used to connect two or more hosts or network segments together.
(b) am storing and forwarding frames between the different segments.
Who am I?
Answer:
Bridge

(ii) Name any two popular network topologies. [1]
Answer:
BUS topology, Star Topology.

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution

Question 3.
Predict the output of the following queries:
(i) SELECT LEFT (“SCHOOL”,3);
(ii) SELECT MID(“SCHOOL,3,2); [2]
OR
Briefly explain the purpose of the following SQL functions:
(i) LEFT ()
(ii) MID () [2]
Answer:
(i) SCH
(ii) HO

OR

(i) The LEFTQ function extracts a number of characters from a string (starting from left).
Syntax
LEFT(string, number_of_chars)

(ii) The MID() function extracts some characters from a string.
Syntax
MID(string, start, length)

Question 4.
PQR consultancy is planning to link its branch office in Delhi to its head office in the same city. Write one way to connect. What type of network (out of LAN/WAN/MAN) will be formed? [2]
Answer:
(i) Optical Fiber cable Network for high speed connection.
(ii) MAN (area network)

Question 5.
predict the output of the following queries:
SELECT YEAR(/2022-01-29′);
SELECT Day OF MONTH(‘2022-01-29’); [2]
Answer:
(i) 2022
(ii) 29

Question 6.
Ayus , a database administrator, wants to remove the leading and trailing blank space from a word using String function.
Suggest suitable command/function/clause for it and properly explain its usage with the help of an example. [2]
Answer:
TRIM function allows you to trim leading and/or trailing characters from a string. The following shows the syntax of the TRIM function.
TR1M([LHADING | TRAILING | BOTH] trim_character FROM source_string);
Code language: SQL (Structured Query Language) (sql)

First, specify the trimcharacter, which is the character that the TRIM function will remove. If you do not specify trim_character the TRIM function will remove the blank spaces from the source string.
Second, place the source string followed the FROM clause.
Third, the LEADING, TRAILING, and BOTH specify the side of the source string that the TRIM function will remove the trim_character

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution

Question 7.
Consider the following table:
Table: STOCK
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 1
Write SQL commands for the following statements:
(i) To display details of all items in the STOCK table in descending order of Stkdate.
(ii) To display minimum unit price of items for each dealer individually as per dealer code from the table stock, [2]
OR
(i) Consider the table STOCK given above and find the output of following queries:
(ii) SELECT COUNT(DISTINCT Dcode) FROM STOCK; SELECT MAX(Stkdate) FROM STOCK; [2]
Answer:
(i) SELECT * FROM STOCK ORDER BY Stkdate DESC;
(ii) SELECT Dcode, MIN(Unitpr) FROM STOCK GROUP BY Dcode;

OR
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 2

Section – B [3 Marks Each]

Question 8.
What will be the output of
(i) SELECT MOD (124,44) + MOD (125, 3);
(ii) SELECT POWER (3,5) + ROUND (20.50,1);
(iii) SELECT POWER(3,2) + ROUND (63.5036,2); [3]
OR
What will be the output of the following queries on the basis of Employee table :

DEPTID DName Salary
A001 computer 56000
A002 electrical 65300
A003 finance 50000

(i) SELECT AVG(Salary) FROM Employee;
(ii) SELECT Sum(Salary) FROM Employee;
(iii) SELECT MAX(Salary) FROM Employee; [3]
Answer:
(i)38
(ii) 263.5
(iii) 725

OR

(i) 57100
(ii) 171300
(iii) 65300

Question 9.
What is String function? Explain any two String functions with an example. [3]
Answer:
A string function is a function that takes a string value as an input regardless of the data type of the returned value. In SQL Server there are many built-in string functions that can be used by developers. ,

The LEFTQ function extracts a number of characters from a string (starting from left).

Syntax:
LEFT(string, number_of chars)
The SUBSTRING() function extracts some characters from a string.

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution

Question 10.
Given Employee table as follows:

Emp_Id Name Commission
101 Rahul Verma NULL
102 Divya Arora 8900
103 Faizal zaildi NULL

What values will the following statements return?
(j) SELECT COUNT(*) FROM Employee;
(ii) SELECT COUNT (commission) FROM Employee; Explain. [3]
Answer:
(i) 3
(ii) 1
COUNT(): This function returns the number of items found in a set.
COUNT(*) function returns a number of rows in a specified table or view that includes the number of duplicates and NULL values.

Section – C [4 Marks Each]

Question 11.
Write tire SQL query command for (a) andoutput for (b), (c), (d) based on following tables:
Table: Book
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 3
Table: issued

Book_id Quantity_Issued
T111 4
C112 5
F100 2

(i) Display the names and price from books in ascending order of their prices.
Answer:
SELECT Book_name, Price FROM Book ORDER BY Price ASC;

(ii) SELECT COUNTS) FROM Book;
Answer:
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 4

(iii) SELECT MAX(Price) FROM Book WHERE Quantity > = 15;
Answer:
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 5

(iv) SELECT COUNT(DISTINCT Publisher) FROM Book WHERE Price > =400; [4]
Answer:
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 6

Question 12.
Consider the table FANS :
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution 7
Write MySQL queries for the following:
(i) To display the details of fans in descending order of their DOB
(ii) To display the details of FANS who does not belong to AJMER
(iii) To count the total number of fans of each fan mode
(iv) To display the dob of the youngest fan.
OR
Based on the above given table named ‘FANS’, execute following queries:
(i) SELECT MIN (FAN_DOB) FROM FANS;
(ii) SELECT COUNT (FAN ID) FROM FANS;
Predict the output of the above given queries.
Also give proper justifications of the output generated through each query. [4]
Answer:
(i) SELECT * FROM FANS ORDER BY FAN L)OB DESC;
(ii) SELECT * FROM FANS WHERE FAN_CITY< >‘AJMER’;
(iii) SELECT FAN MODE, COIJNT() FROM FANS GROUP BY FAN_MODE;
(iv) SELECT MAX(FAN_DOB) FROM FANS;

OR

(i) 1997-12-12
(ii) 5

The COUNT() function returns the number of records returned by a select query.
Note: NUU. values are not counted.
Syntax
COUNT(expression)

The MINO function returns the minimum value in a set of values.
Note: See also the MAXO function.
Syntax
MIN(expression)

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 5 with Solution

Question 13.
Software Development Company has set up its new center at Raipur for its office and web based activities. It has 4 blocks of buildings named Block A, Block B, Block C, Block D.
Number of Computers

Block A 25
Block B 50
Block C 125
Block D 10

Shortest distances between various Blocks in meters

Block A to Block B 60 m
Block B to Block C 40 m
Block C to Block A 30 m
Block D to Block C 50 m

(i) Suggest the most suitable place (i.e. block) to house the server of this company with a suitable reason.
Answer:
Block C„ It has maximum number of computer.

(ii) Suggest the type of network to connect all the blocks with suitable reason.
Answer:
Local Area Network because all blocks have distance among them below 100 mt.

(iii) The company is planning to link all the blocks through a secure and high speed wired medium. Suggest the name of topology to connect all the blocks.
Answer:
Star topology
OR
Diagram

(iv) Suggest the most suitable wired medium for efficiently connecting each computer installed in every block out of the following network cables:
(a) Coaxial Cable
(b) Ethernet Cable
(c) Single Pair Telephone Cable. [4]
Answer:
(b) Ethernet Cable