Mastering the CBSE Class 12 Informatics Practices Board Exam 2025 needs regular practice, particularly on Multiple-Choice Questions (MCQs) that have great bearing on final scores. We have prepared, for the student's effective study, a selection of the most crucial 30 MCQs from past-year question papers as well as from CBSE sample papers with the solutions elaborated. The problems chosen are selected from key items of all the chapters, forming a thorough study guide. Working through these high-weightage MCQs will improve your confidence and optimize your exam performance.
CBSE Class 12 Informatics Practices Exam 2025: Key Highlights
CBSE 12th Informatics Practices Board Exam 2025: Top 30 MCQs with Answers
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