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

In ______ topology, the devices are arranged in the form of multiple-branches in hierarchical manner. 

Star

Tree

Mesh

Bus

Ridhima purchased a license for a copy of a software and made additional copies without the permission of the copyright owner. This act of hers is known as ______. 

Tradema.rk Infringement

Identity Theft

Copyright Infringement

Patent

What can an individual do to enhance the privacy of data stored digitally? 

Share sensitive information on social media platforms.

Use your date of birth as your password.

Regularly update software installed on your device. 

Download and install software from unknown sources.

What will be the output of the following query? 

SELECT POWER (2, MOD (17, 3)):

8

1

0

4

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

AVG()

MAX()

LCASE()

MIN()

______ is the gaining of unauthorized access to data in a computer system. 

Phishing

Plagiarism

Hacking

Copyright violation

Which of the following is NOT true with respect to CSV files? 

Values are separated by commas.

to cvs() can be used to save a dataframe to a CSV file. 

CSV file is created using a word processor.

CSV file is a type of text file. 

Which MySQL command helps to add a primary key constraint to any table that has already been created? 

UPDATE

INSERT INTO

ALTER TABLE

ORDER BY

What will be the output of the following query?

SELECT SUBSTR ("G20 2023 INDIA", 5, 4);

G20 2

2023

INDI

023

What will be the output of the following Python code?

import pandas as pd 
dd = {'One':1, 'Two':2, 'Three':3, 'Seven':7} 
rr = pd. Series (dd) 
rr ['Four'] = 4 
print (rr)

One 1
Two 2
Three 3
Seven 7
dtype: int64

One 1
Two 2
Three 3
Four 4
Seven 7
dtype: i.n64

Four 4
One 1
Two 2
Three 3
Seven 7
dtype: in64

One 1
Two 2
Three 3
Seven 7
Four 4
dtype: in64

Which of the following clause cannot work with SELECT statement in MYSQL? 

FROM

INSERT INTO

WHERE

GROUP BY

Which of the following cammand will not show first five rows from the Pandas series named S1?

S1 [0 : 5]

S1.head ()

S1.head (5)

S1.head [0 : 5]

Rama was unable to understand how the recruiters were able to know about her digital activity when she has not shared anything with them.

The recruiters might have checked ______ of Rama. 

Carbon Footprint

Water Footprint

Online print

Digital Footprint

Which MySQL string function is used to extract a substring from a given string based on a specified starting position and length? 

SUBSTRING_INDEX()

LENGTH()

MID()

TRIM()

The software that is free for anyone, and its source code is available for access, modification correction, and improvement is called ______.

Proprietary software

Commercial software

Free and Open source software

Copyrighted software 

______ help in data protection through copyrights, patents and trademarks.

Data Privacy Right

Right to Innovation

Intellectual Property Rights (IPR)

Right to Data Protection

Assertion (A): Cyber Bullying can have serious, emotional and psychological effects on victims.

Reason (R): Online Bullying is not a crime while offline bullying is a crime.

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 and (R) is false.

(A) is false but (R) is true.

Assertion (A): A Series is a one dimensional array and a DataFrame is a two-dimensional array containing sequence of values of any data type. (int, float, list, string, etc.) 

Reason (R): Both Series and DataFrames have by default numeric indexes starting from zero. 

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 and (R) is false.

(A) is false but (R) is true.

Expand URL, Identify the protocol and domain in the following URL:

https://epathshala.nic.in/topics.php?len=en 

List one advantage of star topology. 

List one disadvantage of star topology.

The Python code written below has syntactical errors. Rewrite the correct code and underline the correction(s) made.

import Pandas as pd
stud=['Name':'Ramya','Class':11, 'House':'Red']
s=p.Series(s)
print(s)

What will be the output of the following SQL query:

SELECT RIGHT ("CHANDRAYAN3", 4);

What will be the output of the following SQL query:

SELECT ROUND (76345.456, 2)

Find the output of the following Python code: 

import pandas as pd 
com=pd.Series([45, 12, 15, 200], index = ['mouse', 'printer', 'webcam', 'keyboard']) 
print (com[1:3])

What is the primary function of a gateway in a computer network? Explain briefly.

Consider the following Python code:

import pandas as pd
S1=pd.Series(['Rubina', 'Jaya', 'Vaibhav'], index=[10, 16, 18])
S2=pd.Series(______, index= (10, 16 18])
S3=pd.Series([56, 67, 86], ______)
xiia={'Name': ______,'Subject': S2, 'Marks': S3}
df=pd.DataFrame (______)
print(df)

Complete the above Python code to display the following output:

Write any two differences between UPDATE and ALTER TABLE commands of MySQL. 

Consider the given table and write the following queries in MySQL:

Table : Sports

1. To display Sid and name of those sports which are to be played in the month of September.
2. To display all Sports names in lower case.
3. To display last two characters of all sports names whose fees is less than 1500.

Predict the output of the following query based on the table Sports given below:

Table: Sports 

SELECT UCASE(TRIM(SName)) FROM Sports WHERE Sid=5;

Predict the output of the following query based on the table Sports given below:

Table: Sports 

Predict the output of the following query based on the table Sports given below:

Table: Sports 

Kabir, a data analyst, has stored the voter's name and age in a dictionary. Now, Kabir wants to create a list of dictionaries to store data of multiple voters. He also wants to create a DataFrame from the same list of dictionaries having appropriate row labels as shown below: 

Help Kabir in writing a Python program to complete the task.

Answer the following questions based on the table Salesman given below: 

                             Table: Salesman

1. How many tuples does the given table have?
2. Suggest the primary key for the given table.
3. Write the MySQL query to display all the records in descending order of commission. 

Answer the following questions pertaining to the given news byte:

1. Identify the type of cybercrime mentioned in above case.
2. Which Act deals with such crimes in India?
3. Suggest any one precaution that can be taken to avoid falling prey to such criminals. 

ABC Electronics, a popular electronics retail chain, has been a prominent player in the market for years. However, recent concerns over environmental degradation and e-waste have prompted the company to rethink its strategies and practices. As the newly appointed sustainability manager, you've been asked to answer the following questions:

1. Considering the environmental concerns associated with e-waste, outline any one negative impact of the electronic products on the environment. 
2. Gopal is a college student who recently bought his smartphone from ABC electronics. He's excited about the new features and improved performance of his new device. However, he’s now left with his old smartphone, which is still functional but considered outdated. Suggest him any one action that he can take for his old smartphone.
3. Provide any one recommendation on how ABC Electronics can responsibly manage its e-waste while minimizing harm to the environment.

Consider the given DataFrame 'password':

Write suitable Python statements for the following:

1. To add a new row with following values:
   CodeName – 'abc123'
   Category – alphanumeric
   Frequency – 12.8
2. To delete the row with the row label 2.
3. To delete the column having column label as Frequency.

Rupam created a MySQL table to store the details of Nobel prize winners. Help her to write the following MySQL queries: 

                                                      TABLE: NOBEL

1. Display the names of Nobel Prize winner in 'Literature' for the year 1970.
2. Display the subject and category of winners whose country is not known.
3. Display the details of all Nobel Prize winners who were Scientists.
4. Count total number of winners whose subject is Literature.

Ms. Ritika conducted an online assessment and stored the details in a DataFrame result as given below: 

Answer the following questions:

1. Predict the output of the following Python, statement:
   print(result.loc [:, 'Attempts'] > 1)
2. Write python statement to display the last three records.
3. Write python statement to display records of 'a' and 'd row labels. 
                                       OR 
   Write suitable Python statement to retrieve the data stored in the file, 'registration.csv' into a DataFrame, 'regis'. 

Excellent Consultancy Pvt.Ltd. maintains two tables for all its employees. 

                                                  Table : Employee

Table : Reward

Write suitable SQL queries to perform the following task:

1. Change the Department of Shivam to IT in the table Employee.
2. Remove the record of Alisha from the table Employee.
3. Add a new column Experience of integer type in the table Employee.
4. Display the first name, last name and amount of reward for all employees from the tables Employee and Reward.
5. Display first name and salary of all the employees whose amount is less than 2000 from the tables Employee and Reward.

Excellent Consultancy Pvt.Ltd. maintains two tables for all its employees. 

                                               Table : Employee

FULLMAN Tech, Bengaluru is a company that deals with software development. They nave different divisions HR (H1), Sales (H2), Production (H3) and Marketing (H4). The layout of the Bengaluru branch is: 

The management wants to connect all the divisions as well as all the computers of each division (H1, H2, H3 and H4). 

Distance between the divisions are as follows:

Number of computers in each of the division:

Based on the above specifications, answer the following questions:

1. Suggest the topology and draw the most efficient cable layout for connecting all the divisions of Bengaluru branch.
2. FULLMAN Tech is expanding its reach and therefore it establishes a new office in Delhi. Out of LAN, MAN, and WAN what kind of network will be created to connect Bengaluru office with Delhi Office?
3. Suggest the division for the placement of server in Bengaluru branch. Explain the reason for your selection. 
4. Suggest the placement of the following devices in Bengaluru branch: 
   1. Repeater
   2. Switch/Hub
5. The company's manager Ms. Ritu is worried as to how she can extend and modify the functionality of the web browser. Help her by giving names of any two tools. 

The inventory mangement software of a grocery shop stores the price of all fruits as follows:

Fruits=[ 'Apple', ‘Guava’, ‘Papaya’, ‘Grapes’, 'Mango']
Price=[150, 70, 50, 30, 120]

Write suitable Python code to generate a Bar Chart on the given data. Also add the chart title and label for X and Y axis. Also add suitable statement to save this chart with the name fruits.png.

Write suitable Python code to draw the following line chart "\[\ce{CO2}\] Emission" having title and label for X and Y axis as shown below.

Also give suitable Python statement to save this chart with the name, emission.pug.