CBSE Class 12 Informatics Practices Sample Paper 2024

SECTION A

1. A ____________is a device that connects the organisation’s network with the outside world of the Internet.
i. Hub
ii. Modem
iii. Gateway
iv. Repeater
Answer : iii

2. When e-waste such as electronic circuit boards are burnt for disposal, the elements contained in them create a harmful chemical called ________which causes skin diseases, allergies and an increased risk of lung cancer.
i. Hydrogen
ii. Beryllium
iii. Chlorine
iv. Oxygen
Answer : ii

3. Copyright, Patent and Trademark comes under:
i. Intellectual Property Right
ii. Individual Property Right
iii. Industrial Property Right
iv. None of the above
Answer : i

4. Predict the output of the following query:
SELECT MOD (9,0);
i. 0
ii. NULL
iii. NaN
iv. 9
Answer : ii

5. Which of the following SQL functions does not belong to the Math functions category?
i. POWER()
ii. ROUND()
iii. LENGTH()
iv. MOD()
Answer : iii

6. ________ is not a FOSS tool.
i. Libre Office
ii. Mozilla Firefox
iii. Google Chrome
iv. Python
Answer : iii

7. CSV stands for:
i. Column Separated Value
ii. Class Separated Value
iii. Comma Separated Value
iv. None of the above
Answer : iii

9. Predict the output of the following query:
SELECT LCASE (MONTHNAME ('2023-03-05'));
i. May
ii. March
iii. may
iv. march
Answer : iv

10. Which of the following command will show the last 3 rows from a Pandas Series named NP?
i. NP.Tail( )
ii. NP.tail(3)
iii. NP.TAIL(3)
iv. All of the above
Answer : ii

11. With reference to SQL, identify the invalid data type.
i. Date
ii. Integer
iii. Year
iv. Month
Answer : iv

12. In Python Pandas, while performing mathematical operations on series, index matching is implemented and all missing values are filled in with _____by default.
i. Null
ii. Blank
iii. NaN
iv. Zero
Answer : iii

13. By 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:
i. Phishing
ii. Identity Theft
iii. Plagiarism
iv. Ransomware
Answer : iv

14. In SQL, the equivalent of UCASE() is:
i. UPPERCASE ()
ii. CAPITALCASE()
iii. UPPER()
iv. TITLE ()
Answer : iii

15. Collection of hyper linked documents available on the internet is known as_______________.
i. Website
ii. Webpage
iii. Web Server
iv. Web Hosting
Answer : i

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.
i. Creative Cost
ii. Critical Commons
iii. Creatve Commons
iv. Creative Common
Answer : iii

17. Assertion (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.
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
Answer : i

18. Assertion (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.
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
Answer : iii

Please refer to attached file for CBSE Class 12 Informatics Practices Sample Paper 2024