Informatics Practices Sample 2022-2023 Commerce (English Medium) Class 12 Question Paper Solution

The television cable network is an example of ______

LAN

WAN

MAN

Internet

Which of the following is not a type of cybercrime?

Data theft

Installing antivirus for protection

Forgery

Cyber bullying

What is an example of e-waste?

A ripened mango

Unused old shoes

Unused old computers

Empty cola cans

Which type of values will not be considered by SQL while executing the following statement?

SELECT COUNT(column name) FROM inventory;

Numeric value

text value

Null value

Date value

If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?

SELECT SUM (DISTINCT Fees) FROM student;

20500

10000

20000

33500

'O' in FOSS stands for ______.

Original

Open

On

Operating

Which SQL statement do we use to find out the total number of records present in the table ORDERS?

SELECT * FROM ORDERS;

SELECT COUNT (*) FROM ORDERS;

SELECT FIND (*) FROM ORDERS;

SELECT SUM () FROM ORDERS;

Which one of the following is not an aggregate function?

ROUND()

SUM()

COUNT()

AVG()

Which one of the following functions are used to find the largest value from the given data in MySQL?

MAX()

MAXIMUM()

BIG()

LARGE()

To display the last five rows of a series object ‘S’, you may write ______

S.Head()

S.Tail(5)

S.Head(5)

S.tail()

Which of the following statement will import pandas library?

Import pandas as pd

import Pandas as py

import pandas as pd

import panda as pd

Which of the following can be used to specify the data while creating a DataFrame?

Series

List of Dictionaries

Structured ndarray

All of these

Which of the following is not an example of a browser?

Chrome

Firefox

Avast

Edge

In SQL, which function is used to display the current date and time?

Date ()

Time ()

Current ()

Now ()

Legal term to describe the rights of a creator of original creative or artistic work is ______.

Copyright

Copyleft

GPL

FOSS

______ is the trail of data we leave behind when we visit any website (or use any online application or portal) to fill in data or perform any transaction.

Offline phishing

Offline footprint

Digital footprint

Digital phishing

Assertion (A): Internet cookies are text files that contain small pieces of data, like a username, password, and user preferences while surfing the internet.

Reasoning (R): To make browsing the Internet faster & easier, it is required to store certain information on the server’s computer.

Both A and R are true and R is the correct explanation for A.

Both A and R are true and R is not the correct explanation for A.

A is True but R is False.

A is false but R is True.

Assertion (A): DataFrame has both a row and column index.

Reasoning (R): A DataFrame is a two-dimensional labelled data structure like a table of MySQL.

Both A and R are true and R is the correct explanation for A.

Both A and R are true and R is not the correct explanation for A.

A is True but R is False.

A is false but R is True.

Explain the term Web page.

Explain the term, Home Page.

Mention any four networking goals.

Rashmi, a database administrator needs to display house wise total number of records of the ‘Red’ and ‘Yellow’ houses. She is encountering an error while executing the following query:

SELECT HOUSE, COUNT (*) FROM STUDENT GROUP BY HOUSE WHERE HOUSE=’RED’ OR HOUSE= ‘YELLOW’;

Help her in identifying the reason for the error and write the correct query by suggesting the possible correction (s).

What is the purpose of the Order By clause in SQL? Explain with the help of a suitable example.

Write a program to create a series of objects using a dictionary that stores the number of students in each house of class 12D of your school.

Note: Assume four house names are Beas, Chenab, Ravi, and Satluj having 18, 2, 20, and 18 students respectively and pandas library has been imported as pd.

List any four benefits of e-waste management.

Mention any four net etiquettes.

What will be the output of the following code:

>>>import pandas as pd
>>>A = pd.Series(data = [35, 45, 55, 40])
>>>print(A > 45)

Carefully observe the following code:

import pandas as pd
Year1 = {'Q1':5000,'Q2':8000,'Q3':12000,'Q4': 18000} Year2 = {'A' :13000,'B':14000,'C':12000}
totSales = {1:Year1,2:Year2}
df = pd.DataFrame(totSales)
print(df)

Answer the following:

1. List the index of the DataFrame df
2. List the column names of DataFrame df.

Write outputs for SQL queries that are based on the given table PURCHASE:

1. SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
2. SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
3. SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;

Write a Python code to create a DataFrame with appropriate column headings from the list given below:

[[101,'Gurman',98], [102,'Rajveer',95], [103,'Samar' ,96], [104,'Yuvraj',88]]

Consider the given DataFrame ‘Stock’:

Write suitable Python statements for the following:

1. Add a column called Special_Price with the following data: [135,150,200,440].
2. Add a new book named ‘The Secret' with a price of 800.
3. Remove the column Special_Price.

1. What is this happening to Nadar?
2. What immediate action should she take to handle it?
3. Is there any law in India to handle such issues? Discuss briefly.

What do you understand by plagiarism?

Why is plagiarism a punishable offence?

Mention any two ways to avoid plagiarism.

Based on the table STUDENT given here, write suitable SQL queries for the following:

1. Display gender-wise highest marks.
2. Display city-wise lowest marks.
3. Display the total number of male and female students.

Discuss the significance of Group by clause in detail with the help of a suitable example.

Write suitable SQL query for the following:

Display 7 characters extracted from the 7^th left character onwards from the string ‘INDIA SHINING’.

Write suitable SQL query for the following:

Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.

Write suitable SQL query for the following:

Round off the value 23.78 to one decimal place.

Write suitable SQL query for the following:

Display the remainder of 100 divided by 9.

Write suitable SQL query for the following:

Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.

Explain the following SQL function using a suitable example.

UCASE()

Explain the following SQL function using a suitable example.

TRIM()

Explain the following SQL function using a suitable example.

MID()

Explain the following SQL function using a suitable example.

DAYNAME()

Explain the following SQL function using a suitable example.

POWER()

Prime Computer Services Ltd. is an international educational organization. It is planning to set up its India campus in Mumbai with its head office in Delhi. The Mumbai office campus has four main buildings-ADMIN, ACCOUNTS, EXAMINATION, and RESULT.

You as a network expert have to suggest the best network-related solutions for the problems given below, keeping in mind the distances between the buildings and other given parameters.

Shortest distances between various buildings:

The number of computers installed at various buildings is as follows:

1. Suggest the most appropriate location of the server inside the MUMBAI campus (out of the four buildings) to get the best connectivity for the maximum number of computers. Justify your answer.
2. Suggest and draw cable layouts to efficiently connect various buildings within the MUMBAI campus for wired connectivity.
3. Which networking device will you suggest to be procured by the company to interconnect all the computers of various buildings of the MUMBAI campus?
4. The company is planning to get its website designed which will allow students to see their results after registering themselves on its server. Out of the static or dynamic, which type of website will you suggest?
5. Which of the following will you suggest to establish online face-to-face communication between the people in the ADMIN office of the Mumbai campus and the Delhi head office?
   a) Cable TV
   b) Email
   c) Video conferencing
   d) Text chat

Write Python code to plot a bar chart for India’s medal tally as shown below:

Also, give a suitable python statement to save this chart.

Write a python program to plot a line chart based on the given data to depict the changing weekly average temperature in Delhi for four weeks.

Week=[1,2,3,4]
Avg_week_temp=[40,42,38,44]

Shreya, a database administrator has designed a database for a clothing shop. Help her by writing answers to the following questions based on the given table:

1. Write a query to display cloth names in lowercase.
2. Write a query to display the lowest price of the clothes.
3. Write a query to count the total number of clothes purchased in medium size.
   OR
   Write a query to count the year-wise total number of clothes purchased.

Mr. Som, a data analyst has designed the DataFrame df that contains data about Computer Olympiad with ‘CO1’, ‘CO2’, ‘CO3’, ‘CO4’, and ‘CO5’ as indexes shown below. Answer the following questions:

1. Predict the output of the following python statement:
   i. df.shape
   ii. df[2:4]
2. Write a Python statement to display the data of the Topper column of indexes CO2 to CO4.
   OR
   Write a Python statement to compute and display the difference of data of the Tot_students column and First_Runnerup column of the above given DataFrame.