Informatics Practices Set 4 2024-2025 Commerce (English Medium) Class 12 Question Paper Solution

State whether the following statement is True or False:

In Python, we cannot create an empty DataFrame.

What will be the output of the following SQL command?

SELECT MONTHNAME ('2024-08-02');

08

02

February

August

Plug-ins

Add-ons

Cookies

Bookmarks

Which of the following is not an aggregate function in SQL?

COUNT(*)

MIN()

LEFT()

AVG()

Copyright

Plagiarism

Trademark

Lease

String

List

Numeric

Boolean

In Python which function of matplotlib library is used to save a plot?

save()

saveplot()

export()

savefig()

State whether the following statement is True or False:

The MOD() function in SQL returns the quotient of division operation between two numbers.

Which of the following data structure is used for storing one-dimensional labelled data in Python Pandas? 

Integer

Dictionary

Series

DataFrame

Priya received an email that appeared to be from her bank, asking her to update her account information by clicking on a link. She clicked the link to enter her details, but immediately after, some amount was debited from her account. What type of cybercrime did Priya fall victim to?

Cyber stalking

Phishing

Fishing

Cyber bullying

Which SQL function calculates a^b?

MOD()

POWER()

RAISE()

ROUND()

Which protocol is used while communicating through video calls on the Internet?

Video Over Internet Protocol

Voice Over Internet Protocol

Internet Protocol

Video Audio Over Internet Protocol

Which of the following Python statements will be used to select a specific element having index as points, from a Pandas Series named ser?

ser.element (points)

ser.select (points)

ser[points]

ser.show[points]

Excessive screen time and poor posture can lead to ______.

Faster Internet Speeds

Eye strain and other health issues

Better vision and bone density

Improved physical health

Which of the following libraries defines an ndarray in Python?

pandas

numpy

matplotlib

scipy

With respect to SQL, match the function given in column-II with categories given in column-I:

(i) - (c), (ii) - (d), (iii) - (a), (iv) - (b)

(i) - (b), (ii) - (a), (iii) - (d), (iv) - (c)

(i) - (d), (ii) - (b), (iii) - (a), (iv) - (c) 

(i) - (b), (ii) - (c), (iii) - (d), (iv) - (a)

Which of the following Python statements is used to change a column label in a DataFrame, df?

df = df.rename({old_name : new_name}, axis=‘columns’)

df = df.rename(old_name, new_name),axis=‘columns’

df = df.change_name(old_name, new_name, axis=‘bar’)

df = df.update({old_name : new_name}, axis=‘bar’)

In Python Pandas, DataFrame. ______ [] is used for label indexing with DataFrames.

label

index

labindex 

loc

Every web page on the Internet has a unique address. This address is known as ______.

Domain Name

Protocol

Uniform Resource Locater 

Network Topology

Both Assertion (A) and Reason (R) are True and Reason (R) is the correct explanation for Assertion (A).

Both Assertion (A) and Reason (R) are True and Reason (R) is not the correct explanation for Assertion (A).

Assertion (A) is True and Reason (R) is False.

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

Assertion (A): The ROUND() function in SQL can be used to round off a number to a specified number of decimal places.

Reason (R): The ROUND() function is a string function that accepts character values as input and returns numerical values as output.

Mention any two main points of difference between Series and DataFrame of Python Pandas.

Explain how we can access elements of a series using slicing. Give an example to support your answer.

A small tech startup, is considering using open source software to develop their new project management tool. They are evaluating the benefits and potential challenges of adopting open source solutions.

1. Identify one key benefit of using open source software for the development of project management tool.
2. Give any two examples of open source software.

Consider the string, “Informatics Practices”. Write a suitable SQL query for the following:

To display the total number of characters in the given string.

What is the difference between Static and dynamic web page?

Describe the role of a router in a network.

What is a Database Management System (DBMS)?

Mention any two examples of DBMS.

Give any two impacts on environment that are caused when e-waste is carelessly thrown or dumped in landfills or dumping grounds.

Complete the given Python code to generate the following output:

import ______ as pd
data=[{‘COLOUR’ : ‘Red’, ‘NAME’ : ‘Apple’, ‘QTY’ : 10},
{‘COLOUR’ : ‘Blue’, ‘NAME’ : ‘Berry’, ‘QTY’ : 15},
{______, 'NAME' : 'Guava', 'QTY' : 20}]
df=pd.DataFrame(______)
print(______)

1. What are digital footprints, and how are they created?
2. Write any two net etiquettes that Ravi should follow to ensure respectful and responsible online behavior.
3. How can Ravi protect himself from cyberbullying? Mention any one protective measure.

Write the SQL statement to create a table, Customer with the following specifications:

Given the following tables:

Table: STUDENTS

Table: GRADES

Gurkirat has to fill in the blanks in the given Python program that generates a line plot as shown below. The given line plot represents the temperature (in degree Celcius) over five days as given in the table:

import _______ as plt # Statement-1
days = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
temp = [30, 32, 31, 29, 28]
plt._____ (days, temp) # Statement-2
plt.xlabel ('_______') # Statement-3
plt.ylabel ('Temperature')
plt.title('________ ') # Statement-4
plt.show()

An educational institution is maintaining a database for storing the details of courses being offered. The database includes a table COURSE with the following attributes:

C_ID: Stores the unique ID for each course.

C_NAME: Stores the course’s name.

INSTRUCTOR: Stores the name of the course instructor.

DURATION: Stores the duration of the course in hours.

Consider the DataFrame Doctor shown below:

Write suitable Python statements for the following:

Write SQL query for the following:

To display sum total of all the values of the Score column, from STUDENTS table.

Write SQL query for the following:

To display the first five characters of the Name column from STUDENTS table.

Write SQL query for the following:

To retrieve the lowest score from the Score column of GRADES table.

Write SQL query for the following:

To increase the fee of all students by 100, in the STUDENTS table. (The name of the column is FEE)

Write a SQL query for the following:

To round the number 456.789 to the nearest integer.

Write a SQL query for the following:

To display the position of first occurrence of ‘com’ in the string ‘mycommercial.com’.

Write a SQL query for the following:

To display the current date and time.