SAMPLE QUESTION PAPER (2021-22)
INFORMATICS PRACTICES (065)
TERM II
CLASS 12
Time: 2 Hrs Max. Marks: 35
GENERAL INSTRUCTIONS
• The question paper is divided into 3 sections – A, B and C
• Section A has 7 Questions (1-7). Each question carries 2 marks.
• Section B has 3 Questions (8-10). Each question carries 3 marks.
• Section C has 3 case-based Questions (11-13). Each question carries 4 marks.
• Internal choices have been given for question numbers 1, 3, 8 and 12.
SECTION A
Q.1 Ms. Rani Sen, General Manager of Global Nations corporate recently discovered that the communication between her company’s accounts office and HR office is extremely slow and signal drop quite frequently. These offices are 125 m away from each other and connected by Ethernet cable.
(i) Suggest her 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?
OR
Shrijay, a beginner in IT field has just started learning web technologies. Help her in understanding the difference between web hosting and web server with the help of a suitable example of each.
Q.2. (i) I can connect multiple computers and devices.
I can filter and forward data packets only to the intended computers.
I am also called an intelligent hub.
Who am I?
(ii) Preetpal has to work on his science project which deals with magnetism. A lot of research work is required by him for the same. He uses Google Chrome to search for the relevant matter.
a) As Preetpal works on his project, he collects and curate’s information. Whenever he clicks on the link the same piece of information is shown and the content is not clickable. Preetpal is accessing a/an _______ website.
b) A web _________ is a small piece of data that is sent from a website and stored in user’s web browser while a user is browsing a website
Q.3. Predict the output of the following queries:
i. Select Length (“Data Science”);
ii. Select Month (‘2020-03-12’);
OR
Briefly explain the purpose of the following SQL functions:
i. Length ()
ii. Month ()
Q.4. Rinki has just created a website for her company and now need to host it. Briefly discuss the role of a web server in hosting a website.
Q.5. Consider the decimal number x with value 3875.4897. Write commands in SQL to:
a) Round it off 3 places after the decimal
b) Round it to 3 places before the decimal.
Q.6. Sivaraaj is working in MySQL. Differentiate him between DDL and DML command?
Q.7. Ms. Neha, a HR Manager in a multinational company “World Power LTD” has created the following table to store the records of workers.
Table: WORKER
Based on the table given above, help her writing queries for the following task:
a. To display the details of all worker in descending order of DOB
b. To display name and desig of those worker whose plevel is either p001 or p002
OR
Based on the table given above, she has written following queries
(i) Write query with function to calculate square root of number 28.
(ii) Write query to truncate value 15.79 to 1 decimal place.
SECTION B
Q.8. Predict the output of the following queries:
a. SELECT instr(‘kendriya vidyalaya sangathan’,’ ‘);
b. SELECT substr(‘kendriya vidyalaya sangathan’,5,6);
c. SELECT left (‘kendriya vidyalaya sangathan’,6);
OR
A relation Toys is given below:
Write SQL commands to:
(i) Display the average price of each type of company having quantity more than 15.
(ii) Count the type of toys manufactured by each company.
(iii) Display the total price of all toys
Q.9 Rinku is working with functions of MySQL. Explain her following:
i. What is the purpose of curdate () function?
ii. How many parameters does it accept?
iii. What is the general format of its return type?
Q.10. Write the SQL functions which will perform the following operations:
a. To display the name of the day of the current date.
b. To remove spaces from the beginning of a string, “Python”.
c. To display the name of the month eg, January or February from your date of birth.
SECTION C
Q. 11. Consider the LOANS table given below and give the SQL commands to perform the following:
Table: LOANS
(a) Display the sum of all Loan Amount whose interest rate is greater than 10
(b) Display the Maximum Interest from LOANS table
(c) Display the count of all Loan Account Holders whose name ends with ‘Sharma’.
(d) Display interest-wise details of Loan Account Holders with at least 10 instalments remaining.
Q.12. Write SQL commands for (i) to (v) and write the output for (vi) on the basis of table Furniture
(a) To show all information about the baby cots from the Furniture table.
(b) To list the itemname which are priced at more than 15000 from the Furniture table.
(c) To list itemname and type of those items, in which date of stock is before 22/01/02 from the Furniture table in the descending order of itemname.
(d) To display itemname and dataofstock of those items, whose type is “Sofa” from Furniture table.
OR
Give the output of the following SQL statement based on table Furniture.
i. SELECT LEFT(Itemname,3) FROM Furniture WHERE Type=”Double Bed”;
ii. SELECT MONTHNAME(Dateofstock) FROM Furniture WHERE Type=”Sofa”;
iii. SELECT * FROM Furniture WHERE Itemname LIKE ‘E%’;
iv. SELECT Price*Discount FROM Furniture WHERE Dateofstock>31/12/02;
Q.13. Trine Tech Corporation (TTC) is a professional consultancy company. The company is planning to set up their new offices in India with its hub at Hyderabad. As a network adviser, you have to understand their requirement and suggest them the best available solutions. Their queries are mentioned as (i) to (iv) below.
Physical Locations of the blocked of TTC
BLOCK TO BLOCK DISTANCE IN MTRS:
• from human resource to conference = 110
• from human resource to finance = 40
• from conference to finance = 80
Expected number of computers to be installed in each block
• human resource – 25 computers
• Finance – 120 computers
• Conference – 90 computers
a. What will be the most appropriate block, where TTC should plan to install their server?
b. Draw a block to cable layout to connect all the buildings in the most appropriate manner for efficient communication.
c. What will be the best possible connectivity out of the following, you will suggest to connect the new setup of offices in Bangalore with its London based office:
• Satellite Link
• Infrared
• Ethernet Cable
d. Which of the following device will be suggested by you to connect each computer in each of the buildings:
• Switch
• Modem
• Gateway