We have provided Class 12 Informatics Practices Sample Paper as per the latest CBSE examination pattern for the current academic year. The following CBSE Sample Papers for Class 12 Informatics Practices has been prepared based on the guess papers issued recently. Students will be able to practice these papers and get good marks in upcoming Informatics Practices exams for Class 12.
CBSE Sample Papers for Class 12 Informatics Practices
Class 12 Informatics Practices Sample Paper Term 2 With Solutions Set A
1 Mr. Kavye Shastri, General Manager of Unit Nations corporate recently discovered that the communication between his company’s accounts office and HR office is extremely slow and signals drop quite frequently. These offices are 120 m away from each other and connected by an Ethernet cable.
(i) Suggest him a device which can be installed in between the offices for smooth communication.
(ii) What type of network is formed by having this kind of connectivity out of LAN, MAN and WAN?
Answer: (i) The device that can be installed between the offices for smooth communication is repeater.
(ii) The type of network is Local Area Network (LAN).
Kritika, a beginner in IT field has just started learning web technologies. Help her in understanding the difference between web browser and web server with the help of a suitable example of each.
Answer: Web Browser: A web browser is a software application for accessing information on the World Wide Web. When a user requests a web page from a particular website, the web browser retrieves the necessary content from a web server and then displays the page on the user’s device.
Example: Internet Explorer, Google Chrome, Netscape Navigator, Mozilla Firefox etc.
Web Server: A web server is a computer that runs websites. The basic objective of the web server is to store, process and deliver web pages to the users. This intercommunication is done using Hypertext Transfer Protocol (HTTP).
Example: Internet Information Services, Jakarta Tomcat, JBoss etc.
2. (i)I can allow you to make audio calls.
I can allow you to make video calls.
I should be connected to internet-enabled device equipped with microphone and speakers.
Who am I?
Answer: VoIP (Voice Over Internet Protocol)
(ii)Ramanpreet has to work on his science project which deals with electromagnetic waves.
A lot of research work is required by him for the same. He uses Google Chrome to search for
Answer: a. Web Browser
3 Predict the output of the following queries:
iii. Select instr(“India is my country”,‘my’);
iv. Select substr(“We are indians”,4,3);
Answer: i. 10
Briefly explain the purpose of the following SQL functions:
iii. instr ( )
iv. substr ( )
Answer: i. INSTR function searches string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence.
ii. SUBSTR function returns a portion of string, beginning at character position, substring length characters long.
4 Ramya, a web developer, he want to develop few webpages for a super market. Help him to decide which kind of web pages should designed clearing between static and dynamic web pages on at least two points.
5 Consider the decimal number x with value 9945.8853. Write commands in SQL to:
(i) Round it off up to 2 decimal places.
(ii) Round it to 2 places before the decimal.
Answer: (i) select round(9945.8853,2);
6 Sivani is working in MySQL. Differentiate her between the Where and having clause.
Answer: Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.
7 Mr. Mahesh, a HR Manager in a multinational company “World Power LTD” has created the following table to store the records of workers.
Based on the table given above, help him writing queries for the following task:
iii. To display the content of all worker table, whose dob is in between ‘19-Jan-1984’ and ‘18-Jan-1987’.
iv. To add a new column salary data type float (8,2).
Answer: i. Select * from worker where dob between ‘19-Jan-1984’ and ‘18-Jan-1987’.
ii. alter table worker add (salary float(8,2));
Based on the table given above, he has written following queries.
iii. select 9 mod 2;
iv. select round(29.21),round(32.76);
Answer: i. 1
ii. 29 33
8 Predict the output of the following queries:
iv. select instr(‘kendriya vidyalaya sangathan’,’a’);
v. select substr(‘kendriya vidyalaya sangathan’,4,8);
vi. select right(‘kendriya vidyalaya sangathan’,7);
Answer: i. 8
ii. driya vi
A relation Vehicles is given below :
Write SQL commands to:
a. Display the average price of each type of vehicle having quantity more than 20.
b. Count the type of vehicles manufactured by each company.
c. Display the total price of all the types of vehicles.
Answer: a. select Type, avg(Price) from Vehicle group by 3 Type having Qty>20;
b. select Company, count(distinct Type) from Vehicle group by Company;
c. select Type, sum(Price* Qty) from Vehicle group by Type;
9 Ranu is working with functions of MySQL. Explain her following:
i. What is the purpose of sysdate () function?
ii. How many parameters does it accept?
iii. What is the general format of its return type?
Answer: i. The SYSDATE () function returns the current date and time.
iii. The date and time is returned as “YYYY-MM-DD HH:MM:SS” (string) or as YYYYMMDDHHMMSS (numeric)
10 Write the SQL functions which will perform the following operations:
(a) To display the string (“information technology”) in Uppercase.
(b) To remove spaces from the beginning and end of a string, “ Informatics ”.
(c) To display the name of the day, e.g., Friday or Sunday from your date of birth, dob.
Answer: (a) Ucase(“information technology”);
(b) Select trim(” Informatics “);
(c) Select dayname(date(dob));
SECTION – C
11 Consider a table SALESMAN with the following data:
Write SQL queries using SQL functions to perform the following operations:
a) Display salesman name and bonus after rounding off to zero decimal places.
b) Display the position of occurrence of the string “ta” in salesman names.
c) Display the four characters from salesman name starting from second character.
d) Display the month name for the date of join of salesman
Answer: a) Select sname, round(bonus,0) from Salesman;
b) Select instr(Sname, “ta”) from Salesman;
b) Select mid(Sname,2,4) from Salesman; alternative answer
c) Select Substring(Sname,2,4) from Salesman;
d) Select monthname(DateofJoin) from Salesman;
12 Consider the following table named “SOFTDRINK” .Write commands of SQL for (i) to (iv).
i) To display names and drink codes of those drinks that have more than 120 calories.
ii) To display drink codes, name and calories of all drinks in descending order of calories.
iii) To display names and price of drinks that have price in the range 12 to 18.
iv) Increase the price of all drinks in the given table by 10%.
Answer: i)select dname, drinkcode from softdrink where calories > 120;
ii)select drinkcode,dname,calories from softdrink order by calories desc;
iii)select dname,price from softdrink where price between 12 and 18;
iv)update softdrink set price=price + 0.01 * price;
i) Write query to concat drinkcode and dname as drinkcodename having price of Rs.20 of above table.
ii) Display drink name of above table in capital letters.
iii) Write query to remove leading spaces of string ‘ kendriya’.
iv) Display the position of occurance of string ‘OL’ in string “rollnoinschool”.
Answer: i)select concat(drinkcode,dname) as “drinkcodename” from softdrink where price=20;
ii)select upper(dname) from softdrink;
iii)select rtrim(‘ kendriya’);
13 G.R.K International Inc. is planning to connect its Bengaluru Office Setup with its Head Office in Delhi. The Bengaluru Office G.R.K. international Inc. is spread across and area of approx. 1 square kilometer, consisting of 3 blocks – Human Resources, Academics and Administration.
You as a network expert have to suggest answers to the four queries (i) to (iv) raised by them.
Notes: Keep the distance between blocks and number of computers in each block in mind, while providing them the solutions
a. Suggest the most suitable block in the Bengaluru Office Setup, to host the server. Give a suitable reason with your suggestion.
b. Suggest the cable layout among the various blocks within the Bengaluru Office Setup for connecting the Blocks.
c. Suggest a suitable networking device to be installed in each of the blocks essentially required for connecting computers inside the blocks with fast and efficient connectivity.
d. Suggest the most suitable media to provide secure, fast and reliable data connectivity between Delhi Head Office and the Bengaluru Office Setup.
Answer: a. Human Resources because it has maximum number of computers.
c. Switch 1
d. Satellite link