CBSE Class 12 Informatics Practices Sample Paper 2023

PART A

1. Television cable network is an example of:
i. LAN
ii. WAN
iii. MAN
iv. Internet

Answer : iii. MAN

2. Which of the following is not a type of cyber crime?
i. Data theft
ii. Installing antivirus for protection
iii. Forgery
iv. Cyber bullying

Answer : ii. Installing antivirus for protection

3. What is an example of e-waste?
i. A ripened mango
ii. Unused old shoes
iii. Unused old computers
iv. Empty cola cans

Answer : iii. Unused old computers

4. Which type of values will not be considered by SQL while executing the following statement?
SELECT COUNT(column name) FROM inventory;
i. Numeric value
ii. text value
iii. Null value
iv. Date value

Answer : iii. Unused old computers

5. If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?
SELECT SUM (DISTINCT Fees) FROM student;
i. 20500
ii. 10000
iii. 20000
iv. 33500

Answer : i. 20500

6. ‘O’ in FOSS stands for:
i. Outsource
ii. Open
iii. Original
iv. Outstanding

Answer : ii. Open

7. Which SQL statement do we use to find out the total number of records present
in the table ORDERS?
i. SELECT * FROM ORDERS;
ii. SELECT COUNT (*) FROM ORDERS;
iii. SELECT FIND (*) FROM ORDERS;
iv. SELECT SUM () FROM ORDERS;

Answer : ii. SELECT COUNT (*) FROM ORDERS;

8. Which one of the following is not an aggregate function?
i. ROUND()
ii. SUM()
iii. COUNT()
iv. AVG()

Answer : i. ROUND( )

9. Which one of the following functions is used to find the largest value from the given data in MySQL?
i. MAX( )
ii. MAXIMUM( )
iii. BIG( )
iv. LARGE( )

Answer : i. MAX ()

10. To display last five rows of a series object ‘S’, you may write:
i. S.Head()
ii. S.Tail(5)
iii. S.Head(5)
iv. S.tail()

Answer : i. MAX ()

11. Which of the following statement will import pandas library?
i. Import pandas as pd
ii. import Pandas as py
iii. import pandas as pd
iv. import panda as pd

Answer : iii. import pandas as pd

12. Which of the following can be used to specify the data while creating a
DataFrame?
i. Series
ii. List of Dictionaries
iii. Structured ndarray
iv. All of these

Answer : iv. All of thes

13. Which amongst the following is not an example of a browser?
i. Chrome
ii. Firefox
iii. Avast
iv. Edge

Answer : iv. All of thes

14. In SQL, which function is used to display current date and time?
i. Date ()
ii. Time ()
iii. Current ()
iv. Now ()

Answer : iv. Now()

15. Legal term to describe the rights of a creator of original creative or artistic work is:
i. Copyright
ii. Copyleft
iii. GPL
iv. FOSS

Answer : i. Copyright

16. __________is the trail of data we leave behind when we visit any website (or use any online application or portal) to fill-in data or perform any transaction.
i. Offline phishing
ii. Offline footprint
iii. Digital footprint
iv. Digital phishing

Answer : iii. Digital footprint