Home Articles CBSE 12th Informatics Practices Board Exam 2025 Tomorrow: Top 30 MCQs to Score Highly in the Exam

CBSE 12th Informatics Practices Board Exam 2025 Tomorrow: Top 30 MCQs to Score Highly in the Exam

CBSE 12th Boards >

Board

Akansha
Akansha
CBSE 12th Informatics Practices Board Exam 2025 Tomorrow: Top 30 MCQs to Score Highly in the Exam

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

ParticularsDetails
Exam Conducting Body
Central Board of Secondary Education (CBSE)
Subject
Informatics Practices
Mode of ExamOffline
Exam Duration3 Hours
Medium of ExamEnglish / Hindi
Type of Questions
MCQs, Short and Long Answer Type Questions
Total Marks100
Passing Marks
33% in aggregate

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

Check Eligibility Apply Now