Students can access the CBSE Sample Papers for Class 12 Informatics Practices with Solutions and marking scheme Term 2 Set 3 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 3 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.
ABC bank has many computers connected in a building. What type of network is formed? Name two hardware resources that can be shared by the computers connected in the bank network. [2]
OR
ABC Company wants to link its computers in the Head office in New Delhi to its office in Sydney. Name the type of Network that will be formed. Which communication media should be used to form this Network?
Answer:
Type of network that is formed: LAN means Local Area Network.
The hardware resources that can be shared:
- Modem
- Printer
- Scanner
- Hard disk
OR
Type of network that will be formed: Wide Area Network (WAN)
Transmission media to be used: Satellite
Question 2.
(i) I:
(a) am a document for the world wide web.
(b) Identified by unique Uniform Resource Locator.
(c) Written in HTML
(d) and viewed in a web browser.
Who am I?
Answer:
Webpage
(ii) Name any two web pages. [2]
Answer:
(a) Static web page .
(b) Dynamic web page
Question 3.
Predict the output of the following queries:
(i) SELECT MID (‘visit India’, 6,5);
(ii) SELECT round (89.387,2); [2]
OR
Mention any 4 numeric functions in MySQL. [2]
Answer:
Output:
(i) Indi
(ii) 89.39
Commonly Made Error:
Students get confused in MID functions.
Answering Tip:
Students should learn the function with their syntax and example.
OR
ROUND()
POWER()
TRUNCATE()
MOD()
Question 4.
Ramesh want to chat with his friend Anil. Explain chat in computer terms.
Answer:
Chat is talking to other people online. Chat can be simple message or using audio and video. Internet Really Chat Protocol (IRCP) enables teleconferencing on Internet. This protocol is a text based protocol with the simplest client being any socket program capable of connecting to the server. This allows communications between two or many clients. Some of the common chatting applications are WhatsApp, Facebook Messenger, Google Talk and Skype.
Question 5.
Help Ramesh in predicting the output of the following queries:
(i) SELECT DAY OF MONTH (‘2015-01-16’);
Answer:
Output:
16
DAYOFMONTH function will return the day of the month from the given date.
(ii) SELECT DAY OF YEAR (‘2014-01-30’);
Answer:
Output
30
DAYOFYEAR function will return the total number of days from 1st January of that year.
Question 6.
Anil is using a table Employee.
It has the following columns:
(i) Code
(ii) Name
(iii) Salary
(iv) Deptcode
SELECT Deptcode, MAX(Salary) FROM Employee;
He wants to display maximum salary department wise. But he did not get the desired result the above query with necessary changes to help him get the desired result.
Answer:
Query will be:
SELECT Deptcode, MAX(Salary)
FROM Employee GROUP BY Deptcode;
Question 7.
Consider the table Hotel given below:
Table: Hotel
| EmpID | Category | Salary |
| E101 | Manager | 60000 |
| E102 | Executive | 65000 |
| E103 | Clerk | 40000 |
| E104 | Manager | 62000 |
| E105 | Executive | 50000 |
| E106 | Clerk | 35000 |
Mr. Shukla wanted to display average salary of each category. He entered the following SQL statement.
Identify errors(s) and rewrite the correct SQL statement.
SELECT Category, Salary FROM Hotel GROUP BY Category; [2]
OR
Based on the table given above, Identify errors(s) in the following SQL statement, to display total salary of each Category.
Rewrite the correct SQL statement
SELECT Category, Salary FROM Hotel GROUP BY Category;
Answer:
Correct statement:
SELECT Category, AVG(Salary) FROM Hotel GROUP BY Category;
Commonly Made Error:
Students get confused in grouping.
Answering Tip:
Always use GROUP BY clause in SQL for making a query where we want to show result in group.
OR
Correct statement:
SELECT Category, SUM(Salary) FROM Hotel
GROUP BY Category;
Section – B [3 Marks each]
Question 8.
Write the output of following MySQL queries:
(i) SELECT ROUND(6.5675,2);
(ii) SELECT DAY OF MONTH(curdate());
(iii) SELECT MID(‘PRE_BOARDCLASSS12’,4,6); [3]
OR
Consider the below mentioned table of APPLIANCE
Table: APPLIANCE
Write the commands for the following:
(i) Display the total price of each brand.
(ii) Count the total number of televisions available in the table.
(iii) Display the Brand and Name of Appliance with maximum discount.
Answer:
Outputs are:
(i) 6.57
In this example ROUND function will return a value up to 2 decimal places.
(ii) Day no of curdate(), e.g. If curdate is 05/02/2022 then output is 5.
(iii) BOARD
From 4th position it will result 6 character.
OR
Commands are: .
(i) SELECT BRAND, SUM(PRICE) FROM APPLIANCE GROUP BY BRAND;
(ii) SELECTSUM(QUANTITY)FROMAPPLIANCEWHEREAPPLIANCE_NAME=/TELEVISION’;
(iii) SELECT BRAND, APPUANCE_NAME, MAX(DISCOUNT) FROM APPLIANCE;
Question 9.
Explain text functions LTRIM(), RTRIM{) and TRIM().
Answer:
(i) LTRIMO function removes all space characters from the left-hand side of a string.
Syntax: LTRIM( string)
string: The string to trim the space characters from the left-hand side.
(ii) RTRIM () function removes all space characters from the right-hand side of a string.
Syntax: RTRIM( string)
string: The string to trim the space characters from the right-hand side.
(iii) TRIM () function removes all specified characters either from the beginning or the end of a string.
Syntax: TRIM( [[ LEADING | TRAILING | BOTH ] trim character FROM ] string)
LEADING: Optional. Removes the trim_ character from the front of the string.
TRAILING: Optional. Removes the trim_ character from the end of the string.
BOTH: Optional. Removes the trim character from the front and end of string.
trim_character: Optional. The character that will be removed from the string. If this parameter is omitted, it will remove space characters from the string, string: The string to trim.
Question 10.
Write the name of the functions to perform the following operations:
(i) To display the day like “Sunday”, “Monday”, from a given date.
Answer:
Name of functions:
DAYNAME(date)
In DAYNAME function it will return name of the weekday in word.
(ii) To display the name of the month from a given date.
Answer:
MONTHNAME(date)
In MONTHNAME function it will return the name of month in word.
(iii) To display any name in capital letters.
Answer:
UCASE(String)
Section – C [4 Marks Each]
Question 11.
Consider the below mentioned table of CLOTH [4]
Table: CLOTH
Write the commands for the following:
(i) Display first three letters of description e.g. ‘FRO’ for ‘FROCK’.
Answer:
Commands:
SELECT LEFT(DESCRIPTION,3) FROM CLOTH;
(ii) Display the description after removing leading spaces if any.
Answer:
SELECT LTRIM(DESCRIFTION) FROM CLOTH;
(iii) Display number of characters taken by each description.
Answer:
SELECT LEN(DESCRIPTION) FROM CLOTH;
(iv) Display the number of MCODE in the table.
Answer:
SELECT COUNT (DISTINCT MCODE) FROM CLOTH;
Commonly Made Error:
Students get confused in some String function.
Answering Tip:
Carefully study the function with their syntax and example. Because many functions are similar in their syntax with little bit of changes.
Question 12.
Give the output of following SQL statement based on table GRADUATE:
Table: GRADUATE
(i) SELECT MIN (AVERAGE) FROM GRADUATE WHERE SUBJECT=”PHYSICS”;
(ii) SELECT SUM (STIPEND) FROM GRADUATE WHERE DIV=TT;
(iii) SELECT AVG (STIPEND) FROM GRADUATE WHERE AVERAGE > = 65;
(iv) SELECT COUNT (DISTINCT SUBJECT) FROM GRADUATE; [4]
OR
Give the output for the following queries based on table GARMENT:
Table GARMENT:
(i) SELECT COUNT(DISTINCT SIZE) FROM GARMENT;
(ii) SELECT AVG (PRICE) FROM GARMENT;
(iii) SELECT GNAME, COLOUR FROM GARMENT WHERE SIZE = ‘M’;
(iv) SELECT GNAME, COLOUR FROM GARMENT WHERE PRICE > = 3000; [4]
Answer:
Output:
(i) MIN(AVERAGE)
63
(ii) SUM(STIPEND)
800
(iii) AVG(STIPEND)
450
(iv) COUNT (DISTINCT SUBJECT)
OR
Output:
(i) COUNT(DISTINCT SIZE)
3
(ii) AVG(PRICE)
1800
(iii)
| GNAME | COLOUR |
| Skirt | Black |
(iv)
| GNAME | COLOUR |
| Ladies Jacket | Blue |
Question 13.
A company in Mega Enterprises has 4 wings of buildings as shown in the diagram:
Center to center distances between various Buildings:
| W3 to W1 | 50 m |
| W1 to W2 | 60 m |
| W2 to W4 | 25 m |
| W4 to W3 | 170 m |
| W3 to W2 | 125 m |
| W1 to W4 | 90 m |
Number of computers in each of the wing:
| W1 | 150 |
| W2 | 15 |
| W3 | 15 |
| W4 | 25 |
Computers in each wing are networked but wings are not networked. The company has now decided to connect the wings also.
(i) Suggest a most suitable cable layout for the above connections.
Answer:
Most suitable layout according to distance is:
(ii) Suggest the most appropriate topology of the connection between the wings.
Answer:
Bus topology.
(iii) The company wants internet accessibility in all the wings. Suggest a suitable technology.
Answer:
Broadband.
(iv) Suggest the placement of the following devices with justification if the company wants minimized network traffic:
(a) Repeater
(b) Hub/Switch [4]
Answer:
(a) Repeater should be installed where the distance between the wings is 100 meter or more,
(b) Hub/Switch is required in all blocks.