CBSE Class 12 Informatics Practices 2024 — Set 90/1/1

Which of the following is NOT true with respect to CSV files ? (A) Values are separated by commas. (B) tocsv() can be used to save a dataframe to a CSV file. (C) CSV file is created using a word processor. (D) 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 ? (A) UPDATE (B) INSERT INTO (C) ALTER TABLE (D) ORDER BY

What will be the output of the following query ? SELECT SUBSTR(“G20 2023 INDIA”,5,4); (A) G20 2 (B) 2023 (C) INDI (D) 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) (A) One 1 Two 2 Three 3 Seven 7 dtype: int64 (B) One 1 Two 2 Three 3 Four 4 Seven 7 dtype: int64 (C) Four 4 One 1 Two 2 Three 3 Seven 7 dtype: int64 (D) One 1 Two 2 Three 3 Seven 7 Four 4 dtype: int64

Which of the following clause cannot work with SELECT statement in MYSQL ? (A) FROM (B) INSERT INTO (C) WHERE (D) GROUP BY

Which of the following command will not show first five rows from the Pandas series named S1 ? (A) S1[0:5] (B) S1.head() (C) S1.head(5) (D) 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. (A) Carbon Footprint (B) Water Footprint (C) Online print (D) Digital Footprint

Which MySQL string function is used to extract a substring from a given string based on a specified starting position and length ? (A) SUBSTRINGINDEX() (B) LENGTH() (C) MID() (D) TRIM()

The software that is free for anyone, and its source code is available for access, modification, correction, and improvement is called ___. (A) Proprietary software (B) Commercial software (C) Free and Open source software (D) Copyrighted software

___ help in data protection through copyrights, patents and trademarks. (A) Data Privacy Right (B) Right to Innovation (C) Intellectual Property Rights (IPR) (D) 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. (A) Both (A) and (R) are true and (R) is the correct explanation for (A). (B) Both (A) and (R) are true and (R) is not the correct explanation for (A). (C) (A) is true and (R) is false. (D) (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. (A) Both (A) and (R) are true and (R) is the correct explanation for (A). (B) Both (A) and (R) are true and (R) is not the correct explanation for (A). (C) (A) is true and (R) is false. (D) (A) is false but (R) is true.

(a) Expand URL. Identify the protocol and domain in the following URL : https://epathshala.nic.in/topics.php?len=en OR (b) Write any one advantage and 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 queries : (i) SELECT RIGHT(“CHANDRAYAN3”,4); (ii) 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 : Name Subject Marks 10 Rubina IP 56 16 Jaya HSc 67 18 Vaibhav IP 86

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

(a) Consider the given table and write the following queries in MySQL : Table : Sports | Sid | SName | Fees | DateofPlay | CoachId | | --- | --- | --- | --- | --- | | 1 | Karate | 1200 | 2024-08-24 | S1 | | 2 | Football | 1800 | 2024-09-13 | S2 | | 3 | Cricket | 1500 | 2024-06-14 | S3 | | 4 | Lawn Tennis | 2500 | 2024-09-25 | S4 | | 5 | Badminton | 1800 | 2024-10-20 | S5 | (i) To display Sid and name of those sports which are to be played in the month of September. (ii) To display all Sports names in lower case. (iii) To display last two characters of all sports names whose fees is less than 1500. OR (b) Predict the output of the following queries based on the table Sports given above : (i) SELECT UCASE(TRIM(SName)) FROM Sports WHERE Sid=5; (ii) SELECT LEFT (SName,3) FROM Sports WHERE DateofPlay>“2024-09-13”; (iii) SELECT SUBSTR (CoachId,1) FROM Sports WHERE SName=“Cricket” or Fees>=2000;

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 : VoterName VoterAge Ar1001 Arjun 35 Ba3002 Bala 23 Go4002 Govind 25 Dh4007 Dhruv 19 Na6005 Navya 18 Help Kabir in writing a Python program to complete the task.

Answer the following questions based on the table Salesman given below : Table : Salesman | salesmanᵢd | name | city | commission | | --- | --- | --- | --- | | 5001 | Neil Bhatt | Delhi | 0.15 | | 5002 | Rohan Malik | Mumbai | 0.13 | | 5005 | Ravi Mohan | Delhi | 0.11 | | 5006 | Mehak Rai | Delhi | 0.14 | | 5007 | Paul Lal | Bangalore | 0.13 | | 5003 | Raman Sen | Kolkata | 0.12 | (i) How many tuples does the given table have ? (ii) Suggest the primary key for the given table. (iii) Write the MySQL query to display all the records in descending order of commission.

(a) Police officials arrested four members of an interstate gang for allegedly duping many people from different states on the pretext of providing them with holiday packages after creating fake websites of Tours and Travels. The cyber criminals sent fraudulent emails containing links to fraudulent websites created by them. The victim in his complaint told police that he was offered a holiday package to Dubai for a total of 10 times in the next 10 years and was charged ₹ 1.45 lakh through his credit card. Answer the following questions pertaining to the given news byte : (i) Identify the type of cybercrime mentioned in above case. (ii) Which Act deals with such crimes in India ? (iii) Suggest any one precaution that can be taken to avoid falling prey to such criminals. OR (b) 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 : (i) Considering the environmental concerns associated with e-waste, outline any one negative impact of the electronic products on the environment. (ii) Gopal is a college student who recently bought his new 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. (iii) 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' : CodeName Category Frequency 0 aaaaaa alpha 6.91 1 dragon animal 18.52 2 baseball sport 1.29 3 football sport 11.11 4 monkey animal 3.72 5 qwerty alpha 1.85 6 abcde alpha 3.19 Write suitable Python statements for the following : (i) To add a new row with following values : CodeName – 'abc123' Category – alphanumeric Frequency – 12.8 (ii) To delete the row with the row label 2. (iii) 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 | WinnerId | YEAR | SUBJECT | WINNER | COUNTRY | CATEGORY | | --- | --- | --- | --- | --- | --- | | 1001 | 1970 | Physics | Hannes Alfven | Sweden | Scientist | | 1002 | 1970 | Physiology | Bernard Katz | NULL | Scientist | | 1003 | 1970 | Literature | Aleksandr Solzhenitsyn | Russia | Linguist | | 1004 | 1971 | Chemistry | Gerhard Herzberg | Germany | Scientist | | 1005 | 1978 | Peace | Menachem Begin | Israel | Prime Minister | | 1006 | 1987 | Economics | Robert Solow | USA | Economist | | 1007 | 1994 | Literature | Kenzaburo Oe | Japan | Linguist | (i) Display the names of Nobel Prize winner in 'Literature' for the year 1970. (ii) Display the subject and category of winners whose country is not known. (iii) Display the details of all Nobel Prize winners who were Scientists. (iv) 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 : Name Score Attempts Qualify a Atulya 12.5 1 yes b Disha 9.0 3 no c Kavita 16.5 2 yes d John 15.0 1 no Answer the following questions : (i) Predict the output of the following Python statement : print(result.loc [:,'Attempts'] > 1) (ii) Write the Python statement to display the last three records. (iii) Write Python statement to display records of 'a' and 'd' row labels. OR (Option for Part (iii) only) (iii) 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 | Employeeᵢd | Firstₙame | Lastₙame | Salary | Joiningdate | Department | | --- | --- | --- | --- | --- | --- | | E101 | Monika | Das | 100000 | 2019-01-20 | Finance | | E102 | Mehek | Verma | 600000 | 2019-01-15 | IT | | E103 | Manan | Pant | 890000 | 2019-02-05 | Banking | | E104 | Shivam | Agarwal | 200000 | 2019-02-25 | Insurance | | E105 | Alisha | Singh | 220000 | 2019-02-28 | Finance | | E106 | Poonam | Sharma | 400000 | 2019-05-10 | IT | | E107 | Anshuman | Mishra | 123000 | 2019-06-20 | Banking | Table : Reward | Employeeᵢd | Datereward | Amount | | --- | --- | --- | | E101 | 2019-05-11 | 1000 | | E102 | 2019-02-15 | 5000 | | E103 | 2019-04-22 | 2000 | | E106 | 2019-06-20 | 8000 | Write suitable SQL queries to perform the following task : (i) Change the Department of Shivam to IT in the table Employee. (ii) Remove the record of Alisha from the table Employee. (iii) Add a new column Experience of integer type in the table Employee. (iv) Display the first name, last name and amount of reward for all employees from the tables Employee and Reward. (v) Display first name and salary of all the employees whose amount is less than 2000 from the tables Employee and Reward. OR Write suitable SQL queries for the following task : (i) Display the year of joining of all the employees from the table Employee. (ii) Display each department name and its corresponding average salary. (iii) Display the first name and date of reward of those employees who joined on Monday from the tables Employee and Reward. (iv) Display sum of salary of those employees whose reward amount is greater than 3000 from the tables Employee and Reward. (v) Remove the table Reward.

FULLMAN Tech, Bengaluru is a company that deals with software development. They have different divisions HR (H1), Sales (H2), Production (H3) and Marketing (H4). The layout of the Bengaluru branch is : [Layout diagram: four blocks arranged in a 2x2 grid inside a boundary — top row: HR (H1), Sales (H2); bottom row: Production (H3), Marketing (H4).] 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 : H1 to H2 : 76 m H1 to H3 : 185 m H1 to H4 : 88 m H2 to H3 : 140 m H2 to H4 : 125 m H3 to H4 : 160 m Number of computers in each of the division : Division | Number of Computers H1 | 140 H2 | 340 H3 | 180 H4 | 260 Based on the above specifications, answer the following questions : (i) Suggest the topology and draw the most efficient cable layout for connecting all the divisions of Bengaluru branch. (ii) 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 ? (iii) Suggest the division for the placement of server in Bengaluru branch. Explain the reason for your selection. (iv) Suggest the placement of the following devices in Bengaluru branch : (a) Repeater (b) Switch/Hub (v) 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.

(a) The inventory management 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. OR (b) Write suitable Python code to draw the following line chart “CO2 Emission” having title and label for X and Y axis as shown below. [Line chart titled “Month wise CO2 emission”: X-axis “Month” with values April, May, June, July, August; Y-axis “Percentage” ranging 20 to 60. Line values approximately: April 40, May 50, June 30, July 60, August 20.] Also give suitable Python statement to save this chart with the name, emission.png.