Informatics Practices Board Sample Paper 2024-2025 Commerce (English Medium) Class 12 Question Paper Solution

Slicing can be used to extract a specific portion from a Pandas Series. 

True

False

The purpose of WHERE clause in a SQL statement is to ______.

Create a table.

Filter rows based on a specific condition.

Specify the columns to be displayed.

Sort the result based on a column. 

Identify the networking device responsible for routing data packets based on their destination addresses. 

Modem

Hub

Repeater

Router

Identify the SQL command used to delete a relation (table) from a relational database.

DROP TABLE 

REMOVE TABLE

DELETE TABLE

ERASE TABLE 

E-waste refers to ______.

Software that has become obsolete.

Data that has been deleted from a storage device.

Viruses that infect computers.

Electronic devices that are no longer in use.

Which of the following Python statements can be used to select a column column_name from a DataFrame df ?

df.getcolumn('column_name')

df['column_name']

df.select('column_name')

df(column_name) 

By default, the plot() function of Matplotlib draws a ______ plot.

Histogram

Column

Bar

Line

In SQL, the HAVING clause is used to apply filter on groups formed by the GROUP BY clause. 

True

False

Which of the following Python statements is used to import data from a CSV file into a Pandas DataFrame (Note: pd is an alias for pandas)? 

pd.open_csv('filename.csv') 

pd.read_csv('filename.csv')

pd.load_csv('filename.csv')

pd.import_csv('filename.csv') 

What is plagiarism? 

Using copyrighted material without giving proper acknowledgement to the source.

Downloading illegal software.

Spreading misinformation online.

Hacking into computer systems.

The COUNT(*) function provides the total number of ______ within a relation (table) in a relational database.

Columns

Unique values

Not-null values

Rows

In which of the network topologies do all devices connect to a central point, such as a switch or hub? 

Star

Bus

Tree

Mesh

In a Pandas DataFrame, if the tail() function is used without specifying the optional argument indicating the number of rows to display, what is the default number of rows displayed, considering the DataFrame has 10 entries? 

0

1

4

5

Identify the type of cybercrime that involves sending fraudulent emails to deceive individuals into revealing sensitive information.

Hacking

Phishing

Cyberbullying

Cyberstalking

While creating a Series using a dictionary, the keys of the dictionary become _______.

Values of the Series

Indices of the Series

Data type of the Series

Name of the Series 

Match the following SQL functions/clauses with their descriptions:

P - 2, Q - 4, R - 3, S - 1

P - 2, Q - 4, R - 1, S - 3

P - 4, Q - 3, R - 2, S - 1

P - 4, Q - 2, R - 1, S - 3

Boolean indexing in Pandas DataFrame can be used for ______.

Creating a new DataFrame.

Sorting data based on index labels.

Joining data using labels.

Filtering data based on condition.

Which Matplotlib plot is best suited to represent changes in data over time?

Bar plot

Histogram

Line plot

Histogram & Bar plot

Which type of network covers a small geographical area like a single office, building, or school campus?

PAN

MAN

LAN

WAN

Assertion (A): We can add a new column in an existing DataFrame.

Reason (R): DataFrames are size mutable.

Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation of Assertion (A). 

Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A).

Assertion (A) is True, but Reason (R) is False.

Assertion (A) is False, but Reason (R) is True.

Assertion (A): In SQL, INSERT INTO is a Data Definition Language (DDL) Command. 

Reason (R): DDL commands are used to create, modify, or remove database structures, such as tables. 

Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation of Assertion (A).

Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A).

Assertion (A) is True, but Reason (R) is False.

Assertion (A) is False, but Reason (R) is True.

What is a Series in Python Pandas? Also, give a suitable example to support your answer. 

What does the term 'library' signify in Python? 

Mention one use of the following library:

Pandas

Mention one use of the following library:

Matplotlib

What do you understand by the term Intellectual property right? Discuss briefly.

Why are intellectual property rights (IPR) important in the digital world?  

Consider the string: "Database Management System". Write suitable SQL query for the following: 

To extract and display "Manage" from the string.

Consider the string: "Database Management System". Write suitable SQL query for the following:

Display the position of the first occurrence of "base" in the given string. 

What is the Internet?

How does internet differ from World Wide Web (WWW)?

Explain the concept of browser cookies.

Mention one advantage of using browser cookies.

Define the term Primary Key in a database. 

Explain how Primary key is different from a Candidate Key. 

Mention two health concerns associated with excessive use of Digital Devices. 

Sneha is writing a Python program to create a DataFrame using a list of dictionaries. However, her code contains some mistakes. Identify the errors, rewrite the correct code, and underline the corrections made.

import Pandas as pd
D1 = {'Name': 'Rakshit', 'Age': 25}
D2 = {'Name': 'Paul', 'Age': 30}
D3 = {'Name': 'Ayesha", 'Age': 28}
data = [D1, D2, D3)
df = pd.Dataframe(data)
print(df) 

Complete the given Python code to get the required output (ignore the dtype attribute) as

Output:

Tamil Nadu     Chennai
Uttar Pradesh   Lucknow
manipur         Imphal

Code:

import _______ as pd
data = ['Chennai','_______','Imphal']
indx = ['Tamil Nadu','Uttar Pradesh','Manipur']
s = pd.Series(_______, indx)
print(_______)

Ayesha's family is replacing their old computer with a new one. They decide to throw the old computer in a nearby empty field/plot. 

1. Explain any one potential environmental hazard associated with improper e-waste disposal.
2. Suggest one responsible way to Ayesha's family for proper disposal of their old computer.
3. Describe the importance of recycling in e-waste management. 

Write a Python programme to create the following DataFrame using a list of dictionaries. 

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. 

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

II. Write SQL Query to insert the following data in the Students Table 1, Supriya, Singh, 2010-08-18, 75.5.

Consider the following tables:

Table 1:
EMPLOYEE which stores Employee ID (EMP_ID), Employee Name (EMP_NAME), Employee City (EMP_CITY).

Table 2:
PAYROLL which stores Employee ID (EMP_ID), Department (DEPARTMENT), Designation (DESIGNATION), and Salary (SALARY) for various employees. 

Note: Attribute names are written within brackets.

Table: EMPLOYEE

Table: PAYROLL

Write appropriate SQL queries for the following:

1. Display department-wise average Salary.
2. List all designations in the decreasing order of Salary.
3. Display employee name along with their corresponding departments.

Consider the following tables:

Table 1: 
ATHLETE, which stores AthleteID, Name, Country. The table displays basic information of the athletes.

Table 2: 
MEDALS, which stores AthleteID, Sport, and Medals. The table displays the number of medals won by each athlete in their respective sports.

Table: ATHLETE 

Table: MEDALS

Write appropriate SQL queries for the following:

1. Display the sports-wise total number of medals won.
2. Display the names of all the Indian athletes in uppercase.
3. Display the athlete name along with their corresponding sports.

During a practical exam, a student Ankita has to fill in the blanks in a Python program that generates a bar chart. This bar chart represents the number of books read by four students in one month. 

Help Ankita to complete the code.

import _____ as plt #Statement-1
students = ['Karan', 'Lina', 'Raj', 'Simran']
books_read = [12, 9, 5, 3]
plt.bar( students, _____, label='Books Read') #Statement-2
plt.xlabel('Student Name')
plt._____('Books Read') #Statement-3
plt.legend()
plt.title('_____') #Statement-4
plt.show()

1. Write the suitable code for the import statement in the blank space in the line marked as Statement-1.
2. Refer to the graph shown above and fill in the blank in Statement-2 with suitable Python code.
3. Fill in the blank in Statement-3 with the name of the function to set the label on the y-axis. 
4. Refer the graph shown above and fill the blank in Statement-4 with suitable Chart Title. 

Rahul, who works as a database designer, has developed a database for a bookshop. This database includes a table BOOK whose column (attribute) names are mentioned below: 

BCODE: Shows the unique code for each book.
TITLE: Indicates the book’s title.
AUTHOR: Specifies the author’s name.
PRICE: Lists the cost of the book.

Table: BOOK

1. Write SQL query to display book titles in lowercase.
2. Write SQL query to display the highest price among the books.
3. Write SQL query to display the number of characters in each book title.
4. Write SQL query to display the Book Code and Price sorted by Price in descending order. 

Dr. Kavita has created a database for a hospital's pharmacy. The database includes a table named MEDICINE whose column (attribute) names are mentioned below: 

MID: Shows the unique code for each medicine.
MED_NAME: Specifies the medicine name.
SUPP_CITY: Specifies the city where the supplier is located.
STOCK: Indicates the quantity of medicine available.
DEL_DATE: Specifies the date when the medicine was delivered.

Table: MEDICINE

Write the output of the following SQL Queries.

1. Select LENGTH(MED_NAME) from MEDICINE where STOCK > 100;
2. Select MED_NAME from MEDICINE where month(DEL_DATE) = 4;
3. Select MED_NAME from MEDICINE where STOCK between 120 and 200;
4. Select max(DEL_DATE) from MEDICINE;

ABC Pvt. Ltd., a multinational technology company, is looking to establish its Indian Head Office in Bengaluru, and a regional office branch in Lucknow. The Bengaluru head office will be organized into four departments: HR, FINANCE, TECHNICAL, AND SUPPORT. As a network engineer, you have to propose solutions for various queries listed from I to V. 

The shortest distances between the departments/offices are as follows:

The number of computers in each department/office is as follows:

1. Suggest the most suitable department in the Bengaluru Office Setup, to install the server. Also, give a reason to justify your suggested location.
2. Draw a suitable cable layout of wired network connectivity between the departments in the Bengaluru Office.
3. Which networking device would you suggest the company to purchase to interconnect all the computers within a department in Bengaluru Office?
4. The company is considering establishing a network connection between its Bengaluru Head Office and Lucknow regional office. Which type of network—LAN, MAN, or WAN—will be created? Justify your answer.
5. The company plans to develop an interactive website that will enable its employees to monitor their performance after login. Would you recommend a static or dynamic website, and why?

Consider the DataFrame df shown below.

Write Python statements for the DataFrame df to:

1. Print the first two rows of the DataFrame df.
2. Display titles of all the movies.
3. Remove the column rating.
4. Display the data of the 'Title' column from indexes 2 to 4 (both included).
5. Rename the column name 'Title' to 'Name'.

Write suitable SQL query for the following: 

To display the average score from the test_results column (attribute) in the Exams table. 

Write suitable SQL query for the following:

To display the last three characters of the registration_number column (attribute) in the Vehicles table. (Note: The registration numbers are stored in the format DL-01-AV-1234).

Write suitable SQL query for the following:

To display the data from the column (attribute) username in the Users table, after eliminating any leading and trailing spaces.

Write suitable SQL query for the following:

To display the maximum value in the salary column (attribute) of the Employees table.

Write suitable SQL query for the following:

To determine the count of rows in the Suppliers table.

Write suitable SQL query for the following:

Round the value of pi (3.14159) to two decimal places. 

Write suitable SQL query for the following:

Calculate the remainder when 125 is divided by 8.

Write suitable SQL query for the following:

Display the number of characters in the word 'NewDelhi'.

Write suitable SQL query for the following:

Display the first 5 characters from the word 'Informatics Practices'.

Write suitable SQL query for the following:

Display details from 'email' column (attribute), in the 'Students' table, after removing any leading and trailing spaces