CBSE Class 12 Question Paper 2025 Solution Information Technology

Marking Scheme
Strictly Confidential
(For Internal and Restricted use only)
Senior School Certificate Examination, 2025
SUBJECT NAME INFORMATION TECHNOLOGY (Q.P. CODE 326)
SUBJECT CODE – 802

General Instructions: -

1 You are aware that evaluation is the most important process in the actual and
correct assessment of the candidates. A small mistake in evaluation may lead to
serious problems which may affect the future of the candidates, education
system and teaching profession. To avoid mistakes, it is requested that before
starting evaluation, you must read and understand the spot evaluation guidelines
carefully.

2 “Evaluation policy is a confidential policy as it is related to the
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. may invite action under
various rules of the Board and IPC.”

3 Evaluation is to be done as per instructions provided in the Marking Scheme. It
should not be done according to one’s own interpretation or any other
consideration. Marking Scheme should be strictly adhered to and religiously
followed. However, while 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.

4 The Marking Scheme carries only suggested value points for the answers.
These are in the nature of Guidelines only and do not constitute the complete
answer. The students can have their own expression and if the expression is
correct, the due marks should be awarded accordingly.

5 The Head-Examiner must go through the first five answer books evaluated 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.

Marking Scheme 802 (2024 - 25) Page No - 1

Evaluators will mark( √ ) wherever answer is correct. For wrong answer CROSS
6
✓)
“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.

7 If a question has parts, please award marks on the right-hand side for 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.

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

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

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

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

12 Every examiner has to necessarily do evaluation work for full working 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.

13 Ensure that you do not make the following common types of errors 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 book to
the title page.
● Wrong question wise totaling on the title page.
● Wrong totaling of marks of the two columns on the title page.
● Wrong grand total.
● Marks in words and figures not tallying/not same.
● Wrong transfer of marks from the answer book to online 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.

Marking Scheme 802 (2024 - 25) Page No - 2

14 While evaluating the answer books if the answer is found to be totally incorrect, it
should be marked as cross (X) and awarded zero (0)Marks.

15 Any unassessed portion, non-carrying over of marks to the title page, or totaling
error detected by the candidate shall damage the prestige of all 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.

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

17 Every Examiner shall also ensure that all the answers are evaluated, marks
carried over to the title page, correctly totaled and written in figures and words.

18 The candidates are entitled to obtain photocopy of the Answer Book on request
on payment of the prescribed processing fee. All 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.

Marking Scheme 802 (2024 - 25) Page No - 3

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

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 and ignore case in Java
related codes written by students.

Marking Scheme 802 (2024 - 25) Page No - 4

Section A
(Objective Type Questions)​ (30 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills. 4x1=4

(i) _____________ is an element of communication which encodes and sends 1
messages through a channel.

Ans. Sender
(1 Mark for the correct answer)

(ii) To maintain a positive attitude, which one of the following is not a good 1
practice ?
(A) Feed the mind with positivity
(B) Don’t learn from failures.
(C) Move towards your goals and dreams
(D) Start the day with a morning routine

Ans (B)
OR
Don’t learn from failures.
(1 Mark for the correct answer)

(iii) State True or False : “Personality disorders involve long-term patterns of 1
thoughts and behaviours that are unhealthy and rigid”.

Ans True/T
(1 Mark for any correct answer)

(iv) In the spreadsheet software, a _____________ is an arrangement of cells in a 1
vertical (standing) manner.

Ans Column
(1 Mark for the correct answer)

Marking Scheme 802 (2024 - 25) Page No - 5

(v) _____________ is one of the most important attitudes of an entrepreneur, 1
which is defined as the ability to continue to do something, even when it is
difficult.
(A) Decisiveness
(B) Interpersonal skills
(C) Perseverance
(D) Taking initiative

Ans (C)
OR
Perseverance
(1 Mark for the correct answer)

(vi) CNG stands for _____________ . 1

Ans Compressed Natural Gas
(1 Mark for the correct answer)
OR
(½ Mark for writing any two correct words)

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

(i) DBMS stands for _____________ . 1

Ans Database Management Software/System
(1 Mark for the correct answer)
OR
(½ Mark for writing any two correct words)

(ii) All Java statements must end with a/an _____________ . 1

Ans Semicolon
OR
(;)
(1 Mark for the correct answer)

Marking Scheme 802 (2024 - 25) Page No - 6

(iii) _____________ is a language that is used to manage data stored in an 1
RDBMS.

Ans SQL / MYSQL
(1 Mark for the correct answer)

(iv) In relational models, a _____________ is called a relation. 1

Ans Table
(1 Mark for the correct answer)

(v) IRCTC online portal for booking train tickets stands for : 1
(A) International Railway Catering and Tourism Corporation
(B) Indian Railway Controlling and Transport Corporation
(C) Indian Railway Catering and Tourism Corporation
(D) International Railway Controlling and Transport Corporation

Ans (C)
OR
Indian Railway Catering and Tourism Corporation
(1 Mark for the correct answer)

(vi) Which of the following is not a valid data type of SQL ? 1
(A) CHAR(n) (B) VARCHAR(n)
(C) STR(n) (D) DATE

Ans (C)
OR
STR(n)
(1 Mark for the correct answer)

(vii) A web application is a program that is stored on a _____________ server. 1
(A) Remote (B) Voice
(C) Local (D) Data

Marking Scheme 802 (2024 - 25) Page No - 7

Ans (A)
OR
Remote
(1 Mark for the correct answer)

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

(i) Name any two popular e-learning websites. 1

Ans Coursera, Udemy, Unacademy, Khanacademy, W3Schools, ncert.nic.in,
edx.org, physicswallah, gcflearnfree etc.
(1 Mark for any two correct answers / relevant e-learning
websites)
OR
(½ Mark for any one correct answer / relevant e-learning website)

(ii) A computer can understand only its own language called _____________ . 1

Ans Machine Language / Binary Language / 0,1 language
(1 Mark for any correct answer)

(iii) Kritika did not use ASC or DESC keyword with ORDER BY clause. By 1
default in which order will the result of the query be displayed ?

Ans Ascending Order / ASC
(1 Mark for any correct answer)

(iv) _____________ is the national web portal of India, which provides a single 1
window access to information and services being provided by the various
Indian government entities.

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

Marking Scheme 802 (2024 - 25) Page No - 8

(v) Rahul forgot to add a column in the existing table. Which one of the following 1
SQL commands can he use to add the desired column in the table ?
(A) INSERT
(B) UPDATE
(C) MODIFY
(D) ALTER

Ans (D)
OR
ALTER
(1 Mark for the correct answer)

(vi) _____________ makes the password safer for online transactions. 1
(A) Combination of alphabets, special symbols and numbers
(B) Use of personal mobile number
(C) Use of name of near and dear ones
(D) Use of date of birth of mother

Ans (A)
OR
Combination of alphabets, special symbols and numbers
(1 Mark for the correct answer)

(vii) “ Variables in Java need not be declared and initialized before they are used”. 1
State True or False.

Ans False/F
(1 Mark for any correct answer)

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

(i) Connectivity between Frontend and Backend project will be done in 1
_____________ phase of a web application project.

Ans Implementation
(1 Mark for the correct answer)

Marking Scheme 802 (2024 - 25) Page No - 9

(ii) If the value of an attribute in a tuple is not known or not applicable or not 1
available, a special value called _____________ is used to represent them.
(A) EMPTY
(B) BLANK
(C) NULL
(D) VOID

Ans (C )
OR
NULL
(1 Mark for the correct answer)

(iii) In India the main thrust for e-governance was provided by the launching of 1
_____________, the national satellite-based computer network in 1987.
(A) NICNET
(B) DEITY
(C) NEGP
(D) NEGD

Ans (A)
OR
NICNET
(1 Mark for the correct answer)

(iv) What is a variable in Java programming language ? 1

Ans A variable is a placeholder for data that can change its value during program
execution.
(1 Mark for the correct definition)
OR
int a = 10;
(½ Mark for any correct example)

(v) _____________ keyword is used in SELECT statement along with column 1
name to display duplicate values once in the result of an SQL query.

Ans Distinct
(1 Mark for the correct answer)

Marking Scheme 802 (2024 - 25) Page No - 10

(vi) Select the valid statement to declare and initialize an array in Java : 1
(A) int[] marks;
(B) int[] marks = {60, 70, 90};
(C) int[] marks = (60, 70, 90);
(D) int[] marks = [60, 70, 90];

Ans (B)
OR
int[] marks = {60, 70, 90};
(1 Mark for the correct answer)

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

(i) Which of the following statements is incorrect related to database application 1
used in the domains?
(A) Education Database Application is used to store data of students and staff.
(B) Hospital Database Application is used to record data of patients.
(C) Banking Database Application is used to record details of stock of
medicines.
(D) Government Database Application is used to store details of electoral roll.

Ans (C)
OR
Banking Database Application is used to record details of stock of medicines.
(1 Mark for the correct answer)

(ii) Out of many types of DBMS users, _____________ is responsible to 1
determine the requirements of the end users and then develop specifications to
meet the requirements.
(A) DBA
(B) Application Programmers
(C) System Analyst
(D) Tester

Marking Scheme 802 (2024 - 25) Page No - 11

Ans. (C)
OR
System Analyst
(1 Mark for the correct answer)

(iii) Exception thrown by any statement in try block in a Java program is handled 1
in _____________ block.
(A) final (B) throw
(C) catch (D) except

Ans (C)
OR
catch
(1 Mark for the correct answer)

(iv) Rashmi is not able to leave a blank in the Salary column of the Employee 1
table. Which constraint is applied on the field Salary?
(A) NOT NULL (B) DEFAULT
(C) CHECK (D) NOT BLANK

Ans (A)
OR
NOT NULL
(1 Mark for the correct answer)

(v) Which is the correct way to write multiline comments in a Java program ? 1
(A) Beginning a comment line with two consecutive forward slashes(//).
(B) Writing a comment between the symbols /* and */.
(C) Beginning a comment line with # symbol.
(D) Writing the comment between the symbols /# and #/.

Marking Scheme 802 (2024 - 25) Page No - 12

Ans (B)
OR
Writing a comment between the symbols /* and */.
(1 Mark for the correct answer)

(vi) Name the Java interpreter that translates the byte code into machine code and 1
then executes it.

Ans JVM
OR
Java Virtual Machine
(1 Mark for any correct answer)
OR
(½ Mark for writing any two correct words)

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

(i) Which access modifier in Java is used to make a data member or a method 1
member of a class visible only within the class ?
(A) public (B) protected
(C) default (D) private

Ans (D)
OR
private
(1 Mark for the correct answer)

(ii) Flipkart and eBay are examples of _____________ shopping stores. 1

Ans Online
OR
E/e
OR
e-Commerce
(1 Mark for any correct answer)

Marking Scheme 802 (2024 - 25) Page No - 13

(iii) Write the names of any two web browsers which help us to browse various 1
websites over the Internet.

Ans Internet Explorer / Google Chrome / Mozilla Firefox / Opera / Brave / Vivaldi /
Maxthon etc.
(1 Mark for any two correct answers/relevant web browsers )
OR
(½ Mark for any one correct answer/relevant web browser)

(iv) A/An _____________ in Java is a block of statements grouped together to 1
perform a specific task.
(A) Array (B) Object
(C) Class (D) Method

Ans (D)
OR
Method
(1 Mark for the correct answer)

(v) In Java, _____________ statement is used to execute a block of code matching 1
one value out of many possible values.

Ans switch
OR
switch .. case
(1 Mark for the correct answer)

(vi) In which Java package is the scanner class available ? 1
(A) java.util (B) java.applet
(C) java.net (D) java.lang

Ans (A)
OR
java.util
(1 Mark for the correct answer)

Marking Scheme 802 (2024 - 25) Page No - 14

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. What is a Green Job ?

Ans A green job is defined as one that helps bring about and maintain transition to 2
environmentally sustainable forms of production and consumptions. It cuts
across all sectors energy material, water conservation, waste management and
pollution control.
OR
Green jobs are the jobs that help protect the environment and support
sustainable development.
(2 Marks for any correct/relevant answer)
OR
Organic Farmers/Solar Panel Installers/Waste Management Engineers/Green
Building Architects/Environmental Consultants/Green Vehicle Engineers
(1 Mark for the any correct example/relevant example)

8. To create a digital presentation, suggest the names of any two popular 2
presentation softwares.

Ans
●​ LibreOffice Impress
●​ MS PowerPoint
●​ OpenOffice Impress
●​ Google slides
●​ Prezi
●​ Apple Keynote

Marking Scheme 802 (2024 - 25) Page No - 15

●​ Lotus Freelance
(2 Marks for any two correct answers /relevant answers)
OR
(1 Mark for any one correct answer /relevant answer)

9. Briefly explain the following terms : 2

Ans Personality
(a)
Personality: It is a cluster of thoughts, feelings and behaviours that make a
person unique and different from others.

Personality is a stable collection of characteristics - emotional, behavioral and
mental traits.

(1 Mark for the correct definition /relevant definition)

(b) Personality traits
Personality traits : These are defined as relatively lasting patterns of thoughts,
feelings and behaviours that distinguish individuals from one another.
According to trait theory , the five traits are - Extraversion(sociable,quiet),
Agreeableness(Cooperative , warm) , Conscientiousness (hard working,
organized), Emotional Stability(calm, self confident) and
Openness(creative,curious) .
(1 Mark for the correct definition /relevant definition)

10 Mention any four most common environmental barriers which an entrepreneur 2
may face while running his/her venture.

Ans
●​ Lack of adequate resources or raw material
●​ Non-availability of skilled labour
●​ Lack of requisite machinery and other infrastructure
●​ Unavailability of monetary resources on time
●​ Natural disasters

Marking Scheme 802 (2024 - 25) Page No - 16

●​ Climate change
●​ Pollution
●​ Global Warming
(½ Mark each for any correct environmental barrier /relevant
answer)

11 Briefly explain any two factors that affect active listening. 2

Ans The various factors that affect active listening are as follows:
Eye contact : It is a form of body language. It is one of the most important
aspects in the communication process. Maintaining eye contact with the person
you are talking to sends a signal to the speaker that “Yes, I am talking to you or
listening to you”. Avoiding eye contact could mean that you do not want to listen
to the person speaking to you.

Gestures : These indicate to the speaker if you are listening or not. Keep your
hands and feet still while talking to someone.

Avoiding distractions : You need to identify the things that distract you. You
must physically remove the distractions in order to listen attentively. For
example, reducing the ringtone of your mobile phone or switching it off while
attending a meeting or listening to someone will avoid distraction. Another
example is that you should avoid glancing at the wristwatch frequently.

Giving feedback : Feedback can be positive or negative. But in both the cases,
one needs to be polite so that the person to whom the feedback is being given is
not hurt or offended.
(2 Marks for any two correct factors /relevant factors)
OR
(1 Mark for any one correct factor /relevant factor)

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

Marking Scheme 802 (2024 - 25) Page No - 17

12 What will be the output of the following Java statements : 2

Ans (a) System.out.println ("30 + 20");
Output:
30 + 20
(1 Mark for any correct output)

(b) System.out.println ("Information Technology" + 802);
Output:
Information Technology802
(1 Marks for correct output)

13 Write any two characteristics of Database Management System. 2

Ans
●​ Self describing nature of database system.
●​ Insulation between program & data.
●​ Sharing of data.

(2 Marks for any two correct / relevant characteristics)
OR
(1 Mark for any one correct / relevant characteristic)

14 What is the purpose of % and _ (underscore) characters used with LIKE 2
operator in SQL?

Ans
% (percent) replaces zero or more number of characters.

_(underscore) replaces a single character

OR
Select * from teachers where name like “S%”;
Select * from teachers where name like “S____”;
(2 Marks for both correct explanation)
OR

Marking Scheme 802 (2024 - 25) Page No - 18

(1 Mark for any one correct explanation)
OR
(½ Mark each for two correct examples using % or _ )

15 What is Java IDE ? Name any one commonly used Java IDE. 1+1

Ans Java Integrated Development Environment (IDE) is software that comes
equipped with a text editor and java compiler which simplify writing, compiling
and executing java programs.
Commonly used IDE are Netbeans, Blue J, Eclipse, etc.
(1 Mark for the correct definition)
(1 Mark for any one of the IDE’s)

16 List any two ways in which database application is used in the Banking Sector. 2

Ans Use of Database Application in Banking sector :
●​ To store information about customer,
●​ For storing employees details,
●​ To check and make banking transaction records.
(2 Marks for any two correct uses / relevant uses)
OR
(1 Mark for any one correct use / relevant use)

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

17 Write a Java program to calculate and display the factorial of a number 5 using 3
for loop.

Ans int f = 1;
for(int i = 1; i <= 5; i++)
{
f = f * i;
}
System.out.println("Factorial is : " + f);
OR
int f = 1;

Marking Scheme 802 (2024 - 25) Page No - 19

for(int i = 5; i >= 1; i- -)
{
f = f * i;
}
System.out.println("Factorial is : " + f);
(½ Mark for initialization of f with 1)
(1 mark for correct usage of for loop- initialization,condition and
increment/decrement)
(½ marks for the expression)
(1 mark for output statement)

18 Explain the use of any three aggregate functions in SQL. 3

Ans
(i) SUM(): It finds the sum of all the values for a selected attribute which have
numeric datatype.

(ii) COUNT(): It is used to count the number of tuples.

(iii) MAX(): It finds the maximum value out of the selected attribute which has
a numeric datatype.

(iv) MIN(): It finds the minimum value out of the selected attribute which has
a numeric datatype.

(v) AVG(): It finds the average value out of the selected attribute which has
numeric datatype.

OR

●​ Select SUM(salary) from teachers;
●​ Select MAX(salary) from teachers;
●​ Select MIN(salary) from teachers;
●​ Select AVG(salary) from teachers;
●​ Select COUNT(name) from teachers;
(1 Mark each for any three correct functions)
OR

Marking Scheme 802 (2024 - 25) Page No - 20

(½ Mark each for any three correct examples without explanation)

19 Varun is the owner of New Trends Fashion Company that deals in garments. He 3
wants to make a Database Application for his company. Suggest any six possible
entities that can be used in the database for his website.

Ans ●​ Customer
●​ Stock
●​ Order
●​ Product
●​ Shipment
●​ Seller
●​ Employees
●​ Wishlist
●​ Suppliers
●​ Payroll
(½ Mark each for any six correct entities / relevant entities)

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

20 Consider the following string variables : 1+1+1+
String str1 = "Hello"; 1

String str2 = "Java Programming";
Write the code statements for the following in Java :

(a) To display the string str1 into upper case.

System.out.println(str1.toUpperCase());

(1 Mark each for correct java code statement)
OR
(½ Mark each for mentioning the correct method name)
OR

Marking Scheme 802 (2024 - 25) Page No - 21

(½ Mark each for mentioning System.out.println)

(b) To display the character at the index 6 in string str2.

System.out.println(str2.charAt(6));

(1 Mark each for correct java code statement)
OR
(½ Mark each for mentioning the correct method name)
OR
(½ Mark each for mentioning System.out.println)

(c) To display the index of the first occurrence of letter ‘l’ in the string str1.

System.out.println(str1.indexOf('l'));

(1 Mark each for correct java code statement)
OR
(½ Mark each for mentioning the correct method name)
OR
(½ Mark each for mentioning System.out.println)

(d) To display the string str1 after replacing letter ‘l’ with '*'.

System.out.println(str1.replace('l','*'));

(1 Mark each for correct java code statement)
OR
(½ Mark each for mentioning the correct method name)
OR
(½ Mark each for mentioning System.out.println)

21 Differentiate between Entry controlled loop and Exit controlled loop. 4

Ans

Marking Scheme 802 (2024 - 25) Page No - 22

Entry controlled loop Exit controlled loop

Test condition is checked first and Loop body will be executed first and
then loop body will be executed the test condition is checked.

If the test condition is false, the loop If the test condition is false, the loop
body will not be executed. body will be executed at least once.

This loop is used when checking of This loop is used when checking the
test condition is mandatory before test condition is mandatory after
executing the loop body executing the loop body.

Example - for loop and while loop. Example is do..while loop.

(1 Mark for each correct comparison)

22 Explain any four advantages of online learning. 4

Ans Advantages :
●​ Easy to access as per convenience.
●​ Reduced cost
●​ Build confidence
●​ Huge variety of options available
●​ Better Time Management
●​ Global Access & certification
●​ Economical
●​ Repetitive access
●​ Advancement in career
●​ Opportunity to learn new skills at any age & time
●​ No discrimination of caste, gender and background
●​ Customizable learning environment.
●​ Multilingual Communication
●​ Self-Paced

Marking Scheme 802 (2024 - 25) Page No - 23

(4 Marks for any four correct / relevant advantages )

23 (a) What are the different ways to create threads in Java programming ? 2+2
(b) With reference to Java programming language, define assertion. State any
one way to write an assertion.

Ans
(a) There are two ways to create threads in Java.

1. By extending the Thread class

2. By implementing the runnable interface

(1 Mark each for mentioning the correct way)

(b) An assertion is a useful mechanism for effectively identifying or detecting
and correcting the logical errors in a program.

There are two ways to write an assertion :

assert expression;

OR

Assert expression1 : expression2
(1 Mark for correct definition)
(1 Mark for writing any one assertion statement correctly)

24 Consider the given table GARMENT : 1+1+1+
1
GCODE GNAME SIZE COLOUR PRICE

111 TShirt XL Red 1400

112 Jeans L Blue 1600

113 Skirt M Black 1100

114 Ladies Jacket XL Blue 4000

Marking Scheme 802 (2024 - 25) Page No - 24

115 Trousers L Brown 1500

116 Ladies Top L Pink 1200

Write SQL commands for the following:

Ans (a) To display names of those garments that are available in ‘L’ size
Select GNAME from GARMENT where SIZE = ‘L’;
(1 Mark for the correct Query)
OR
(1/2 Mark for correct Select and ½ Mark for correct Where clause)

(b) To change the colour of garments with code as 115 to ”Orange” .
UPDATE GARMENT set COLOUR=‘Orange’ where GCODE=115;
(1 Mark for the correct Query)
OR
(1/2 Mark for correct Update .. Set and ½ Mark for correct Where clause)

(c ) To add a new row with the following data :
GCODE = 117
GNAME = Kurta
SIZE = M
COLOUR = White
PRICE = 100
INSERT INTO GARMENT values (117, ‘Kurta’, ‘M’, ‘White’, 1000);
(1 Mark for the correct Query)
OR
(1/2 Mark for correct Insert and ½ Mark for correct values)

(d) To remove the column ‘COLOUR’ from the table ‘GARMENTS’
ALTER TABLE GARMENT DROP COLUMN COLOUR;
OR
ALTER TABLE GARMENT DROP COLOUR;

Marking Scheme 802 (2024 - 25) Page No - 25

(1 Mark for the correct Query)
OR
(1/2 Mark for correct Alter and ½ mark for correct drop)
OR
(1 mark, if written as error because of wrong table name)

Marking Scheme 802 (2024 - 25) Page No - 26