Skip to content
← Computer Science

Computer Science · Class 12 Optional

Yanam Cbse Class 12 Computer Science — Real Previous-Year Papers

with complete answers

Real previous-year board papers, year by year — the official exam pattern, the full question paper, and every question solved the concept-first way. Distinct from the chapter-wise textbook bank.

2019–2026
Years of papers
14
Total Papers
14
Real Board Papers
0
Sample papers
345
Real-paper Q & A
0
Sample-paper Q & A

Real board-paper questions available, by year

45 Q20262 sets
49 Q20252 sets
46 Q20242 sets
79 Q20233 sets
25 Q20222 sets
—2021Not available
39 Q2020complete
62 Q20192 sets

CBSE Class XII Board 2026 · Set 90/1/1

Real board examination
Sets

About this paper

The real Class-12 board examination held in 2026. Every question below is solved the concept-first way. Sample papers are labelled honestly — never shown as a past exam.

Total marks
70
Questions
37
Duration
180 min
Sections
5

The marks / questions / duration above are the official exam pattern. We currently have 8 of this paper’s questions (22% of the full paper), with 8 fully solved. Questions we couldn’t yet extract or verify are held — never shown as complete.

Sections & marks

SectionTypeQuestionsMarks eachTotal
ASection AObjective (MCQ / True-False / 1-mark)21121
BSection BVery short answer7214
CSection CShort answer339
DSection DLong answer4416
ESection ELong answer2510
Total3770

The question paper

The questions we hold for this paper, laid out by section. Solutions are on the Answers tab.

Board Examination

Computer Science

CBSE Class XII Board 2026 · Set 90/1/1

Series/Set: 90/1/1Roll No. ________
Time Allowed: 3 hoursMaximum Marks: 70

General Instructions

  1. This question paper contains 37 questions divided into 5 sections — A, B, C, D, E.
  2. Section A comprises 21 questions of 1 mark each (Objective (MCQ / True-False / 1-mark)).
  3. Section B comprises 7 questions of 2 marks each (Very short answer).
  4. Section C comprises 3 questions of 3 marks each (Short answer).
  5. Section D comprises 4 questions of 4 marks each (Long answer).
  6. Section E comprises 2 questions of 5 marks each (Long answer).

Above is the official exam pattern. The questions printed below are those we currently hold for this paper.

Section A

Objective (MCQ / True-False / 1-mark) · 1 mark each · 3 of 21 shown

Q1.
Which of the following network topology uses a central cable (backbone) to connect all devices ? (A) Mesh (B) Star (C) Tree (D) Bus
[1]
Q2.
What will be the result of the following SQL command ? SELECT LENGTH ('Data Base'); (Note : There is single space between the words Data and Base.) (A) 7 (B) 8 (C) 9 (D) Error
[1]
Q3.
What will be the result of the following SQL command ? SELECT ROUND(15.678, 2); (A) 15.00 (B) 15.67 (C) 15.68 (D) 16.00
[1]
Section B

Very short answer · 2 marks each · 1 of 7 shown

Q1.
Write SQL queries to perform the following : (I) Display the month (in numeric form) of the date '2026-01-01'. (II) Display only the year part from the date '2026-01-01'.
[2]
Page 1 of 3
Section C

Short answer · 3 marks each · 2 of 3 shown

Q1.
(i) Write an SQL statement to create a table named PRODUCTS with the following specifications : | Column Name | Data Type | Key | | --- | --- | --- | | PID | Integer | Primary Key | | PName | Varchar of size 30 | | | PCat | Char of size 15 | | | Price | Decimal Number | | (ii) Write an SQL query to increase the price of all items by 100, whose product category is Grocery, in the table PRODUCTS.
[3]
Q2.
(a) Consider the following tables : Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name (TName), Experience (Experience) and City (City) that they live in. | TID | TName | Experience | City | | --- | --- | --- | --- | | 1 | Kartik | 5 | Bhopal | | 2 | Shahnaz | 6 | Nagpur | | 3 | Rajendra | 7 | Delhi | | 4 | Tanvi | 4 | Bhopal | | 5 | Alam | 9 | Delhi | Table 2 : SUBJECT, which stores Subject ID (SID), Subject Name (SubName) and ID of the teacher(TID) teaching that Subject. | SID | SubName | TID | | --- | --- | --- | | 101 | Physics | 1 | | 102 | Chemistry | 2 | | 103 | Mathematics | 3 | | 104 | Informatics Practices | 4 | | 105 | Computer Science | 5 | Write appropriate SQL query for the following : (I) Delete the record of the subject whose TID is equal to 4. (II) Display the names of teachers who have more than 5 years of experience and who stay in Nagpur. (III) Display subject names along with their teacher names. OR (b) Consider the table LIBRARY as given below. | BookId | Title | Genre | Price | | --- | --- | --- | --- | | 101 | Python Basics | Technology | 278 | | 201 | The Silent Patient | Fiction | 340 | | 301 | Data Science | Technology | 291 | | 401 | Oceans | Marine Life | NULL | (I) Which attribute(s) can be considered as the Candidate keys(s) ? Justify your answer. (II) Write an SQL query to insert a new record with the following values : BookId : 501 Title : AI for ALL Genre : Technology Price : 589 (III) Write an SQL query to add a new column Author that is a character data type of size 20.
[3]
Section D

Long answer · 4 marks each · 1 of 4 shown

Q1.
(a) Shalini, who works as a database designer in the hotel industry, has created a table named Guest to keep track of guest details as shown below : Table : Guest | GuestID | GuestName | RoomNumber | CheckInDate | Charges | | --- | --- | --- | --- | --- | | G101 | Harish | 101 | 2025-04-03 | 3000 | | G102 | Sunita | 101 | 2025-04-03 | 3000 | | G103 | Ramesh | 102 | 2025-05-04 | 5000 | | G104 | Bhumika | 103 | 2025-06-02 | 3500 | Write a suitable SQL query for the following : I. Display last 3 characters of guest name in upper case. II. Display the name of the guest along with the day name of check-in date. III. Display the remainder when charges are divided by 1000. IV. Extract and display three characters, starting from the second character, of each guest name. OR (b) Consider the following table and write the output of the following SQL Queries. Table : ORDERS | ORDERID | CUSTOMERNAME | TOTALAMOUNT | DISCOUNT | ORDERDATE | | --- | --- | --- | --- | --- | | 101 | Hemant | 5000 | 10 | 2024-03-01 | | 102 | Neha | 7000 | 15 | NULL | | 103 | Keshav | 3000 | 5 | 2024-01-20 | | 104 | Sandhya | 4500 | NULL | 2023-12-25 | Write the output of the following SQL Queries : I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS NOT NULL; II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE DISCOUNT BETWEEN 5 AND 10; III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE ORDERDATE IS NOT NULL; IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;
[4]
Page 2 of 3
Section E

Long answer · 5 marks each · 1 of 2 shown

Q1.
(a) Write suitable SQL query for the following : I. To display only the date part from the date/time expression '2026-01-01 10:10:10' II. To convert all customer names from the CustName column to lowercase in the Customer table. III. To extract the first 4 characters from the CityName column in Location table. IV. To display the name of the city from the CITY column in EVENT table, after removing leading spaces. V. To find the average salary from Salary column in Employees table. OR (b) Write suitable SQL query for the following : I. To display the value of 17² . II. To display the day part of the dates in the HireDate column of the Employee table. III. To display the maximum value of the BillAmount column in the Bill table. IV. To remove leading and trailing spaces from the Location column in the Branch table. V. To display total salary from totsal column in Employees table.
[5]
Page 3 of 3