CBSE Class 12 Question Paper 2026 Solution Information Technology

FOR CBSE CLASS 12 EXAM PREPARATION

CBSE Class 12 2026
Question Paper
Solution · Information
Technology
EXAM YEAR TYPE SUBJECT

CBSE Class 12 2026 Question Paper Solution Information Technology

Notes · Sample Papers · Previous Year Papers · Mock Tests

.
.co s e m

s em l a
a ag
Marking Scheme
Strictly Confidential
(For Internal and Restricted use only)
Senior School Certificate Examination, 2026
SUBJECT NAME INFORMATION TECHNOLOGY (Q.P. CODE 326)
SUBJECT CODE – 802
General Instructions: -
m
om
You are aware that evaluation is the most important process in the actual
. co
1
. c
and correct assessment of the candidates. A small mistake in evaluation
em
em
may lead to serious problems which may affect the future of the
l as
as
candidates, education system and teaching profession. To avoid
l ag
ag
mistakes, it is requested that before starting evaluation, you must read
and understand the spot evaluation guidelines carefully.

“Evaluation policy is a confidential policy as it is related to the
2 confidentiality of the examinations conducted, Evaluation done and
several other aspects. Its’ leakage to public in any manner could lead
to derailment of the examination system and affect the life and future
of millions of candidates. Sharing this policy/document to anyone,
publishing in any magazine and printing in News Paper/Website etc.
m
may invite action under various rules of the Board and IPC.”
o
c
. provided in the Marking
e m
Evaluation is to be done as per instructions
3
a s
Scheme. It should not be done according
l Scheme
to one’s own interpretation or

ag
any other consideration. Marking
and religiously followed. However, while
should be strictly adhered to
evaluating, answers which are
based on latest information or knowledge and/or are innovative, they
may be assessed for their correctness otherwise and due marks be
awarded to them. In class-X, while evaluating two competency-based
questions, please try to understand given answer and even if reply is
not from marking scheme but correct competency is enumerated by
the candidate, due marks should be awarded.

The Marking Scheme carries only suggested value points for the answers.
m
m 4 These are in the nature of Guidelines only and do not constitute the
.co
m .co em
complete answer. The students can have their own expression and if the
s
la
expression is correct, the due marks should be awarded accordingly.
s e g
g la a books evaluated
a
The Head-Examiner must go through the first five answer
5 by each evaluator on the first day, to ensure that evaluation has been
carried out as per the instructions given in the Marking Scheme. If there is
any variation, the same should be zero after deliberation and discussion.
The remaining answer books meant for evaluation shall be given only after
ensuring that there is no significant variation in the marking of individual
evaluators.

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 1
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 1 of 28

Evaluators will mark( √ ) wherever answer is correct. For wrong answer
6 CROSS “X” be marked. Evaluators will not put right (✓)while evaluating
which gives an impression that answer is correct and no marks are
awarded. This is most common mistake which evaluators are
committing.

If a question has parts, please award marks on the right-hand side for
7 each part. Marks awarded for different parts of the question should then
be totaled up and written in the left-hand margin and encircled. This may
be followed strictly.

If a question does not have any parts, marks must be awarded in the left-
8 hand margin and encircled. This may also be followed strictly.

If a student has attempted an extra question, answer of the question
9 deserving more marks should be retained and the other answer scored
out with a note “Extra Question”.

No marks to be deducted for the cumulative effect of an error. It should be
10 penalized only once.

A full scale of marks __________(example 0 to 80/70/60/50/40/30 marks
11 as given in Question Paper) has to be used. Please do not hesitate to
award full marks if the answer deserves it.

Every examiner has to necessarily do evaluation work for full working
12 hours i.e., 8 hours every day and evaluate 20 answer books per day in
main subjects and 25 answer books per day in other subjects (Details are
given in Spot Guidelines).This is in view of the reduced syllabus and
number of questions in question paper.

Marking Scheme 802 (2025 - 26) Page No - 2

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 2 of 28

.
.co s e m

s em l a
a ag
Ensure that you do not make the following common types of errors
13 committed by the Examiner in the past:-
● Leaving answer or part thereof unassessed in an answer book.
● Giving more marks for an answer than assigned to it.
● Wrong totaling of marks awarded on an answer.
● Wrong transfer of marks from the inside pages of the answer

m
book to the title page.
● Wrong question wise totaling on the title page.
om
● Wrong totaling of marks of the two columns on the title page. . co
. c
● Wrong grand total. em
em
● Marks in words and figures not tallying/not same.
l as
l as
● Wrong transfer of marks from the answer book to online
ag
ag award list.
● Answers marked as correct, but marks not awarded. (Ensure that
the right tick mark is correctly and clearly indicated. It should
merely be a line. Same is with the X for incorrect answer.)
● Half or a part of answer marked correct and the rest as wrong, but
no marks awarded.

While evaluating the answer books if the answer is found to be totally
14 incorrect, it should be marked as cross (X) and awarded zero (0)Marks.
m
m .co
e
Any unassessed portion, non-carrying over of marks to the title page, or
s
15
l a
totaling error detected by the candidate shall damage the prestige of all

ag
the personnel engaged in the evaluation work as also of the Board.
Hence, in order to uphold the prestige of all concerned, it is again
reiterated that the instructions be followed meticulously and judiciously.

The Examiners should acquaint themselves with the guidelines given in
16 the “Guidelines for Spot Evaluation” before starting the actual
evaluation.

Every Examiner shall also ensure that all the answers are evaluated,
m
.co
17 marks carried over to the title page, correctly totaled and written in figures
m
.co
and words.
e m
e m s
la Book on
las 18 The candidates are entitled to obtain photocopy of the Answer
request on payment of the prescribed processing fee. g
a All
ag Examiners/Additional Head Examiners/Head Examiners are once again
reminded that they must ensure that evaluation is carried out strictly as per
value points for each answer as given in the Marking Scheme.

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 3
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 3 of 28

MARKING SCHEME
Senior Secondary School Examination, 2026
INFORMATION TECHNOLOGY (Subject Code–802)
[ Paper Code:326(SET-4)]

Time allowed : 3 Hours Maximum Marks: 60

General Instructions:

(i) Please read the instructions carefully.
(ii) This Question Paper consists of 24 questions in two sections: Section A and Section B.
(iii) Section A has Objective type questions whereas Section B contains Subjective type
questions.
(iv) Out of the given (6 + 18) = 24 questions, a candidate has to answer (6 + 11) = 17 questions
in the allotted (maximum) time of 3 hours.
(v) All questions of a particular section must be attempted in the correct order.
(vi) Section A: Objective Type Questions (30 Marks):
(a) This section has 6 questions.
(b) There is no negative marking.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each question/part.
(vii) Section B: Subjective Type Questions (30 Marks):
(a) This section has 18 questions.
(b) A candidate has to do 11 questions.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each question/part.
Note: Ignore semicolon (;) in SQL related commands

Marking Scheme 802 (2025 - 26) Page No - 4

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 4 of 28

.
.co s e m

s em l a
a ag
SECTION A
(Objective Type Questions) (30 Marks)
1. Answer any 4 out of the given 6 questions on Employability Skills. 4x1=4

(i) In the acronym 'SMART' to set goals, the letter 'A' implies _________ .

m
Ans.
om
Action-oriented . co
. c e m
OR
em l as
a s
Achievable
l(1 Mark for the correct answer) ag
ag

(ii) In which year did the Government of India launch the National Action
Plan on Climate Change (NAPCC)?
(A) 2005
(B) 2008
m
(C) 2010
m .co
s e
a
(D) 2012
l
Ans. (B)
ag
OR
2008
(1 Mark for the correct answer)

m
.co
(iii) Which of the following best describes active listening?
m
.co
(A) Listening passively without responding

m s em
ltoa the speaker
(B) Hearing words without comprehension
s e g
la a
(C) A process of comprehending and offering support

ag (D) Interrupting the speaker to share your experiences

Ans. (C)
OR
A process of comprehending and offering support to the speaker
(1 Mark for the correct answer)

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 5
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 5 of 28

(iv) A workbook in a spreadsheet refers to:
(A) A single document only
(B) A spreadsheet with one or more worksheets
(C) A rectangular box where a row and a column meet
(D) The toolbar of the software application

Ans. (B)
OR
A spreadsheet with one or more worksheets
(1 Mark for the correct answer)

(v) Why are interpersonal skills important for an entrepreneur ?
(A) They enable effective collaboration and teamwork.
(B) They help in managing finances efficiently.
(C) They improve technical knowledge.
(D) They ensure personal hobbies are pursued.

Ans. (A)
OR
They enable effective collaboration and teamwork.
(1 Mark for the correct answer)

(vi) Which personality trait is characterized by anxiety, self-doubt,
depression and excessive worrying?
(A) Extraversion
(B) Agreeableness
(C) Openness
(D) Neuroticism

Ans. (D)
OR
Neuroticism
(1 Mark for the correct answer)

2. Answer any 5 out of the given 7 questions. 5 x 1=5

(i) Fill in the blank:
The number of attributes in a relation is called the ____________ of a
relation.
(A) Degree (B) Cardinality
(C) Tuple (D) Domain

Marking Scheme 802 (2025 - 26) Page No - 6

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 6 of 28

.
.co s e m

s em l a
a ag
Ans. (A)
OR
Degree
(1 Mark for the correct answer)

(ii) Write the output of the following Java code:
m
o m JavaProg . co
. c
public class
em
{
m
epublic static void main(String[] args) l as
as
l { ag
ag String myStr = "Digital-India ";
System.out.println(myStr.concat("Mission"));
}
}

Ans. Digital-India Mission
(1 Mark for the correct output)

m
OR
m .co
Digital-IndiaMission
s e
l a
(½ Mark for the output without space)
g
(iii) In a relational database,awhen the value of an attribute in a tuple is not
known, not available or not applicable, which special value is used to
represent it?
(A) ZERO (B) SPACE
(C) NULL (D) DEFAULT

Ans. (C)
OR
m
m NULL
.co
m .co (1 Mark for the correct answer)
s e m
s e (iv) Define e-Governance.
g la
g la a
a Ans. E-Governance or electronic governance is the use of electronic
information and communication technology (ICT) tools for governance
by the government for the citizens.
(1 Mark for the correct answer or any other relevant definition)

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 7
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 7 of 28

(v) Which of the following is not an advantage of using a DBMS?
(A) Reduction in data redundancy
(B) Improved data consistency
(C) Improved data availability
(D) Increased data duplication

Ans. (D)
OR
Increased data duplication
(1 Mark for the correct answer)

(vi) Mention one example of any web-based application.

Ans. Flipkart / Amazon / Facebook / Spotify / Canva
(1 Mark for the any correct option or any web-based application)

(vii) Which of the following is an invalid variable name in Java?
(A) Product_1 (B) marks
(C) Sales123 (D) total-Marks

Ans. (D)
OR
total-Marks
(1 Mark for the correct answer)

3. Answer any 6 out of the given 7 questions. 6x1 = 6

(i) Which of the following operators in Java is used to compare two values
for equality?
(A) = (B) ==
(C) != (D) >

Ans. (B)
OR
==
(1 Mark for the correct answer)

(ii) Which of the following is not a feature of a project?
(A) A project is complete when its end objectives are achieved.
(B) A project requires infinite resources.
(C) A project has a beginning and an end.
(D) A project has specific objectives.

Marking Scheme 802 (2025 - 26) Page No - 8

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 8 of 28

.
.co s e m

s em l a
a ag
Ans. (B)
OR
A project requires infinite resources.
(1 Mark for the correct answer)

(iii) Which of the following best describes webinars ?
(A) Pre-recorded video courses
m
om
(B) Text-based documents
. co
. c
(C) Real-time lectures with opportunities to ask questions
em
e m
(D) Interactive games for learning
l as
a
Ans. l(C)
s ag
agOR
Real-time lectures with opportunities to ask questions
(1 Mark for the correct answer)

(iv) Which loop in Java executes at least once even when the condition is
False?
m
Ans. do- while loop
m .co
s e
a
(1 Mark for the correct answer)

g l
(v) What is a major benefit a
of online learning?
(A) It only teaches how to use software.
(B) It allows learners to study at their own location, time and pace.
(C) It discriminates against students on the basis of age, caste and
qualification.
(D) It is only available in regional languages.

m
m Ans. (B)
.co
m .co OR
s e m
s e It allows learners to study at their own location, time and pace.
g la
g la (1 Mark for the correct answer) a
a (vi) How many bits of memory does a short type variable use in Java?

Ans. 16 bits
OR
2 bytes
(1 Mark for the correct answer)

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 9
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 9 of 28

(vii) State whether the following statement is True or False:

The following SQL command is used to delete a relation/table from a
relational database.

DELETE TABLE STUDENT;

Ans. False
(1 Mark for correct answer)

4. Answer any 5 out of the given 6 questions. 5x1=5

(i) State whether the following statement is True or False
If there is only one statement in the body of the for loop, the set of curly
braces enclosing the body can be omitted

Ans. True
(1 Mark for the correct answer)

(ii) Consider the following table
Table: Student
ID Name City Percentage

101 Rohan Delhi 76.50

102 Neha Mumbai 74.00

103 Aarav Delhi 74.00

104 Neha Jaipur 75.75

Which attribute can be chosen as the primary key for the above table?
(A) Name (B) City
(C) Percentage (D) ID

Ans. (D)
OR
ID
(1 Mark for the correct answer)

Marking Scheme 802 (2025 - 26) Page No - 10

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 10 of 28

.
.co s e m

s em l a
a ag
(iii) Which of the following correctly matches the website with the main
focus?
(A) w3schools.com - Humanities and Social Science courses
(B) coursea.org - Drag and drop website development tools
(C) ncert.nic.in - Online learning resources like e-books and journals

m
co
(D) udacity.org - Free grammar testing website

. c om e m .
Ans. (C )
em l as
OR
l as
ncert.nic.in - Online learning resources like e-books and journals ag
ag (1 Mark for the correct answer)

(iv) Which of the following is not an aggregate function in SQL?
(A) COUNT()
(B) MAX()
(C) SUM()
(D) UPDATE()

m
.co
Ans. (D)
OR
e m
UPDATE()
l as
(1 Mark for the correct definition)
a g
(v) In Java, which of the following statements is correct about exception
handling?

(A) A catch block can exist without a try block.
(B) Multiple catch blocks can follow a try block to handle different
types of exceptions.
m
m .co
(C) The finally block is executed only if an exception occurs in the try

m .co block.
s e m
s e l a
(D) If no exception occurs in the try block, the corresponding catch

g la block is executed. ag
a
Ans. (B)
OR
Multiple catch blocks can follow a try block to handle different types of
exceptions.
(1 Mark for the correct answer)

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 11
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 11 of 28

(vi) Which of the following is an application of Database Management
Systems (DBMS)?
(A) Storing students' academic records
(B) Creating digital paintings
(C) Playing audio and video files
(D) Writing fictional stories

Ans. (A)
OR
Storing students' academic records
(1 Mark for the correct answer)

5. Answer any 5 out of the given 6 questions. 5 x 1=5

(i) What do you understand by methods in Java?

Ans. A method is a named block of statements written to perform a specific
task.
OR
The method body is enclosed within a pair of curly braces and contains
the statements that the method will execute.
(1 Mark for the correct answer or any relevant answer)
(½ mark for an example only)

(ii) What is the purpose of WHERE clause in SQL?
(A) It adds a new column to a table.
(B) It filters rows on the basis of condition.
(C) It sorts the rows in ascending or descending order.
(D) It renames columns of the table.

Ans. (B)
OR
It filters rows on the basis of condition.
(1 Mark for the correct answer)

(iii) Mention the expanded form of IDE in the context of programming.

Ans. Integrated Development Environments
OR
Integrated Development Environment
(1 Mark for any correct answer)
(½ mark for any two correct words)

Marking Scheme 802 (2025 - 26) Page No - 12

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 12 of 28

.
.co s e m

s em l a
a ag
(iv) Which SQL command is used to modify the attribute values of one or
more tuples in a table?
(A) INSERT (B) UPDATE
(C) DELETE (D) SELECT

Ans. (B)
m
OR
om . co
. c e m
UPDATE
em l as
as
(1 Mark for the correct answer)
l ag
ag
(v) Which of the following statements is true about the switch statement
in Java ?

(A) The switch statement is used to execute a block of code based on
the value of an expression.
(B) The break statement is optional and has no effect on the execution
of a switch.
m
.co
(C) If no case matches, the program generates an error.
m
e
(D) A switch can have only one case statement.
s
l a
Ans. (A)
OR
ag
The switch statement is used to execute a block of code based on the
value of an expression
(1 Mark for the correct answer)

(vi) Which of the following correctly describes online shopping?
m
.co
(A) Customers can buy only books and electronics over the Internet.
m
.co
(B) Customers can browse items online, place them in a virtual basket
e m
e m
and make payment.
las
las (C) Customers can shop online, but must pay only in cash at delivery.
ag
g
(D) Customers can select items online, but cannot have them
a delivered.

Ans. (B)
OR
Customers can browse items online, place them in a virtual basket and
make payment.
(1 Mark for the correct answer)

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 13
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 13 of 28

6. Answer any 5 out of the given 6 questions. 5x1=5

(i) Which of the following is known as the National Portal of India?
(A) www.india.gov.in
(B) www.irctc.co.in
(C) www.goidirectory.nic.in
(D) www.w3schools.com

Ans. (A)
OR
www.india.gov.in
(1 Mark for the correct answer)

(ii) Which of the following statements is true about using the RESTRICT
option while dropping a column in SQL?
(A) The column is dropped even if it is referenced in other tables.
(B) The column cannot be dropped if it is being referenced in other tables.
(C) The column is renamed instead of being dropped.
(D) The column is dropped along with all dependent objects automatically.

Ans. (B)
OR
The column cannot be dropped if it is being referenced in other tables.
(1 Mark for the correct answer)

(iii) In Java, which operator is used to access the data members and
method members of an object?
(A) equal (=) operator (B) plus (+) operator
(C) dot (.) operator (D) comma (,) operator

Ans. (C)
OR
dot (.) operator
(1 Mark for the correct answer)

(iv) Which SQL clause is used to sort data in ascending or descending
order?

(A) Order By (B) Sort By
(C) Group By (D) Arrange By

Marking Scheme 802 (2025 - 26) Page No - 14

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 14 of 28

.
.co s e m

s em l a
a ag
Ans. (A)
OR
Order By
(1 Mark for the correct answer)

(v) In the Requirement Definition Phase of a Web Application Project,
m
om
defining the scope involves:
. co
. c
(A) Designing the user interface
e m
em features, goals, and project limitations l as
s
(B) Listing

l(C)a Writing and testing code ag
g
a (D) Deploying and managing the website
Ans. (B)
OR
Listing features, goals, and project limitations
(1 Mark for the correct answer)
m
(vi) .co
Consider the Java statement Book book1=new Book(); where Book is
m
s e
a class. What is the role of the new keyword in the statement?
l a
agto create an object of the class Book.
Ans. The new keyword is used
OR
The new keyword is used to allocate memory to an object of class
Book.
OR
The new keyword is used to create an instance of class Book.
m
m .co
(1 Mark for the correct answer or any other relevant answer)

m .co s e m
s e g la
g la a
a

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 15
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 15 of 28

SECTION B
(Subjective Type Questions) (30 Marks)

Answer any 3 out of the given 5 questions on Employability Skills. Answer each 3x2=6
question in 20-30 words.

7. "Listening skill is one of the most important skills in communication." 2
Mention any two points to support this statement.

Ans. Listening skill is one of the most important skill in communication
because it helps :
● To obtain information - Listening allows us to gather important
information during a conversation.
● To understand - Attentive listening ensures that messages are
not misunderstood
● To enjoy - Attentive listening allows us to enjoy the messages or
information
● To learn - Attentive listening allows us to learn and implement
information
● To build and maintain relationships and to resolve conflicts.

(1 Mark each for mentioning any two correct points)

8. Mention the steps to start LibreOffice Calc in Windows Operating 2
System.

Ans. Steps to start LibreOffice Calc:
Step - 1 : Click on Start button in the Task Bar
Step -2 : Select All Programs
Step -3 : Select Libre Office
Step -4 : Click on Libre Office Calc
OR
Step - 1 :Type LibreOffice Calc in Windows search bar.
Step - 2 :Select LibreOffice Calc from the search results. LibreOffice
Calc will open a blank spreadsheet.
OR
Step -1 : Double-Click on LibreOffice Calc Icon on the Desktop.
(2 Marks for correct answer or any relevant method)

Marking Scheme 802 (2025 - 26) Page No - 16

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 16 of 28

.
.co s e m

s em l a
a ag
9. Define green jobs and state any one benefit of green jobs. 1+1=2

Ans. A green job is defined as one that helps bring about and maintain
transition to environmentally sustainable forms of production and

m
consumption.

om
Benefits of green jobs
. co
. c
● increase the efficiency of energy and raw material. e m
m
e reduce greenhouse gas emissions. l as
as●
l ● control waste and pollution. ag
g
a ● protect and restore ecosystems.
● support adaptation to the effects of climate change.
(1 Mark for the correct definition /relevant definition)
(1 Mark for any correct benefit/ relevant benefit of green jobs)

om
10 Write two benefits of having a positive attitude. 2

m .c
s e are:
Ans. Benefits of having a positive attitude
● Makes a person happier
g l a
● Helps to build and a maintain relationships
● Increases chances of success
● Better decision making Improve mental and physical health
(1 Mark each for mentioning any two correct points / any relevant
points)

m
m .co
.co em
11 Write any two benefits of goal setting by an entrepreneur. 1+1=2

em l as
las Ans. Benefits of goal setting by an entrepreneur :
ag harder.
ag ● Goal setting motivates the entrepreneur to work
● It provides direction and helps put in more effort to reach the goal.
● It gives fulfillment and pride.
● It sets a clear benchmark for success.

(1 Mark each for mentioning any two correct points / any relevant
points)

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 17
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 17 of 28

Answer any 3 out of the given 5 questions in 20-30 words each. 3x2=6

12 Write the output of the following Java code: 2
public class SumClass {
public static void main(String[] args) {
int x, y, sum;
x= 5;
y = 5;
sum = x + y++;
System.out.println("y = " + y );
System.out.println("sum = ” + sum );
}
}

Ans. y = 6
sum = 10
(1 Mark for each correct line)
(½ mark to be deducted if only values are given)

13 Write one similarity and one difference between CHAR and VARCHAR 1+1=2
data types in SQL.

Ans. Similarity : Both CHAR and VARCHAR store character strings (text data)
in a database.
Difference : CHAR is of fixed length , while VARCHAR is of variable
length.
OR
CHAR datatype leads to memory wastage whereas VARCHAR does not
waste memory.
(1 Mark for the correct similarity / relevant answer)
(1 Mark for the correct difference/ relevant answer)

14 Mention any two uses of database management systems in banking 1+1=2
sector.

Marking Scheme 802 (2025 - 26) Page No - 18

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 18 of 28

.
.co s e m

s em l a
a ag
Ans. Two uses of database management system in banking sector:
● Storing customer information (personal details, accounts,
transactions)
● Storing employee details (salary, leaves, joining date)
● Organizing data efficiently
● Ensure high level data security
m
● Transaction Integrity
om . co
● Instantaneous data retrieval for many users simultaneously
. c e m
em
● Enable real-time consistency in transactions
l as
l as● 24x7 availability
ag
ag ● Robust backup / recovery to prevent data loss
(1 Mark each for mentioning any two correct points / any other
relevant points )

15 Write a Java program to perform the following tasks: 2
● Store an employee's basic salary of ₹50,000 in a variable named
basicSalary.

m
● Calculate the dearness allowance (DA) as 50% of the basic

.co
salary and store it in a variable named allowance.
m
e
● Add the dearness allowance to the basic salary to compute the
s
l a
total salary and store the result in a variable named totalsalary.

ag
● Display the value of total salary.

Ans. public class EmpoyeeSalary{
public static void main(String[] args) {
int basicSalary = 50000; //step-1
int allowance = 50/100 * basicSalary; //step-2
int totalSalary = basicSalary + allowance; //step-3
System.out.println(totalSalary); //step-4
m
.co
}
m
.co m
}

m s e
e la
(½ Mark for each correct step)

las (Note: Ignore data type for the variables)
ag
ag 16 (a) Write SQL query to display the list of all the tables stored in a database 1+1=2

Ans. SHOW TABLES;
(1 Mark for the correct query statement)
(Note: Ignore cases and semicolon)

(b) Define Primary Key with respect to DBMS.
m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 19
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 19 of 28

Ans. A Primary Key is a column (or a set of columns) in a table/relation that
uniquely identifies each record. It does not allow NULL values.
(1 Mark for the correct definition/ any relevant definition)

Answer any 2 out of the given 3 questions in 30 - 50 words each. 2x3=6

17 Consider the following table Employee: 1+1+1
Table: Employee =3
EmpID Name Department Salary

101 Rajesh HR 50000

102 Anjali IT 60000

103 Suresh Finance 55000

104 Priya Marketing 52000
Write the SQL commands to:

(a) Update the Name of the employee with EmpID 102 to "Ananya"

Ans. UPDATE Employee SET Name = “Ananya” WHERE EmpID = 102;
(1 Mark for the correct query statement)
(½ Mark for UPDATE keyword and ½ for correct WHERE clause)

(b) Display the structure of the Employee table.

Ans. DESC Employee;
OR
DESCRIBE Employee;
(1 Mark for the correct query statement)
(½ Mark for DESCRIBE or DESC keyword Only)

(c) Add a new column JoiningDate of type DATE to the Employee table.

Ans. ALTER TABLE Employee ADD JoiningDate DATE;
OR
ALTER TABLE Employee ADD COLUMN JoiningDate DATE;
(1 Mark for the correct query statement)
(½ Mark for ALTER TABLE keyword and ½ for correct ADD clause)

Marking Scheme 802 (2025 - 26) Page No - 20

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 20 of 28

.
.co s e m

s em l a
a ag
18 Rewrite the following Java program using while loop: 3
public class Monuments {
public static void main(String[] args) {
for (int i = 0; i < 5; i++) {
if (i % 2 == 0)
m
co
System.out.println("Monument-1: Taj Mahal");
m .
c. oSystem.out.println("Monument-2: Gateway of
else
s e m
e m l a
l as India"); ag
ag System.out.println("Monuments of India");
}
}
}

public class Monuments {
m
.co
Ans.
public static void main(String[] args) {
int i=0; //step - 1
e m
while(i < 5){
l as
//step - 2
if (i % 2 == 0)
ag
System.out.println("Monument-1: Taj Mahal");
else
System.out.println("Monument-2: Gateway of
India");
System.out.println("Monuments of India");
i++; //step - 3
}
m
m .co
.co m
(1 Mark for each correct step)

m s e
s e g la
g la a
a

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 21
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 21 of 28

19 A group of students is developing a Hospital Management System as 3
their project. Ravi, one of the project members, has been assigned
database-related tasks. He needs to create a table named Patient with
the following schema:
Schema: Patient (PatientID, PatientName, DateOfBirth)
Note: PatientID is a 5-digit number.
Help Ravi by completing the table given below. Write the Attribute Name
in the first column and corresponding appropriate Data Type in the
second column.
Attribute Name Data Type

Ans.
Attribute Name Data Type

PatientID INT(5) / CHAR(5)

PatientName VARCHAR(20) /
CHAR(20)

DateOfBirth DATE

(1 Mark each for data type for corresponding attribute name )

Answer any 3 out of the given 5 questions in 50-80 words each. 3x4=12

20 (a) The following Java code contains errors. Rewrite it correctly, clearly 2+2=4
underlining all the corrections made:
public class JavaProg {
public static void main(String[] args) {
int a = 0;
b = 15;
do (
a = a + 3;
b = b - 3;
) While (a <= b)
}
}

Marking Scheme 802 (2025 - 26) Page No - 22

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 22 of 28

.
.co s e m

s em l a
a ag
Ans. public class JavaProg {
public static void main(String[] args) {
int a = 0;
int b = 15;
do {
a = a + 3;
m
co
b = b - 3;

om .
} while (a <= b);
. c e m
s
}
em l a
s
}

l a
Correction - 1: b =15; changed to int b = 15;
ag
ag Correction - 2: do ( changed to do {
Correction - 3: While changed to while
Correction - 4: Added semicolon after while (a <= b)
(½ Mark for each correction)

(b) What will be the output of the following Java program when executed?
public class CalculateN {
public static void main(String[] args) {
m
.co
int n = 0, m = 4;

m
for (int i = m+5; i >= 6; i-- ) {
if (i % 3 == 0) {
s e
l a
ag
n = n + i;
} else {
n = n - i ;
}
System.out.println("n = " + n);
}
}
}

m
.co
Ans. n = 9
m
m .co n=1
s e m
s e n = -6
g la
g la n=0 a
a (½ Mark each for correct line of output)
OR
(1 Mark if the values are given without mentioning n)
(Note: Deduct ½ marks if the output is given in one line)

21 (a) Write any two advantages of using Online Reservation System. 4

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 23
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 23 of 28

Ans. Advantages of online reservation system are:
● Convenience
● Price comparison
● Security
● Confirmation of reservation
● Cost and Time saving
● Discount scheme
● 24/7 availability
● Real-Time Efficiency
● Wider reach and selection
● Global Access

(1 Mark for any two correct points)

(b) Mention any two precautions that should be taken while performing
Online Transaction.

Ans. Two precautions that should be taken while performing online
transactions are:
● Use Strong Passwords : Combine uppercase, lowercase,
numbers, and special characters.
● Keep Passwords Confidential : Do not share or leave them
unattended.
● Avoid Personal Names as password : Do not use names of
family or friends as password.
● Be careful about fraudulent websites.
● Do not share confidential information with anyone.

(1 Mark for any two correct points)

22 Explain the following terms in context of Java: 4
(a) Class
(b) Exception
(c) Array
(d) Constructor

Marking Scheme 802 (2025 - 26) Page No - 24

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 24 of 28

.
.co s e m

s em l a
a ag
Ans. (a) Class: A class is an entity that has attributes (data members) and
methods (behavior).

OR
It is a template from which objects are created.

OR
m
Eg. Book book1=new Book();
om . co
. c e m
e m
(b) Exception: An event that disrupts normal program flow and causes
l as
as
the program to terminate unexpectedly.
lOR ag
g
a An error situation that is unexpected in the program execution and
causes it to terminate unexpectedly.

OR
Run-time Error.

OR
Eg. try {
m
int[] myNumbers = {1, 2, 3};
m .co
e
System.out.println(myNumbers[10]);
} catch (Exception e) {
l as
ag
System.out.println("Something went wrong.");
}

(c) Array: A collection of elements of the same data type stored in
contiguous memory.

OR
Arrays are variables that can hold more than one value of the same data
type.
m
m OR
.co
m .co int[] myNumbers = {1, 2, 3};
s e m
s e (d) Constructor: Special method that is called automatically when an
g la
g la object is created.
a
a OR
It is used to initialize objects when they are created.
OR
Constructor is a method that has the same name as class name with no
return type.

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 25
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 25 of 28

OR
Eg. Book book1=new Book();

(1 Mark for each correct definition/ any other relevant definition)
OR
(½ mark each if only example given)

23 (a) What will be the output of the following Java program when executed? 2 + 2=4
public class StringOperations {
public static void main(String[] args) {
String mystring = "JavaProgram";
System.out.println(mystring.toLowerCase() );
System.out.println(mystring.replace("Java",
"Python-") );
}
}

Ans javaprogram

Python-Program

(1 Mark for each correct line of output )

(b) Write a user-defined Java method circleArea() that takes the radius of
the circle as input and returns its area

(Note: take the value of Pi(𝛱) 𝑎𝑠 3.14)

Ans. public static double circleArea(double radius)

{
double Pi=3.14;
double area = Pi * radius * radius;
return area;
}

OR

Marking Scheme 802 (2025 - 26) Page No - 26

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 26 of 28

.
.co s e m

s em l a
a ag
public static double circleArea(double radius)
{
double area = 3.14 * radius * radius;
return area;
}

m
(½ Mark for correct function header with parameter)

om
(½ Mark for declaring the Variable(s))
. co
. c e m
em
(½ Mark for giving correct statement to calculate area)
l as
l as
(½ Mark for correct return statement)
ag
24
g
a Consider the following table STOCK: 1+1+1
+1=4
Table:STOCK
ItemNo ItemName DealerCode Qty UnitPrice

5001 ERASER SMALL 103 120 5

om
5002 GEL PEN PREMIUM 101 125 25

5003 BALL PEN 0.25 . c 102 150 15
e m
5006 ERASER BIG
l as 103 100 10

5009 g
BALL PENa0.5 102 100 10

5015 GEL PEN CLASSIC 101 200 20

5019 SHARPENER CLASSIC 104 110 5

Write SQL queries for the following requirements:

m
.co
(a) Retrieve all details of items from STOCK table, stored in ascending
m
c. o Ans. SELECT * FROM STOCK ORDER BY UnitPrice;
order of UnitPrice.
e m
e m las
las (1 Mark for the correct Query)
ag
ag OR

(½ Mark for correct SELECT and ½ Mark for correct WHERE
clause)

(b) Display ItemNo and ItemName for those items in the Stock table
whose QTY exceeds 102

m . c
c. o
Marking Scheme 802 (2025 - 26) Page No - 27
s e m
s em
For more Question Papers, Sample Papers, Notes & Syllabus visit
gl a
Page 27 of 28

Ans. SELECT ItemNo, ItemName FROM STOCK WHERE Qty > 102;
(1 Mark for the correct Query)

OR

(½ Mark for correct SELECT and ½ Mark for correct WHERE
clause)

(c ) Retrieve all details of items from the STOCK table, where Dealercode
is 102 or UnitPrice is less than 20

Ans. SELECT * FROM STOCK WHERE Dealercode = 102 OR
UnitPrice < 20;
(1 Mark for the correct Query)
OR
(½ Mark for correct SELECT and ½ Mark for correct WHERE
clause)

(d) Display each Dealercode along with the count of ItemName supplied
by that dealer

Ans. SELECT Dealercode, count(ItemName) FROM STOCK GROUP BY
ItemName;

(1 Mark for the correct Query)
OR
(½ Mark for correct SELECT and ½ Mark for correct GROUP BY
clause)

Marking Scheme 802 (2025 - 26) Page No - 28

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 28 of 28