Page 27 - IPP-12-2024

9. Predict the output of the following query:

SELECT UPPER(LEFT(MONTHNAME('2023-12-10'),5));
(i) OCTOB (ii) DECEM
(iii) Decem (iv) EMBER (1)
10. Which of the following commands will show the total number of rows and columns present in a DataFrame
named as df?
(i) df.size (ii) df.shape
(iii) df.Shape (iv) df.shape() (1)
11. The unique identifier in a table that is not allowed to have duplicate or null values is called a
_______________________.
(i) Primary key (ii) Foreign key
(iii) Alternate key (iv) Candidate key (1)
12. Which of the following functions is used in pandas to display the first five rows of a specific column in a
DataFrame (df)?
(i) df.show(5) (ii) df.head()
(iii) df.tail(5 ) (iv) df.display(5) (1)
13. Which of the following chemicals can be categorized as electronic waste?
(i) Lead (ii) Cadmium
(iii) Mercury (iv) All of these (1)
14. In SQL, the equivalent of LCASE()is:
(i) LOWER() (ii) LOWERCASE()
(iii) UCASE() (iv) UPPER() (1)

15. _______________________ is used for accessing and storing emails from mail servers over a TCP/IP
connection.
(i) SMTP (ii) HTTP
(iii) POP3 (iv) IMAP (1)
16. Digital footprints should be properly managed as they can reveal a lot of personal information about you
which, once shared, can’t be erased or controlled. (True/False) (1)
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as
(i) Both A and R are true and R is the correct explanation for A
(ii) Both A and R are true and R is not the correct explanation for A
(iii) A is true but R is false
(iv) A is false but R is true (1)
17. Assertion (A): A Network Interface Unit (NIU) is an interpreter that helps establish communication between
a server and client.
Reasoning (R): NIU has a 12-digit address known as MAC address, which is written as 00 : B0 : E5 : 14 : B8
: 46 , where the first half represents serial number assigned to the adapter by the manufacturer and the
second half represents the ID number of the adapter manufacturer. (1)
18. Assertion (A): A DataFrame is a one-dimensional, tabular data structure in pandas.
Reasoning (R): DataFrame is like a spreadsheet or an SQL table, where data is organized in the form of rows
and columns. (1)

A.2 Informatics Practices with Python–XII