Question 1

Question 9Predict the output of the following query :SELECT LCASE(MONTHNAME('2023-03-05'));MayMarchmaymarch

Accepted Answer

marchReason — The MONTHNAME() function in MySQL returns the name of the month for a given date. In this case, the date '2023-03-05' corresponds to March, so MONTHNAME('2023-03-05') will return "March". Then LCASE() function is used to convert the result to lowercase, resulting in "march" as the output.

Question 2

Question 10Which of the following command will show the last 3 rows from a Pandas Series named NP ?NP.Tail()NP.tail(3)NP.TAIL(3)All of the above

Accepted Answer

NP.tail(3)Reason — The syntax to display the last n rows of a Series object is <Series Object>.tail([n]). Therefore, according to this syntax, NP.tail(3) will display last three rows of a Series object NP.

Question 3

Question 11Which clause is used in the query to place the condition on group in MySQL?WHEREHAVINGGROUP BYBoth (i) and (ii)

Accepted Answer

HAVINGReason — The HAVING clause is used in SQL queries to place conditions on groups when using the GROUP BY clause.

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Clause, Query, Place, Condition, Group. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(a) Consider the following table named "GARMENT". GCODE GNAME SIZE COLOUR PRICE 111...
Q10: Question 10 Which of the following command will show the last 3 rows from a Pandas Series named NP...
Q12: Question 12 Which of the following codes will display the total number of rows in the DataFrame...
Q13: Question 13 By restricting the server and encrypting the data, a software company&#x27;s server is...
Q14: Question 14 In SQL, the equivalent of UCASE() is : UPPERCASE() CAPITALCASE() UPPER() TITLE()
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 12 CBSE

Question 4

Question 12Which of the following codes will display the total number of rows in the DataFrame stud?print (len(stud.axes[0]))print (stud.len(0) )print (stud.len [axes=0] )print (len (stud.axes[row] )

Accepted Answer

print(len(stud.axes[0]))Reason — The command stud.axes[0] gives access to the index labels along the 0th axis (rows) of the DataFrame stud. The len(stud.axes[0]) returns the length of this index label array, which corresponds to the total number of rows in the DataFrame stud.

Question 5

Question 13By restricting the server and encrypting the data, a software company's server is unethically accessed in order to obtain sensitive information. The attacker blackmails the company to pay money for getting access to the data, and threatens to publish sensitive information unless price is paid. This kind of attack is known as :PhishingIdentity TheftPlagiarismRansomware

Accepted Answer

RansomwareReason — Ransomware is a type of malicious attack where an attacker gains unauthorized access to a system or server, encrypts the data, and demands a ransom in exchange for the information. In this scenario, the attacker is threatening to publish sensitive information unless the company pays the ransom, which is a characteristic of a ransomware attack.

Question 6

Question 14In SQL, the equivalent of UCASE() is :UPPERCASE()CAPITALCASE()UPPER()TITLE()

Accepted Answer

UPPER()Reason — The equivalent function in SQL to UCASE() is UPPER(). Both perform the same operation, which is to convert all characters in a string to uppercase.

Question 7

Question 15Collection of hyper linked documents available on the internet is known as ............... .WebsiteWebpageWeb ServerWeb Hosting

Accepted Answer

WebsiteReason — A website or a site is a group of related web pages hosted on a web server and are linked together (through hyperlinks and hypertext) and share a common interface and design.

Question 8

Question 16............... is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared freely.Creative CostCritical CommonsCreative CommonsCreative Common

Accepted Answer

Creative CommonsReason — Creative Commons is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared freely.

Question 9

Question 17Assertion (A). MODEM stands for modulator-demodulator.Reasoning (R). It is a computer hardware device that converts data from a digital format to analog and vice versa.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationMODEM stands for modulator-demodulator. It is a computer hardware device that allows connecting and communicating with other computers via telephone lines. It converts digital data from a computer into analog signals suitable for transmission over telephone lines, and vice versa, converting incoming analog signals back into digital data that the computer can understand.

Question 10

Question 18Assertion (A). To use the Pandas library in a Python program, one must import it.Reasoning (R). The only alias name that can be used with the Pandas library is pd.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is true but R is false.ExplanationIn order to work with Pandas in Python, we need to import the Pandas library into our Python environment using the statement import pandas as pd. While pd is a common alias used with the Pandas library, it's not the only alias that can be used. We can import Pandas using other alias names as well.

Question 11

Question 24Give the output:import pandas as pd
name = ['Rahul','Aman','Karan']
p=pd.Series (name, index= [0,1,2] )
p1 = p.reindex ([1,2,3])
print(p)
print(p1)

Accepted Answer

Output0    Rahul
1     Aman
2    Karan
dtype: object
1     Aman
2    Karan
3      NaN
dtype: object
ExplanationThe provided Python code utilizes Pandas to create a Series p using the list name with indices [0, 1, 2]. Subsequently, p is reindexed using p.reindex([1, 2, 3]), creating a new Series p1. The output displays both p and p1.

Question 12

Question 28(a)A relation Vehicles is given below:V_noTypeCompanyPriceQtyAW125WagonRMaruti25000025J0083JeepMahindra400000015S9090SUVMitsubishi250000018M0892Mini vanDatsun150000026W9760SUVMaruti250000018R2409Mini vanMahindra35000015Write SQL commands to:(i) Display the average price of each type of vehicle having a quantity of more than 20.(ii) Count the type of vehicles manufactured by each company.(iii) Display the total price of all types of vehicles.

Accepted Answer

(i)SELECT Type, AVG(Price) AS Average_Price
FROM Vehicles
WHERE Qty > 20
GROUP BY Type;Output+----------+---------------+
| Type     | Average_Price |
+----------+---------------+
| WagonR   |   250000.0000 |
| Mini van |  1500000.0000 |
+----------+---------------+
(ii)SELECT Company, COUNT(DISTINCT Type) AS Num_Vehicle_Types
FROM Vehicles
GROUP BY Company;Output
+------------+-------------------+
| Company    | Num_Vehicle_Types |
+------------+-------------------+
| Datsun     |                 1 |
| Mahindra   |                 2 |
| Maruti     |                 2 |
| Mitsubishi |                 1 |
+------------+-------------------+
(iii)SELECT SUM(Price * Qty) AS Total_Price
FROM Vehicles;Output+-------------+
| Total_Price |
+-------------+
|   200500000 |
+-------------+

Question 13

Question 29(b)Mention any three health hazards associated with inappropriate and excessive use of gadgets.

Accepted Answer

The three health hazards associated with inappropriate and excessive use of gadgets are as follows :Impact on Hearing — Listening to loud music for over 15 minutes can cause hearing damage. Using headphones for long periods increases bacteria in the ears by over 700 times.Impact on Bones and Joints — Technology affects posture due to prolonged sitting and repetitive movements, leading to muscle and joint strain. Repetitive Strain Injuries (RSIs) affect muscles, nerves, tendons, ligaments, and joints.Eye Problems — Constant screen exposure from smartphones, laptops, and computers can damage vision, especially due to blue light, leading to potential vision loss. Computer Vision Syndrome (CVS) is a related eye condition.

Question 14

Question 30Consider the dataframe SHOP given below:        Item     Qty    City     Price
101   Biscuit    100   Delhi       10
102   Jam        110   Kolkata     25
103   Coffee     200   Kolkata     55
104   Sauce       56   Mumbai      55
105   Chocolate  170   Delhi       25
Write commands to:(i) Write short code to show the information having city = "Delhi".(ii) Calculate Qty * Price and assign to column 'Net_Price'.(iii) Display Items of all rows.

Accepted Answer

(i)info = SHOP[SHOP['City'] == 'Delhi']
print(info)Output          Item  Qty   City  Price
101    Biscuit  100  Delhi     10
105  Chocolate  170  Delhi     25
(ii)SHOP['Net_Price'] = SHOP['Qty'] * SHOP['Price']
print(SHOP)Output          Item  Qty     City  Price  Net_Price
101    Biscuit  100    Delhi     10       1000
102        Jam  110  Kolkata     25       2750
103     Coffee  200  Kolkata     55      11000
104      Sauce   56   Mumbai     55       3080
105  Chocolate  170    Delhi     25       4250
(iii)items = SHOP['Item']
print(items)Output101      Biscuit
102          Jam
103       Coffee
104        Sauce
105    Chocolate
Name: Item, dtype: object

Question 15

Question 32Ekam, a Data Analyst with a multinational brand has designed the DataFrame df that contains the four quarter’s sales data of different stores as shown below : StoreQtr1Qtr2Qtr3Qtr40Store13002404502301Store23503404032102Store3250180145160Answer the following questions :(i) Predict the output of the following python statement :(a) print(df.size)
(b) print(df[1:3])(ii) Delete the last row from the DataFrame.(iii) Write Python statement to add a new column Total_Sales which is the addition of all the 4 quarter sales.Or (Option for part (iii) only)Write Python statement to export the DataFrame to a CSV file named data.csv stored at D: drive.

Accepted Answer

(i)(a) print(df.size)Output15
ExplanationThe size attribute of a DataFrame returns the total number of elements in the DataFrame df.(b) print(df[1:3])Output    Store  Qtr1  Qtr2  Qtr3  Qtr4
1  Store2   350   340   403   210
2  Store3   250   180   145   160
ExplanationThis statement uses slicing to extract rows 1 and 2 from the DataFrame df.(ii)df = df.drop(2)Output    Store  Qtr1  Qtr2  Qtr3  Qtr4
0  Store1   300   240   450   230
1  Store2   350   340   403   210
(iii)df['Total_Sales'] = df['Qtr1'] + df['Qtr2'] + df['Qtr3'] + df['Qtr4']Output    Store  Qtr1  Qtr2  Qtr3  Qtr4  Total_Sales
0  Store1   300   240   450   230         1220
1  Store2   350   340   403   210         1303
2  Store3   250   180   145   160          735
OrDataFrame.to_csv('D:\data.csv')

Question 16

Question 33(a)Consider the following table named "GARMENT".GCODEGNAMESIZECOLOURPRICE111T-ShirtXLRed1400.234112JeansLBlue1600.123113SkirtMBlack1100.65115TrousersLBrown1500.50116Ladies TopLPink1200.25Write SQL queries using SQL functions to perform the following operations:(i) Display the name and price after rounding off to one decimal place.(ii) Display all Gname in upper case.(iii) Display the last three characters from Gname.(iv) Display the highest Gcode from the table GARMENT.(v) Display the sum of all prices of size 'L'.

Accepted Answer

(i)SELECT GNAME, ROUND(PRICE, 1) AS ROUNDED_PRICE
FROM GARMENT;Output+------------+---------------+
| GNAME      | ROUNDED_PRICE |
+------------+---------------+
| T-Shirt    |        1400.2 |
| Jeans      |        1600.1 |
| Skirt      |        1100.7 |
| Trousers   |        1500.5 |
| Ladies Top |        1200.3 |
+------------+---------------+
(ii)SELECT UPPER(GNAME) AS GNAME_UPPERCASE
FROM GARMENT;Output+-----------------+
| GNAME_UPPERCASE |
+-----------------+
| T-SHIRT         |
| JEANS           |
| SKIRT           |
| TROUSERS        |
| LADIES TOP      |
+-----------------+
(iii)SELECT RIGHT(GNAME, 3) AS LAST_THREE_CHARACTERS
FROM GARMENT;Output+-----------------------+
| LAST_THREE_CHARACTERS |
+-----------------------+
| irt                   |
| ans                   |
| irt                   |
| ers                   |
| Top                   |
+-----------------------+
(iv)SELECT MAX(GCODE) AS HIGHEST_GCODE
FROM GARMENT;Output+---------------+
| HIGHEST_GCODE |
+---------------+
|           116 |
+---------------+
(v)SELECT SUM(PRICE) AS TOTAL_PRICE_SIZE_L
FROM GARMENT
WHERE SIZE = 'L';Output+--------------------+
| TOTAL_PRICE_SIZE_L |
+--------------------+
|           4300.873 |
+--------------------+

Question 17

Question 35(a)The heights of 10 students of eighth grade are given below :Height_cms = [145, 141, 142, 142, 143, 144, 141, 140, 143, 144] 
Write suitable Python code to generate a histogram based on the given data, along with an appropriate chart title and both axis labels. Also give suitable python statement to save this chart.

Accepted Answer

import matplotlib.pyplot as plt
Height_cms = [145, 141, 142, 142, 143, 144, 141, 140, 143, 144] 
plt.hist(Height_cms)
plt.title('Distribution of Heights of Eighth Grade Students')
plt.xlabel('Height (cm)')
plt.ylabel('Frequency')
plt.savefig('heights_histogram.png')
plt.show()Output

Question 18

Question 35(b)Write Python code to create a Line graph using the list of elements x and y. Set ylabel as "marks" and xlabel as "names". The title of the graph is 'Result'.x = ['A', 'B', 'C', 'D', 'E']
y = [82, 25, 87, 14, 90]

Accepted Answer

import matplotlib.pyplot as plt
x = ['A', 'B', 'C', 'D', 'E']
y = [82, 25, 87, 14, 90]
plt.plot(x, y, marker='o')
plt.xlabel('names')
plt.ylabel('marks')
plt.title('Result')
plt.show()Output

Practice Paper

Section A 1 Mark Each

Section B 2 Marks Each

Section C 3 Marks Each

Section D 4 Marks Each

Section E 5 Marks Each