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

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

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

Maximum Marks : 35
Time : 2 hours

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
(Each question carries 2 Marks)

Question 1.
Arun is a newly appointed network executive at IGS technologies. He is well comfortable with local area networks and network systems, but is not very comfortable with the Internet concepts . He heard that Internet is called ‘Network of Networks’ and wants to know why is this so called. Clarify his doubt.
Or
Ms. Sangita wanted to connect the computers of her office with Internet facilities. Also, her network administrator told her that two devices modem and repeater will be required. Help her to understand the roles of the two devices.
Answer:
Internet is called ‘Network of Networks’ because it is global network of computers that are linked together by cables and telephone lines making communication possible among them. It can be defined as a global network over a million of smaller heterogeneous computer networks. The network which consists of thousands of network spanning the entire globe is known as Internet. The Internet is a world wide collection of networked computers, which are able to exchange information with each other very quickly.

In Internet, most computers are not connected directly, they are connected to smaller networks, which in turn are connected through gateways to the Internet backbone. A gateway is a device that connects dissimilar networks.
A backbone is central interconnecting structure that connects one or more networks.

Or

A modem is a device that modulates and demodulates signals. A modem converts signals from analog to digital and from digital to analog.
A repeater is a device that amplifies signals so that they can travel longer distances.

Question 2.
(i) Rakesh has designed a new website for a school and now wants to make it public.
Help him to understand the concept web hosting.
Answer:
A web hosting service is a type of Internet hosting service that allows you to publish your website files onto the Internet. So, anyone who will access to the Internet will access to your website. In practice, it usually refers to the service you get from a web hosting provider like one.com.

Web hosting is a service that makes your site or web application accessible on the Internet. It’s also one of the most essential elements to consider when building a website. Web hosting is typically provided by web hosts, which are businesses that maintain, configure and ran physical servers that house websites.

(ii) Remona, an in experienced web designer, wanted to design web pages and could not fix her mind whether she should prepare static or dynamic web pages. Help her with the concepts.
Answer:
A dynamic web page changes its content and appearance every time they are requested and fetched.
A static web page has always the same content and appearance every time they are fetched.

Question 3.
Biswajit a database operator came to know that certain functions in SQL have alternatives and wanted to know the alternatives for following functions
(i) SUBSTR()
(ii) POW()
Or
Sunita is a database operator and is confused about the operations of certain functions. Suggest her with proper function names for the following cases.
(i) To get the current date and time
(ii) To round a number to certain decimal places
Answer:
(i) SUBSTR() Both the SUBSTR() and the MID() functions return a part of a string. They take the parameters as the string, start position and the number of characters to extract.
(ii) POWERO The POW() or POWER() function help to calculate power of a number raised to an exponent.
Or
(i) NOW() The NOW() function of MySQL returns the current date and time.
(ii) ROUNDO The ROUND() function rounds a number to certain decimal places as per the usual rounding rules.

Question 4.
ABC Incorporation is installing networked systems for their office. They learnt that the star configuration is the best one. Write any three advantages and disadvantages of star topology.
Answer:
There are three advantages of star topology are as follows

1. Installation of star topology is very easy as all the nodes are directly connected to the central node or server.
2. Easy to detect faults and remove it.
3. Failure of single system will not bring down the entire network.

There are three disadvantages of star topology are as follows

1. Requires more cable length than bus topology.
2. If hub or server fails, the entire network will be disabled.
3. Difficult to expand, as the new node has to connect all the way to central node.

Question 5.
Gitanjali, is a database user and wants to know the proper working of the ROUND() function. Help her to understand its working, by the following statements.
(i) SELECT R0UND(893.94,1);
Answer:

The ROUND() function rounds a number to certain decimal places as per the normal rounding rules. So, ROUND(893.94,l) rounds up to 1 decimal place as 893.9, since next digit is 4, no changes to the previous digit.

(ii) SELECT R0UND( 199.99);
Answer:

Since no decimal places are indicated, decimal place is 0, so as per normal rounding rules, 199.99 becomes 200.

Question 6.
Rishi wants to know the utility of the GROUP BY and HAVING clauses of SQL . Make his concepts clear.
Answer:
The GROUP BY clause in SQL is used to arrange identical data into groups with the help of some functions, i.e. if a particular column has the same values in different rows, then it will arrange these rows in a group.

A HAVING clause in SQL specifies that an SQL SELECT statement must only return rows, where aggregate values meet the specified conditions.

A HAVING clause is like a WHERE clause, but applies only to groups as a whole (that is, to the rows in the result set representing groups), whereas the WHERE clause applies to individual rows. A query can contain both a WHERE clause and a HAVING clause.

Question 7.
Abhijit has prepared a table Graduate storing the details of some students of graduation with the subjects and division. He wants certain outputs from the table. Help him to write the queries.

(i) List the names of those students who obtained Div 1.
(ii) Display a report, listing Name, Stipend, Subject and amount of Stipend received in a year assuming that the Stipend is paid every month.
Or
Abhijit’s system is temporary down and hence he wants to predict the output of the following queries. Help him in the same.
(i) SELECT LEFT(NAME,3) FROM Graduate WHERE SNo>7;
(ii) SELECT Name, Stipend FROM Graduate WHERE Subject=”Chemistry” OR Subject=”Physics”;
Answer:
(i) SELECT Name FROM Graduate WHERE Div = 1;
(ii) SELECT Name, Stipend, Subject, Stipend *12 FROM Graduate;
Or

Section – B
(Each question carries 3 Marks)

Question 8.
Sudhir has confusions in working of INSTR(), MOD() and POWER() functions. Help him in getting outputs of the following queries and understand the functions.
(i) SELECT INSTR( ‘ keyboardandmouse ’, ‘ ad ’);
(ii) SELECT M0D( 121.5,10);
(iii) SELECT P0WER( 144,0.5);
Or
Mr. Rahman wants to know what kind of values will the following functions return, help him.
(i) SELECT UCASE (SUBSTR(‘Sofasets’.3));
(ii) SELECT INSTR ( ‘ abcdefgh ’, ‘ ef ’);
(iii) SELECT M0D (345,14);
Answer:
(i)

Or

(i) char/varchar/string
(ii) integer
(iii) integer

Question 9.
Sikha has written the following SQL statements but is not getting expected outputs. Help her to correct the queries.
(i) SELECT MODULUS(98, 7);
To get the remainder of division of 98 by 7.
Answer:
SELECT M0D(98, 7);

(ii) SELECT SEARCH( “mobile” , “ob”);
To find the position of “ob” in “mobile”.
Answer:
SELECT INSTR(“mobi1e”,“ob”);

(iii) SELECT LEFT( “SweetsandSnacks”);
To get the 1st five characters from the string.
Answer:
SELECT LEFT(“SweetsandSnacks”,5);

Question 10.
Mr. Das wants to know what corrections are required for the following SQL statements.
(i) SELECT RIGHT(“Wool engarments”, “merits”);
To extract 4 characters from right of the string.
Answer:
SELECT RIGHT(“Woolengarments”, 4);

(ii) SELECT EXPONENT(2, 5);
To get 2⁵.
Answer:
SELECT POW(2, 5);

(iii) SELECT MIDDLE(“Umbrella”.4);
To extract characters from position 4 to the end of the string.
Answer:
SELECT MID(“Umbrella”,4);

Section-C
(Each question carries 4 Marks)

Question 11.
Chandmal Stores has the following table of products sold in their store. They want certain aggregate/summative outputs for their business reports. Help them finding the following

(i) Display each manufacture and total number of products of each.
Answer:
SELECT Manufacture, C0UNT(*) FROM Product GROUP BY Manufacture;

(ii) Display the average price manufacture wise.
Answer:
Product GROUP BY Manufacture; SELECT Manufacture, AVG(UPrice) FROM Product GROUP BY Manufacture;

(iii) Display the count of different product names.
Answer:
SELECT COUNT(DISTINCT PName) FROM Product;

(iv) Display the maximum and minimum UPrice.
Answer:
SELECT MAX(UPrice), MIN(UPrice) FROM Product;

Question 12.
MT Systems has the following details of software staff members. They want certain grouped outputs from the table. Help them writing the SQL queries for the same.

(i) To display the section wise total emoluments paid.
(ii) To display number of distinct posts.
(iii) To display total emoluments paid to Pr.MGRs.
(iv) To display the average salary paid to database developers.
Or
The company MT Systems also wants to get the outputs of the following queries that use GROUP BY and aggregate functions. Help them for the operation.
(i) SELECT Section, MAX(Emoluments) FROM Software GROUP BY Section;
(ii) SELECT Post, C0UNT( *) FROM Software GROUP BY Post;
(iii) SELECT MAX( Emol uments ) FROM Software;
(iv) SELECT SUM(Emol uments) FROM Software WHERE Post=“Developer”;
Answer:
(i) SELECT Section, SUM(Emoluments ) FROM Software GROUP BY Section;
(ii) SELECT COUNT(DISTINCT Post) FROM Software;
(iii) SELECT SUM( Emoluments) FROM Software WHERE Post=“Pr.MGR”;
(iv) SELECT AVG(Emoluments) FROM Software WHERE Section=“Database’ AND Post=“Developer”;

Or

Question 13.
Bias Methodologies is planning to expand their network in India, starting with three cities in India to build infrastructure for research and development of their chemical products.

The company has planned to set up their main office in Pondicherry at three different locations and have named their offices as Back Office, Research Lab and Development Unit. The company has one more research office namely Corporate Unit in Mumbai. A rough layout of the same is as follows

(i) Suggest the type of network required (out of LAN, MAN, WAN) for connecting each of the following office units.
(a) Research Lab and Back Office
(b) Research Lab and Development Unit
Answer:
(a) LAN
(b) MAN

(ii) Which one of the following device, will you suggest for connecting all the computers with in each of their office units?
(a) Switch/Hub
(b) Modem
(c) Telephone
Answer:
(a) Switch/Hub

(iii) Which of the following communication medium, will you suggest to be procured by the company for connecting their local office units in Pondicherry for very effective (high speed) communication?
(a) Telephone cable
(b) Optical fibre
(c) Ethernet cable
Answer:
(b) Optical fibre

(iv) Suggest a cable/wiring layout for connecting the company’s local office units located in Pondicherry. Also, suggest an effective method/technology for connecting the company’s office unit located in Mumbai.
Answer: