CBSE Class 12 IP 2026 बोर्ड पेपर + Solutions
1.
State whether the following statement is True or False:
In Pandas Series, the Positional index can be a string or an integer.
Answer: False
2.
We can add a new row to a DataFrame DF using the ______ method.
(A) DF.add()
(B) DF.loc[]
(C) DF.loc()
(D) DF.addloc[]
Answer: (B) DF.loc[]
3. Naveen discarded various types of waste material
without realizing that e-waste contains harmful substances that could pollute
the environment. He wants to know which of the following will be considered as
e-waste.
A. Plastic Bottle
B. Broken Smartphone
C. Aluminium Foil
D. Banana Peel
4. In which scenario is a bar chart preferred over a line
chart?
A. To visualize monthly temperature trends over a year
B. To compare the number of students in different
classes.
C. To show stock price movements over time.
D. To analyze trends in website traffic over days.
5. Which of the following network topology used a central
cable (backbone) to connect all devices?
A. Mesh
B. Star
C. Tree
D. Bus
Reason: In a bus topology, all devices are connected to a single main cable called a backbone. Data travels along this cable, and every device is linked to it.
6. State whether the following statement is True or
False:
In SQL, an aggregate function returns multiple values for each column on which is applied.
False
7. Rohini has developed a new kind of water purifier that
used a unique filtration method. Which type of Intellectual Property Right
should she apply to protect her invention?
A. Trademark
B. Copyright
C. Patent
D. Both Copyright & Trademark
8. Aditya is working on a DataFrame named df. He has
written the statement:
print(df.loc[‘S2’] )
What will the above statement do?
A. Display the data of the row having label ‘S2’.
B. Display the columns of the DataFrame.
C. Display the data type of the column having label ‘S2’.
D. Display the index numbers of the DataFrame.
9. What will be the result of the following SQL command?
SELECT LENGTH (‘DATA BASE) ;
(Note: There is single space between the words Data and Base)
A. 7
B. 8
C. 9
D. Error
10. Which of the following is a key feature of a Static
Web Page?
A. Its content updates very frequently.
B. It displays different content to different users.
C. It loads slower than a Dynamic Web Page.
D. It shows the same content unless the code is manually
updated.
11. Which of the following is the correct expanded form
of DML?
A. Device Management Language
B. Device Manipulation Language
C. Data Management Language
D. Data Manipulation Language
12. CSV stands for __________ Separated Values.
A. Colon
B. CTRL
C. Comma
D. Caret
13. Which of the following is an example of maintaining good net etiquette?
A. Spamming emails or messages to strangers.
B. Ignoring other’s opinions in online discussions.
C. Not using copyrighted materials without permission of
the owner.
D. Sharing someone’s private information publicly.
14. In the context of creating a Pandas Series from a
dictionary, which of the following statement is correct?
A. The values of the dictionary become the indices of the Series.
B. The keys of the dictionary become the values of the Series.
C. The keys of the dictionary become the indices of the Series.
D. The Series will have default integer indices starting from 0, ignoring the
dictionary keys.
15. In Pandas, when extracting a portion of a
Series serl using serl[start:end] with positional
indices start and end, which of the following statements is
true?
A. The element at the end index is included in the output.
B. The element at the end index is excluded from the output.
C. The elements at both the start and end indices are
excluded from the output.
D. The element at the start index is excluded from the output.
16. Nisha is using an Android app to make a voice call
over the internet to her friend in another country. Which protocol is being
used in this case?
A. Chat
B. VoIP
C. Email
D. TV
17. State whether the following statement is True or
False:
The INSTR(string1, string2) function in SQL returns 0
if string2 is not present as a substring in string1.
Ans: True
18. In a Pandas DataFrame, which value for axis will
be used to delete a column?
A. axis = -1
B. axis = 0
C. axis = 1
D. axis = 2
19. What will be the result of the following SQL command?
SELECT ROUND(15.678, 2);
A. 15.00
B. 15.67
C. 15.68
D. 16.00
Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type
questions. Choose the correct option as:
A. Both (A) and (R) are True, and (R) correctly explains (A).
B. Both (A) and (R) are True, but (R) does not correctly explain (A).
C. (A) is True, but (R) is False.
D. (A) is False, but (R) is True.
20. Assertion (A): Pandas DataFrame can store
values of multiple data types in multiple columns.
Reason (R): DataFrames are implemented using 2D arrays, which
allows only numeric values.
Ans: A is True, but R is False.
21. Assertion (A): The output of the SQL
query SELECT COUNT(name) FROM students; will differ from the output
of SELECT COUNT(*) FROM students; if there are some NULL values in
the name column.
Reason (R): COUNT(column_name) returns the count of NON NULL
values in that column, whereas COUNT(*) returns the number of records
in the table.
Ans: Both A and R are True, and R correctly explains A.
