Explainer

CBSE Class 12th Informatics Practices Exam Tomorrow: Top 30 MCQs For Board Exam 2025

Mar 28, 2025, 17:53 IST

CBSE Class 12th Informatics Practices Exam 2025: The CBSE class 12th Informatics Practices exam is scheduled for 29th March 2025. The most important 50 MCQs are here. Students must solve all important MCQs to secure high marks in exams.

CBSE Class 12th Informatics Practices Exam

CBSE Class 12th Informatics Practices Important MCQs: The CBSE Class 12th Informatics Practices Board Exam 2025 requires thorough practice, especially with Multiple-Choice Questions (MCQs), which play a key role in scoring well. To help students prepare efficiently, we have compiled the top 30 MCQs from previous years' question papers and CBSE sample papers, along with detailed answers. These important MCQs cover essential topics from all the chapters, ensuring a strong revision before the exam. Solve these high-weightage questions to boost your confidence and improve your exam performance.

CBSE Class 12th Informatics Practices Paper: Key Highlights

Particulars	Details
Exam Conducting Body	Central Board of Secondary Education (CBSE)
Subject	Informatics Practices
Mode of Exam	Offline
Exam Duration	3 Hours
Medium of Exam	English / Hindi
Type of Questions	MCQs, Short and Long Answer Type Questions
Total Marks	100
Passing Marks	33% in aggregate

CBSE Class 12 Informatics Practices - Top 30 MCQs for Board Exam 2025

Which of the following covers a geographical area like a city or town?
(a) LAN
(b) MAN
(c) WAN
(d) PAN
State TRUE or FALSE:
“Cyber-laws are incorporated for punishing all criminals only.”- FALSE
GPL stands for:
(a) General Public License
(b) GNU General Private License
(c) GNU General Public License
(d) GNU Public License
Which of the following is NOT an aggregate function of MySQL?
(a) AVG()
(b) SUM()
(c) ADD()
(d) MIN()
If column “per” contains the data set (97.5, 56.2, 75.6, 56.2, 75.6), what will be the output after executing the query?
SELECT AVG(DISTINCT Fees) FROM student;
(a) 76.43
(b) 76.34
(c) 67.43
(d) 67.34
A network that covers a city or district is called:
(a) LAN
(b) WAN
(c) MAN
(d) Internet
Digital footprints are stored:
(a) Temporarily for a few days
(b) Permanently
(c) For 7 days only
(d) For 3 days only
Online posting of rumors, giving threats online, posting personal information, and public ridicule of a victim is termed as:
(a) Cyber Insult
(b) Cyber Crime
(c) Cyber Bullying
(d) All of the above
What will be returned by the given query?
SELECT INSTR(‘INDIA’ , ’DI’);
(a) 2
(b) 3
(c) -2
(d) -3
If column “Price” contains the dataset (3000, 8000, 4500, 5000, 3000, 7000), what will be the output after executing the query?
SELECT COUNT(DISTINCT Price) FROM student;
(a) 3
(b) 4
(c) 5
(d) 6
A __________ network is an interconnection among two or more computers or computing devices.
(a) Computer
(b) Social
(c) Mobile
(d) Society
Burning e-waste such as circuit boards produces harmful chemicals like ________, causing skin diseases, allergies, and lung cancer.
(a) Hydrogen
(b) Beryllium
(c) Chlorine
(d) Oxygen
Which of the following is NOT a type of cybercrime?
(a) Data theft
(b) Installing an antivirus for protection
(c) Forgery
(d) Cyberbullying
In a MySQL database, if table EMPLOYEE has a degree of 5 and cardinality of 4, and table DEPARTMENT has a degree of 3 and cardinality of 3, what will be the degree and cardinality of their Cartesian product?
(a) 5,3
(b) 8,12
(c) 12,8
(d) 4,3
What is the output of the following SQL command?
SELECT ROUND(49.88);
(a) 49.88
(b) 49.8
(c) 49.0
(d) 50
IPR stands for:
(a) Indian Property Right
(b) Intellectual property rights
(c) Intellectual property rights
(d) Intellectual Property resource
Which SQL statement displays records from the table ORDERS in descending order of their bill amount?
(a) SELECT * FROM ORDERS GROUP BY BILL_AMOUNT ASC;
(b) SELECT * FROM ORDERS HAVING BILL_AMOUNT DESC;
(c) SELECT * FROM ORDERS ORDER BY BILL_AMOUNT;
(d) SELECT * FROM ORDERS ORDER BY BILL_AMOUNT DESC;
Which of the following is an aggregate function?
(a) ROUND()
(b) LENGTH()
(c) MIN()
(d) NOW()
Which SQL clause is used to apply a condition on a group of data in MySQL?
(a) WHERE
(b) ORDER BY
(c) HAVING
(d) None of the above
When creating a Series from a dictionary, the keys become:
(a) Index of series
(b) Values of series
(c) Caption of series
(d) Columns of series
‘O’ in FOSS stands for:
(a) Outsource
(b) Open
(c) Original
(d) Outstanding
Which function displays the total number of records in a database table?
(a) sum()
(b) total()
(c) count()
(d) return()
Which of the following is a DDL command?
(a) SELECT
(b) ALTER
(c) INSERT
(d) UPDATE
What is the output of the following query?
SELECT LOWER(MONTHNAME('2023-03-05'));
(a) May
(b) March
(c) may
(d) march
A __________ is a one-dimensional array.
(a) DataFrame
(b) Series
(c) Both (a) and (b)
(d) None
Which function finds the largest value in a MySQL dataset?
(a) MAX()
(b) MAXIMUM()
(c) BIG()
(d) LARGE()
To get the number of elements in a Series object, which attribute is used?
(a) index
(b) size
(c) itemsize
(d) ndim
The legal term for the rights of a creator of original creative or artistic work is:
(a) Copyright
(b) Copyleft
(c) FOSS
In SQL, which query displays the list of tables in a database?
SHOW TABLES;
For web pages where information changes frequently (e.g., stock prices), which option is better?
(a) Static web page
(b) Dynamic web page