CBSE Sample Papers for Class 12 Informatics Practices Set 9 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 12 Informatics Practices with Solutions Set 9 are designed as per the revised syllabus.

CBSE Sample Papers for Class 12 Informatics Practices Set 9 with Solutions

Time : 3 Hrs.
Max. Marks : 70

General Instructions

1. Please check this question paper contains 37 questions.
2. All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions.
3. The paper is divided into 5 Sections- A, B, C, D and E.
4. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
5. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
6. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
7. Section D consists of 2 case study type questions (33 to 34). Each question carries 4 Marks.
8. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

Section A

Question 1.
State whether the following statement is True and False:
The loc function in pandas is used to access rows by their integer position.
Answer:
False

Question 2.
Which SQL command clause helps to arrange records in ascending or descending order.
(a) Having
(b) Order by
(c) Group by
(d) Arrange
Answer:
(b) Order by

Question 3.
This topology provides easier detection of errors :
(a) Star
(b) Bus
(c) Tree
(d) Mesh
Answer:
(a) Star

Question 4.
Which of the following function returns an integer that indicates the position of the first occurrence of the sub-string within the string?
(a) INSTR()
(b) RTRIM()
(c) LENGTH()
(d) TRIM()
Answer:
(a) INSTR()

Question 5.
Which of the following is/are the benefit(s) of e-Waste management?
(a) Saving the environment
(b) Creating jobs
(c) Recovery of precious metals
(d) All of these
Answer:
(d) All of these

Question 6.
While accessing the column from the dataframe, we can specify the column name. In case column does not exist, which type of error it will raise?
(a) Key error
(b) Syntax error
(c) Name error
(d) Runtime error
Answer:
(a) Key error

Question 7.
What is the purpose of the subplot() function in Matplotlib?
(a) Create multiple plots in one figure
(b) Set the subplot title
(c) Add subplots to a figure
(d) Adjust subplot spacing
Answer:
(a) Create multiple plots in one figure

Question 8.
State whether the following statement is True and False:
The SQL UPDATE statement can be used to modify existing records in a table.
Answer:
True

Question 9.
Which function will be used to read data from a CSV file onto Pandas dataframe?
(a) readcsv()
(b) to_csv()
(c) read_csv()
(d) csv_read()
Answer:
(c) read_csv()

Question 10.
The Indian IT act was framed in the year :
(a) 2001
(b) 2000
(c) 2002
(d) 1999
Answer:
(b) 2000

Question 11.
Fill in the blank:
The SQL command used to remove a table from the database is ____.
(a) DELETE
(b) REMOVE
(c) DROP
(d) TRUNCATE
Answer:
(c) DROP

Question 12.
What kind of transmission medium is most appropriate to carry data in a computer network that is exposed to electrical interferences?
(a) Unshielded twisted pair
(b) Optical fiber
(c) Coaxial cable
(d) Microwave
Answer:
(b) Optical fiber

Question 13.
Function to display the first n rows in the DataFrame is
(a) tail()
(b) head()
(c) top()
(d) first()
Answer:
(b) head()

Question 14.
What is a common health concern associated with prolonged use of digital devices such as smartphoaes and computers?
(a) Increased physical fitness
(b) Enhanced mental clarity
(c) Eye strain and vision problems
(d) Improved posture
Answer:
(c) Eye strain and vision problems

Question 15.
Which function is used to sort the series values using values?
(a) sort()
(b) values()
(c) sort_values()
(d) values_sort()
Answer:
(c) sort_values()

Question 16.
Match the following SQL functions/clauses with their descriptions:

(a) P-2, Q-4, R-3, S-1
(b) P-1, Q-2, R-4, S-3
(c) P-3, Q-4, R-2, S-1
(d) P-4, Q-l, R-3, S-2
Answer:
(a) P-2, Q-4, R-3, S-1

Question 17.
Fill in the blank:
The ___ method is used to concatenate two DataFrames along a specific axis.
(a) merge()
(b) append()
(c) concat()
(d) join()
Answer:
(c) concat()

Question 18.
When using the plt.subplots() function, which parameter allows you to specify the size of the figure in inches?
(a) figsize
(b) size
(c) dimensions
(d) width, height
Answer:
(a) figsize

Question 19.
Identify the device which connect dissimilar networks?
(a) Router
(b) Gateway
(c) Modem
(d) Both (a) and (b)
Answer:
(d) Both (a) and (b)

Directions (Q. Nos. 20 and 21) are Assertion (A) and Reason (R) Type questions. Choose the correct option as:

(a) Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation of Assertion (A)
(b) Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A)
(c) Assertion (A) is True, but Reason (R) is False
(d) Assertion (A) is False, but Reason (R) is True

Question 20.
Assertion (A) Two series can be added in pandas, if the indexes are same.
Reason (R) Indexes in pandas series can be changed by the index property.
Answer:
(a) Both A and R are true and R is a correct explanation of A.

Question 21.
Assertion (A) The ‘GRANT’ command in SQL is used to provide users with privileges to perform actions on the database.
Reason (R) The ‘GRANT’ command is a Data Manipulation Language (DML) command.
Answer:
(d) The ‘GRANT’ command is part of DCL and is used to assign privileges to users or roles for database operations. Hence, A is false but R is true.

Section B

Question 22.
(A) What is the purpose of the groupby() function in Pandas? Provide an example.
Or
(B) Explain the head() function in Pandas with an example.
Answer:
(A) The groupby() function is used to split the data into groups based on some criteria and apply a function to each group.
Example: df.groupby(‘Age’).sum()

Or

(B) The head() function is used to return the first n rows of a DataFrame. By default, it returns 5 rows.
Example: df.head(3)

Question 23.
What is phishing and how can it be avoided?
Answer:
Phishing is a fraudulent attempt to obtain sensitive information via deceptive emails or websites. It can be avoided by verifying the source and not clicking on suspicious links.

Question 24.
Consider the string: “Entity Relationship Diagram”. Write suitable SQL queries for the following:
I. To extract and display “Entity” from the string.
II. Display the position of the first occurrence of “Relationship” in the given string.
Answer:
I. SELECT SUBSTRING(‘Entity Relationship Diagram’, 1, 6) AS ExtractedString;
II. SELECT CHARINDEX(‘Relationship’, ‘Entity Relationship Diagram’) AS Position;

Question 25.
(A) Aman, a freelance website developer, has been assigned a task to design few web pages for a book shop. Help Aman in deciding out of static web page and dynamic web page, what kind of web pages should be designed by clearly differentiating between static and dynamic web pages on atleast two points?
Or
(B) Priyanka, a beginner in IT field has just started learning web technologies. Help her in understanding the difference between website and web pages.
Answer:
(A) Aman should develop dynamic web pages as they are more rich with features, interactive and are better in performance.
Differences between static and dynamic web pages are as follows

Static Web Page	Dynamic Web Page
In static web pages, will remain same until someone changes it manually.	In dynamic web pages, content of pages are different for different visitors.
In static web pages, information are change rarely.	In dynamic web page, information are changed frequently.
Static web pages are written in languages such as— HTML, JavaScript, CSS, etc.	Dynamic web pages are written in languages such as- CGI, AJAX, ASP, ASP.NET, etc.

Or

(B) Differences between website and web page are as follows

Website	Web Page
Website is a collection of web pages displayed on the web with a client-like browser.	It is part of website that includes information and content and is displayed on the browser to user or visitor.
It is a combination of web pages created using HTML and CSS.	Information is usually written in HTML language.

Question 26.
Write any two differences between Insert and Update commands of SQL.
Answer:
Two differences between Insert and Update commands of SQL are as follows

Insert	Update
Used to add records in a table.	Used to modify data of a table.
It increases the cardinality of the table	It does not bring any changes to the cardnality of the table

Question 27.
What is the importance of Net Etiquettes?
Answer:
Net etiquettes are the rules of polite and responsible behavior online. They help maintain a respectful and positive digital environment.

Question 28.
(A) Python code written below has syntactical errors. Rewrite the correct code and underline the corrections made.

Import pandas as pd ,
data = {'Name': [‘Riya’. ‘Preeti’, 'Neeta'], 'Age': [25. 30, 22]}
df = Pd.DataFrame(Data)
df.to_csv('output.csv')

Or

(B) Complete the given Python code: Given a DataFrame ‘df’, select rows where the ’^core’ column is greater than 80 and age’ column is less than 30.

import ___ as pd
df = pd.DataFrame({'name': [‘Riya’, 'Preeti', 'Neeta'], 'age': [25, 30, 22], 'score': [85, 78, 92]})
selected_rows = df[(df['score'] > ) & (df['age'] < ___)]
print(selected_rows)

Answer:
(A)

import pandas as pd
data ={'Name': ['Rlya', 'Preeti', ‘Neeta’]. 'Age': [25, 30, 22]}
df = pd.DataFrame(data)
df.to_csv('output.csv', index=False)

Or

(B)

import pandas as pd
df = pd.DataFrame({'name': ['Riya', 'Preeti', 'Neeta'], 'age': [25, 30, 22], 'score': [85, 78, 92]}) selected_rows = df[(df['score'] > 80) & (df['age'] < 30)]
print(selected_rows)

Section C

Question 29.
Saharsh is a student of Class IXth and he is a very frequent user of Internet applications. One day he got an unpleasant message on his instant messenger.
(i) What do you think he should do?
(ii) Exhibiting proper manners and etiquettes while being online is called as?
(iii) Name the law to handle such issues?
Answer:
(i) Go to his parents, teacher or other trusted adult and let them know that he feels uncomfortable or he can go to Cyber cell and complaint.
(ii) Netiquettes
(iii) Cyber law

Question 30.
(A) Ritika is a new learner for the Python Pandas and she is aware of some concepts of Python but is unable to create the DataFrame. Help hep by writing proper statements which will create the DataFrame for the following data.
Name: [‘Manpreet’/Kavil’/Manu’/Ria’]
Phy:[70,60,76,89]
Chem: [30,70,50,65]

Or

(B) Write a Python program to create a Pandas Series as shown below using a dictionary. Note that the left column indicates the indices and the right column displays the data.

Answer:
(A)

import pandas as pd
Name=['Manpreet', 'Kavil’, ‘Manu', ‘Ria']
Phy=[70, 60, 76, 89]
Chem=[30, 70, 50, 65]
df=pd.DataFrame({"Name":Name,“Phy":Phy, "Chem":Chem})
print(df)

Or

(B)

import pandas as pd
# Define the dictionary with indices and data data = {
'Dhola Sadiya Bridge': 'Assam',
'Dibang River Bridge': 'Arunachal Pradesh',
'Mahatma Gandhi Setu': 'Bihar',
'Munger Ganga Bridge’: 'Uttar Pradesh'
}
# Create a Pandas Series using the dictionary series = pd.Series(data)
# Print the Series
print(series)

Question 31.
I. Write an SQL statement to create a table named CUSTOMER, with the following specifications:

Answer:

CREATE TABLE CUSTOMER (
CustomerID Numeric PRIMARY KEY,
FirstName Varchar(30),
LastName Varchar(30),
Email Varchar(50)
);

II. Write an SQL Query to insert the following data into the

CUSTOMER table: 5678, John, Doe, [email protected]

Answer:

INSERT INTO CUSTOMER (CustomerID, FirstName, LastName, Email)
VALUES (5678, 'John', 'Doe' , '[email protected]');

Question 32.
(A) Consider the following tables:
Table 1: CUSTOMER, which stores CustomerlD, CustomerName, and CustomerCountry.
Table 2: ORDERS, which stores OrderlD, CustomerlD, OrderDate, and OrderAmount.

Write appropriate SQL queries for the following:
I. Display the total order amount per country.
II. List all customers who have placed orders in descending order of their total order amount.
III. Display customer names along with the order date and order amount for each order.
Answer:
I. SELECT c.CustomerCountry, SUM(o.OrderAmount) AS TotalOrderAmountFROM CUSTOMER cJOIN ORDERS o ON c.CustomerlD = o.CustomerlD GROUP BY c.CustomerCountry;
II. SELECT c.CustomerName, SUM(o.OrderAmount) AS TotalOrderAmount FROM CUSTOMER c
JOIN ORDERS o ON c.CustomerlD = o.CustomerlD
GROUP BY c.CustomerID,
c.CustomerName
ORDER BY Total OrderAmount DESC;
III. SELECT c.CustomerName, o.OrderDate, o.OrderAmountFROM CUSTOMER c JOIN ORDERS o ON c.CustomerID = o.CustomerID;
Answer:

Or

(B) Consider the following tables:
Table 1: STUDENT which stores Student ID (STUDENT_ID), Student Name (STUDENT_NAME), and Student Age (AGE).
Table 2: ENROLLMENT which stores Student ID (STUDENT_ID), Course ID (COURSE_ID), and Grade (GRADE) for various students.

Write appropriate SQL queries for the following:
I. Display the average age of students who are enrolled in course ID 101.
II. List all courses in the decreasing order of the number of students enrolled.
III. Display the names of students along with their grades in course ID 102.
Answer:
I.

SELECT AVG(s.AGE) AS Average_Age FROM STUDENT s
JOIN ENROLLMENT e ON s.STUDENTJD = e.STUDENT_ID WHERE e.COURSE_ID = 101;

II.

SELECT e.COURSE_ID, COUNT(e.STUDENT_ID) AS Number_Of_Students FROM ENROLLMENT e GROUP BY e.COURSE_IDORDER BY Number_Of_Students DESC;

III.

SELECT s.STUDENT_NAME, e.GRADE
FROM STUDENT s JOIN ENROLLMENT e ON s. STUDENT_ID = e.STUDENT_IDWHERE e. COURSE_ID = 102;

Section D

Question 33.
A Student during an exam has to fill the blanks in a Python code that generate the bar chart. This bar chart represents the pass percentage of five subjects. Consider a plot bar chart for Result Analysis as shown below:

Help the student to complete the code.

I. Write the suitable code for the import statement in the blank space in the line marked as Statement-1.
II. Refer to the graph shown above and fill in the blank in Statement-2 with suitable Python code.
III. Refer the graph shown above and fill the blank in Statement-3 with suitable Chart Title.
IV. Fill in the blank in Statement-4 with the name of the function to set the label on the y-axis.
Answer:
I. matplotlib.pyplot
II. fig
III. title
IV. ylabel

Question 34.
(A)

Consider the above table and write the SQL commands for the following:
(i) To display the details of all workers in descending order of DOB.
(ii) To display Name and Desig of those workers, whose Plevel is either P001 or P002.
(iii) To display the detail of all the workers, whose DOB is in between ’19-JAN-1984′ and ’18-JAN-1987′.
(iv) To add a new row with the following data:
19, ‘Daya kishore’, ‘Operator’, ‘P003’, ‘19-Jun-2008’, ‘11-Jul-1984’

Or

(B) Table : Furniture

Based on above table, write the SQL commands for the following:
(i) To show all information about the baby cots from the Furniture table.
(ii) To list the Itemname which are priced at more than 15000 from the Furniture table.
(iii) To list Itemname and Type of those items, in which Dateofstock is before 22/01/02 from the Furniture table in the descending order of Itemname.
(iv) To display Itemname and Dateofstock of those items, whose Type is “Sofa” from Furniture table.
Answer:
(A)(i) SELECT * FROM Worker ORDER BY DOB DESC;
(ii) SELECT Name, Desig FROM Worker WHERE Plevel IN (“P001” “P002”);
(iii) SELECT * FROM Worker WHERE DOB BETWEEN “19-JAN-1984” AND “18-JAN-1987”;
(iv) INSERT INTO Worker VALUES (19, ‘Daya kishore’, ‘Operator’, ‘P003′, ’19-Jun-2008′, ’11 -Jul-1984’);

Or

(B) (i)

SELECT * FROM Furniture WHERE Type= "Baby Cot";

(ii)

SELECT Itemname FROM Furniture WHERE, Price>15000;

(iii)

SELECT Itemname, Type FROM Furniture WHERE Dateofstock < "22/01/02" ORDER BY Itemname DESC;

(iv)

SELECT Itemname, Dateofstock FROM Furniture WHERE Type= 'Sofa';

Section E (3 × 5 = 15)

Question 35.
JNV School at Flyderabad have their offices according to the following diagram. Go through the details and answer the questions that follows.

(i) Name the most suitable wing, where the server should be installed. Justify your answer.
Answer:
SCHOOL, it contains maximum number of computers.

(ii) Draw the cable layout to efficiently connect various wings JNV, Hyderabad and also write the topology.
Answer:
Star topology

(iii) Suggest a device/software and its placement that would provide data security for the entire network of the School.
Answer:
Firewall should be installed in the SCHOOL, where the server is located.

(iv) (a) Which device will you suggest to be placed/installed in each of these wings to efficiently connect all the computers within these wings.
(b) Suggest the placement of a repeater in the network with justification.
Answer:
(a) Hub/Switch
(b) Repeater should be installed, where the distance between the wings is 70 metre or more. As per the above layout, no repeater is required.

(v) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smart phone/laptop users in the campus of JNV, Hyderabad.
Answer:
Devices Wi-Fi or WiMAX or Wi-Fi router
Protocols 802.11, WAP, 802.16

Question 36.
Consider the given DataFrame’Stock’:

(i) Add a column called Special_Price with the following data: [135, 150, 200, 440].
Answer:

df['Special_Price'] = [135, 150, 200, 440]
print(df)

(ii) Add a new book named ‘The Secret’ having price 800.
Answer:

new_row = {'Name': 'The Secret', 'Price': 800, 'Special_Price': None)
df = df.append(new_row, ignore_index=True)
print(df)

(iii) Remove the column Special_Price.
Answer:

df = df.drop(columns=['Specia 1_Price'])
print(df)

(iv) Update the price of ‘Item2’ to 190.
Answer:

df.loc[df['Name'] == 'Item2', 'Price'] = 190
print(df)

(v) Filter the DataFrame to show only items with a price greater than 200.
Answer:

filtered_df = df[df['Price'] > 200] print(filtered_df)

Question 37.
(A) Write suitable SQL query for the following:
I. To display the minimum value from the price column (attribute) in the Products table.
II. To display the first five characters of the phone_number column (attribute) in the Contacts table. (Note: The phone numbers are stored in the format +91-989-436-7090)
III. To display the data from the column (attribute) email in the Customers table, after eliminating any leading and trailing spaces.
IV. To display the average value in the age column (attribute) of the Members table.
V. To determine the count of distinct Values in the category column (attribute) of the Items table.

Or

(B) Write SQL queries:
(i) To display the name of the month for the current date.
(ii) To display the leftmost 5 characters from the string “INFORMATICS PRACTICES”.
(iii) To display the position of the first occurrence of “iya” in the string “Kendriya Vidyalaya”.
(iv) To display the column NAME in uppercase from table STUDENT.
(v) To compute the remainder of 120 and 7 using SQL function.
Answer:
(A) I.

SELECT MIN(price) FROM Products;

II.

SELECT LEFT(phone_number, 5) FROM Contacts;

III.

SELECT TRIM(email) FROM Customers;

IV.

SELECT AVG(age) FROM Members;

V.

SELECT COUNTCDISTINCT category) FROM Items;

Or

(B) (i)

SELECT T0_CHAR(CURRENT_DATE, 'Month') AS Month_Name;

(ii)

SELECT SUBSTR(' INFORMATICS PRACTICES', 1, 5) AS Leftmost_5_Chars;

(iii)

SELECT INSTR (' Kendriya Vidyalaya', 'iya') AS Position;

(iv)

SELECT UPPER(NAME) AS Uppercase_Name FROM STUDENT;

(v)

SELECT MOD(120, 7) AS Remainder;