CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (802)
MARKING SCHEME FOR CLASS XII (SESSION 2023-2024)
Max. Time: 3 Hours Max. Marks: 60
General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 24 questions in two sections – Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A - OBJECTIVE TYPE QUESTIONS (30 MARKS):
i.This section has 06 questions.
ii.There is no negative marking.
iii.Do as per the instructions given.
iv.Marks allotted are mentioned against each question/part.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (30 MARKS):
i.This section contains 18 questions.
ii.A candidate has to do 11 questions.
iii.Do as per the instructions given.
iv.Marks allotted are mentioned against each question/part.
SECTION A: OBJECTIVE TYPE QUESTIONS
Source Material
Unit/ Page no.
Q. (NCERT/PSSCIVE
QUESTION Chap. of source Marks
No. / CBSE Study
No. material
Material)
Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
i. Paranoid NCERT 2 11 1
ii. Motivation NCERT 2 9 1
iii. ##### NCERT 3 28 1
iv. Interrupting NCERT 1 1
v. social entrepreneurs NCERT 4 95 1
vi. Promoting environmental sustainability NCERT 5 1
Q. 2 Answer any 5 out of the given 7 questions (1 x 5 = 5 marks)
i. 64 CBSE Study 3 105 1
Material
ii. Main CBSE Study 3 97 1
Material
iii. b. select salary *0.5 as allowance from teacher; CBSE Study 1 49 1
Material
iv. a. Application Programmers CBSE Study 1 16 1
Material
v. Byte code is set of instructions or Java class file. CBSE Study 3 93 1
Material
vi. Webinars CBSE Study 2 77 1
Material
1
vii. Clear description of application features with CBSE Study 2 82 1
goals and limitations. Material
Q. 3 Answer any 6 out of the given 7 questions (1 x 6 = 6 marks)
i. Front end Java NetBeans CBSE Study 4 156 ½+
Back end MySQL Material ½
ii. do while CBSE Study 3 117 1
Material
iii. Distinct CBSE Study 1 49 1
Material
iv. National e-Governance Plan CBSE Study 2 68 1
Material
v. c. referential integrity CBSE Study 1 21 1
Material
vi. b. Testing Phase CBSE Study 2 83 1
Material
vii. Object CBSE Study 3 128 1
Material
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. b. b,d,c,a CBSE Study 2 60 1
Material
ii. NOT NULL constraint in age column CBSE Study 1 34 1
Material
iii. A project has a beginning and an end. CBSE Study 2 81 1
A project requires finite resources that are Material
required to complete the project.
A project has a specific time frame.
(any 1 characteristic)
iv. False CBSE Study 3 134 1
Material
v. Degree CBSE Study 1 17 1
Material
vi. 13 CBSE Study 3 120 1
Material
Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. True CBSE Study 2 83 1
Material
ii. SHOW DATABASES CBSE Study 1 32 1
Material
iii. SELECT * FROM Products CBSE Study 1 57 1
WHERE Price BETWEEN 10 AND 20; Material
iv. To use a prebuilt class and associated methods in CBSE Study 3 132 1
those class, use the keyword import. Material
v. b. Package CBSE Study 3 97 1
Material
vi. b. JDK CBSE Study 3 93 1
Material
Q. 6 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. b. 1st_string CBSE Study 3 106 1
Material
ii. parseInt() CBSE Study 3 133 1
Material
iii. goidirectory.nic.in CBSE Study 2 70 1
(Government of India Web Directory) Material
2
iv. SELECT Name CBSE Study 1 51 1
FROM student Material
ORDER BY Name;
v. Round() CBSE Study 1 54 1
Material
vi. Convenient, time saving CBSE Study 2 48 1
(or any other benefit) Material
SECTION B: SUBJECTIVE TYPE QUESTIONS
Source Material Page no.
Unit/
Q. (NCERT/PSSCIVE of
QUESTION Chap. Marks
No. / CBSE Study source
No.
Material) material
Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)
Q. 7 • Stay positive and analyse what is going wrong in a NCERT 2 26 2
certain situation.
• Maintain an accomplishment sheet and enter even
small achievements.
• Keep your thoughts in present. Pondering over past
issues makes us feel upset and helpless.
• Talk to friends and family for comfort.
• Practise meditation and yoga.
(Explain Any TWO )
Q. 8 Effective written communication involves clear NCERT 1 41 2
and concise expression of ideas to convey
information accurately. The components include:
Clarity: Ensure the message is easily
understandable.
Conciseness: Use concise language without
unnecessary details.
Correctness: Eliminate grammatical and spelling
errors.
Completeness: Include all necessary information.
Courteousness: Use polite and respectful
language.
Q. 9 Answer: Eco-friendly consumerism involves making NCERT 5 91 2
purchasing decisions that consider the environmental
impact of products and support sustainable practices.
Conscious consumer behavior influences market
trends and encourages sustainable production
practices by:
• Creating demand for products with lower carbon
footprints and fewer resources.
• Driving companies to adopt greener production
methods to meet consumer preferences.
• Promoting the use of recycled and eco-friendly
materials in products.
• Encouraging the adoption of energy-efficient and
sustainable technologies.
• Shifting the market towards a more
environmentally responsible approach.
3
Q. 10 Select Tools menu . NCERT 3 34 2
Go to Protect document.
Choose Sheet.
The Protect Sheet dialog box appears .
Type the password in Password text box.
Again type the password in Confirm text box.
Click OK button.
Q. 11 The major functions performed by an entrepreneur NCERT 4 96 2
are as follows.
(a) Identifying entrepreneurial opportunity
(b) Turning ideas into action
(c) Feasibility study
d) Resourcing
(e) Setting up an enterprise
(f) Managing the enterprise
(g) Growth and development
(Explain Any Two )
Answer any 3 out of the given 5 questions (2 x 3 = 6 marks)
Q. 12 Looking forward to the Weekend CBSE Study 3 111 2
Material
Q. 13 Drop Table will be dropped and with the CASCADE CBSE Study 1 41 2
option, i.e. all the constraints that refer this table Material
would also be automatically dropped.
Example Drop table teacher Cascade;
Q. 14 Defining the Database: It involves specifying the CBSE Study 1 15 2
data type of data that will be stored in the database Material
and also any constraints on that data.
2. Populating the Database: It involves storing the
data on some storage medium that is controlled by
DBMS.
3. Manipulating the Database: It involves
modifying the database, retrieving data or
querying the database, generating reports from the
database etc.
4. Sharing the Database: Allow multiple users to
access the database at the same time.
5. Protecting the Database: It enables protection of
the database from software/
hardware failures and unauthorized access.
6. Maintaining the Database: It is easy to adapt to
the changing requirements
(Explain any TWO)
Q. 15 PATIENT (pid, docid ,dateofapp, phone) CBSE Study 4 161 1+1
Material
Name Type Remarks
pid INT(10) Patient number
(Primary
Key)
doc_id INT(10) Doctor number
4
dateofapp DATE Date of
Appointment
phone CHAR(10) Phone no.
Q. 16 CBSE Study 3 120 ½+½
int i = 0; Material +
½+½
while (i < 5){
System.out.println(i);
i++;}
(4 errors)
Answer any 2 out of the given 3 questions (3 x 2 = 6 marks)
Q. 17 for CBSE Study 3 117 1+1
i++ Material +1
System.out.println
Q. 18 a. select* from employee where name like ‘s%’; CBSE Study 1 50 1+2
b. Update- DML Material
Delete- DML
Create-DDL
Alter- DDL
Q. 19 1.For storing information about customers like CBSE Study 4 144 3
address, age, PAN card, occupation, contact numbers Material
etc.
2.For storing employee details such as their personal
information, salary, leaves
taken, joining date, retirement year.
3.Information regarding daily transactions.
4.Accounts and loans related information.
(Explain Any THREE)
Answer any 3 out of the given 5 questions (4 x 3 = 12 marks)
Q. 20 a.i. cl.toUpperCase( ) CBSE Study 3 137 3+1
ii. cl.length(); Material
iii. cl.concat(”toppers”);
b. The constructor is a method used to initialize the
data members of the class.
Q. 21 a.myntra.com, snapdeal.com CBSE Study 2 73 1+1
b. iv Both a and b Material +2
c. It requires self discipline.
It is prone to technical issues.
Learner may lose interest over a period of time.
(Explain Any 2 challenges )
5
Q. 22 a. MyMethod CBSE Study Material 3 131 2+2
b. Private members of a class cannot be
accessed outside the class.
Public member of the class has visibility both
within and outside the class.
By default, all members of a class are public.
Q. 23 a. An error situation that is unexpected in the CBSE Study Material 3 140 1+3
program execution and causes it to terminate
unexpectedly is called
an exception.
b. i.try block contains the part of the program
where an exception might occur.
ii.catch block handles the exception. A
specific code that is executed when the
exception occurs.
iii.finally block contains the code to be
executed when the try block exits.
Q. 24 a.Select SUM(NoOfEmployee), Location CBSE Study Material 1 57 1
from STORE group by location ;
b. Select storename, location, OpeningYear
1
from store where OpeningYear <”2015”;
c. Alter table store add SALE integer;
1
d. Select StoreName, OwnerName from
STORE, OWNER where 1
store.OwnerId=Owner.OwnerId and
Location=”Mumbai”;
