MCQ – Practice Paper for IP (Paper – 3)
Prepare for your CBSE Class 12 Information Practice exam with these 18 carefully crafted multiple-choice questions. Before diving into this quiz, you can also attempt the “MCQ – Practice Paper for IP (Paper – I)” and “MCQ – Practice Paper for IP (Paper – 2)” This comprehensive practice test covers essential topics including Python Pandas, Matplotlib, Networking, and MySQL. Take both quizzes to test your understanding and boost your confidence for the final boards.
| 1. State True or False : Slicing can be used to extract a specific portion from a Pandas Series. | |||
| Answer : True | |||
| 2. The purpose of WHERE clause in a SQL statement is to: | |||
| a) Create a table | b) Filter rows based on a specific condition | ||
| c) Specify the columns to be displayed | d) Sort the result based on a column | ||
| Answer : b) Filter rows based on a specific condition | |||
| 3. Identify the networking device responsible for routing data packets based on their destination addresses | |||
| a) Modem | b) Hub | c) Repeater | d) Router |
| Answer : d) Router | |||
| 4. Identify the SQL command used to delete a relation (table) from a relational database: | |||
| a) Drop | b) Remove | c) Erase | d) Delete |
| Answer : a) Drop | |||
| 5. E-waste refers to | |||
| a) Software that has become obsolete | b) Data that deleted from a storage device | ||
| c) Viruses that infect computers. | d) Electronic devices that are no longer in use | ||
| Answer : d) Electronic devices that are no longer in use | |||
| 6. Which of the following Python statements can be used to select a column column_name from a DataFrame df? | |||
| a) df[‘column_name’] | b) df.getcolumn(‘column_name) | c) df(column_name) | d) df.select(‘column_name) |
| Answer : a) df[‘column_name’] | |||
| 7. By default, the plot() function of Matplotlib draws a ……………….. plot | |||
| a) histogram | b) bar | c) line | d) column |
| Answer : c) line | |||
| 8. State True or False : In SQL, the Having clause is used to apply filter on groups formed by the GROUP BY clause. | |||
| Answer: True | |||
| 9. Which of the following Python statements is used to import data from CSV file into a Pandas DataFrame (Note : pd is an alias for Pandas) | |||
| a) pd.read_csv(‘filename.csv’) | b) pd.load_csv(‘filename.csv’) | ||
| c) pd.open_csv(‘filename.csv’) | d) pd.import_csv(‘filename.csv’) | ||
| Answer : a) pd.read_csv(‘filename.csv’) | |||
| 10. What is Plagiarism? | |||
| a) Using copyrighted material without giving proper acknowledgement to the source | |||
| b) Downloading illegal software | |||
| c) Spreading misinformation online | |||
| d) Hacking into computer systems. | |||
| Answer : a) Using copyrighted material without giving proper acknowledgement to the source | |||
| 11. The count(*) function provides the total number of ……………….. within a relation in a relational database. | |||
| a) Columns | b) Unique | c) Not Null | d) Rows |
| Answer : d) Rows | |||
| 12. In which of the network topologies do all devices connect to a central point, such as a switch or hub? | |||
| a) Star | b) Bus | c) Tree | d) Mesh |
| Answer : a) Star | |||
| 13. In a Pandas DataFrame, if the tail() function is used without specifying the optional argument indicating the number of rows to display, what is the default number of rows displayed, considering the DataFrame has 10 entries? | |||
| a) 0 | b) 1 | c) 4 | d) 5 |
| Answer: d) 5 | |||
| 14. Identify the type of cybercrime that involves sending fraudulent emails to device individuals into revealing sensitive information. | |||
| a) Hacking | b) Phishing | c) Cyberbullying | d) Cyberstalking |
| Answer : b) Phishing | |||
| 15. While creating a Series using a dictionary, the keys of the dictionary become: | |||
| a) Values of the series | b) Indices of the series | ||
| c) Data type of the series | d) Name of the series | ||
| Answer : b) Indices of the series | |||
| 16. Match the following SQL functions/clauses with their description:
|
|||
| a) P-2, Q-4, R-3, S-1 | b) P-2, Q-4, R-1, S-3 | c) P-4, Q-3, R-2, S-1 | d) P-4, Q-2, R-1, S-3 |
| Answer : a) P-2, Q-4, R-1, S-3 | |||
| 17. Boolean indexing in Pandas DataFrame can be used for…………………………. | |||
| a) Creating a new DataFrame | b) Sorting data based on index label | ||
| c) Joining data using tables | d) Filtering data based on condition | ||
| Answer : d) Filtering data based on condition | |||
| 18. Which Matplotlib plot is best suited to represent changes in data over time? | |||
| a) Bar plot | b) Histogram | c) Line plot | d) Histogram & bar plot |
| Answer : c) Line plot : A line plot is ideal for visualizing trends over time because it connects data points with lines, making it easy to observe increases, decreases, or patterns in the data. | |||
| 19. Which type of network covers a small geographical area like a single office, building or school campus? | |||
| a) PAN | b) LAN | c) MAN | d) WAN |
| Answer : b) LAN | |||
| Q20 and Q 21 are ASSERTION and REASONING-based questions. Mark the correct choice as | |||
| Both A and R are True and R is the correct explanation for A. | |||
| Both A and R are True and R is not the correct explanation for A. | |||
| A is True but R is False | |||
| A is False but R is True | |||
| 20. Assertion (A) : We can add a new column in an existing DataFrame. | |||
| Reasoning (R) : DataFrames are size mutable. | |||
| Answer : a) Both A and R are True and R is the correct explanation for A. | |||
| 21. Assertion (A) : In SQL, “Insert into” is a DDL command. | |||
| Reasoning (R) : DDL Commands are used to create, modify, or remove database structures such as tables | |||
| Answer : d) A is False but R is True. (In SQL, ‘Insert into’ is a DDL command.) | |||
I hope these MCQs have helped you in your preparation for the CBSE Class 12 Information Practice exam. If you haven’t already, I recommend practicing MCQ – Practice Paper for IP (Paper – I) and MCQ – Practice Paper for IP (Paper – 2) to build a strong foundation. Keep practicing, and best of luck with your exams!
