CBSE | DEPARTMENT OF SKILL EDUCATION

INFORMATION TECHNOLOGY (SUBJECT CODE - 802)

Blue-print for Sample Question Paper for Class XII (Session 2022-2023)
Max. Time: 3 Hours Max. Marks: 60

PART A - EMPLOYABILITY SKILLS (10 MARKS):

OBJECTIVE TYPE SHORT ANSWER

UNIT TOTAL
NAME OF THE UNIT QUESTIONS TYPE QUESTIONS
NO. QUESTIONS
1 MARK EACH 2 MARKS EACH
1 Self-Management Skills- IV 2 2 4
2 ICT Skills- IV 2 1 3
3 Entrepreneurial Skills- IV 2 2 4
TOTAL QUESTIONS 6 5 11
NO. OF QUESTIONS TO BE ANSWERED Any 4 Any 3 07
TOTAL MARKS 1x4=4 2x3=6 10 MARKS

PART B - SUBJECT SPECIFIC SKILLS (50 MARKS):

DESCRIPTIVE/
OBJECTIVE SHORT SHORT
LONG
TYPE ANS. TYPE ANS. TYPE
UNIT ANS. TYPE TOTAL
QUESTIONS QUES.- I QUES.- II
NAME OF THE UNIT QUESTIONS
NO. QUESTIONS
1 MARK 2 MARKS 3 MARKS 4 MARKS
EACH EACH EACH EACH

1 Database Concepts 10 2 1 1 14
Operating Web Based 0
2 9 0 1 10
Applications
Fundamentals of Java 1
3 12 2 3 18
programming
4 Work Integrated Learning IT 1 1 1 0 3
TOTAL QUESTIONS 32 5 3 4 45
NO. OF QUESTIONS
26 Any 3 Any 2 Any 3 34
TO BE ANSWERED
TOTAL MARKS 1 x 26= 26 2x3=6 3x2=6 4 x 3 = 12 50 MARKS

Pg. 1
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE 802)
Sample Question Paper for Class XII (Session 2022-2023)
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.

Pg. 2
 SECTION A: OBJECTIVE TYPE QUESTIONS

Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

i. What is a Start up? 1
ii. Ms Sharma has saved marks of all students in a spreadsheet. What should she do 1
to find out three students with the highest total marks?
iii. Why do entrepreneurs require persistence as one of the competences to succeed? 1
iv. Vikky had big dreams when he was studying. He worked hard for achieving his 1
dreams and has achieved his goals. Which of the following options does the given
fact refer to?
(a) Positive thinking
(b) Result Orientation
(c) Self Awareness
(d) Emotional management
v. Rina loves interacting with people and is, generally, talkative. She can easily make 1
friends and make any gathering lively, is confident. Identify the type of personality
Reema possesses.
(a) Nervous
(b) Extrovert
(c) Paranoid
(d) Agreeable
vi. State true or false. 1
“Self-Motivation is significant in building one’s personality. “

Q. 2 Answer any 5 out of the given 7 questions (1 x 5 = 5 marks)

i. Which of the following is not a characteristic of a project? 1
(a) Project has a beginning and an end.
(b) The extent of the project is defined.
(c) Project has no boundaries.
(d) Project requires finite resources

ii. A group of statements which get executed based on a condition in java is called 1
_______.
(a) Selection
(b) Sequential
(c) Iteration
(d) None of these
iii. Which of the following is true for self-referencing table? 1

(a) A foreign key constraint can reference columns within the same table.
(b) A primary key constraint can be null.
(c) You cannot delete this table.
(d) You cannot update or delete this table.

Pg. 3
 iv. Identify the operator that performs pattern searching in MYSQL. 1
(a) EXISTS operator
(b) BETWEEN operator
(c) LIKE operator
(d) SEARCH operator
v. What should we do to make a data member or a method member of a class visible 1
only within the class?
vi. Name any one central initiatives for e-governance. 1
vii. Which website should we search for the list of NCERT e books? 1

Q. 3 Answer any 6 out of the given 7 questions (1 x 6 = 6 marks)

i. Name two domains where database management may be used. ½+
½
ii. If a=20 and b=30 What will be the value of a%=b? 1
iii. List any two advantages of DBMS. 1
iv. This website includes sites of different states and union territories of India, sites of 1
government departments like judiciary and legislature. Which is this website?

(a) goidirectory.nic.in
(b) godirectory.nic.in
(c) indiagov.in
(d) india.gov.in
v. Cardinality of a table is four and degree is three. If two columns and four rows are 1
added to this table, what will be the new degree and cardinality of the given table?
(a) 5,8
(b) 3,4
(c) 8,5
(d) 4,3
vi. The Phase of application development that involves creating a database and 1
writing code is called___________
vii. b. Identify the valid variable names from the following 1
Total marks , int , marks$ , marks4

Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. This website provide high quality online courses for free, in collaboration with 1
various universities across the globe. Which is this website?

(a) coursera.org
(b) khan academy
(c) w3schools.org
(d) cbse.nic.in
ii. While entering the data in the table, Seema is not able to leave the column age as 1
blank in the table. What can be the possible reason?
iii. Mention any two modes of payment during online shopping. ½+
½

Pg. 4
 iv. What is the need of JVM? 1

v. Which of the following queries will give the same output 1

(a) select rollno, name from student where subject in

('Information Technology','Informatics Practices');

(b) select rollno, name from student where subject

between 'Information Technology' and 'Informatics
Practices';

(c) select rollno, name from student where subject

='Information Technology' or subject =' Informatics
Practices ';

(d) select rollno, name from student where subject

='Information Technology' and subject ='Informatics
Practices';

vi. Which member function of the Integer wrapper class allows access to the int value 1
held in it?

Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. Sagar has declared an array whose last element is having an index/position as 10. 1
What would be the size of this array?

ii. In the table teacher, Riya doesn't want repeated values in column marks. 1
Rewrite the correct command.
select marks from teacher;
iii. Rema wants to input the price of shoes as 999.99 .What should be the datatype 1
and size of the column price in the table?

iv. What is an exception in java? 1

v. How can you write multiline comments in java program? 1
vi. What is the purpose of wait () method in java threads? 1

Q. 6 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

i. What are the two ways to create a thread in java? ½
+
½
ii. What is the difference between the following two java statements? ½
+
(a) int x=5; ½
(b) integer y= new integer(50);

Pg. 5
 iii. Roma is booking a railway ticket using an online ticketing website makemytrip.com. 1
When she reached to catch the train she found that she left the ticket at her hotel.
What should she do?

(a) she can’t board the train

(b) she should book a new ticket at station
(c) she should go back and get the ticket
(d) She can download the e-ticket from the website.
iv. What is the MYSQL command to list the names of teachers in alphabetical order in 1
the teacher table?
v. Write the command to see the structure of a table? 1

vi. What do we mean by scope of a project? 1

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)

Answer each question in 20 – 30 words.
Q. 7 Rohan has a successful start-up company. According to him ‘Decision Making is ½+1½
considered to be one of the important entrepreneurial competencies. Do you
agree with Rohan.? Justify.
Q. 8 What do we mean by SMART goals? 2
Q. 9 What is a workbook? Name any one spreadsheet application. 1½+½
Q. 10 How do you protect your spreadsheet from unauthorised access? Which menu 1+1
option you will click to protect your spreadsheet?
Q. 11 What are the various organizational skills required to become a successful 2
entrepreneur?

Answer any 3 out of the given 5 questions (2 x 3 = 6 marks)

Q.12 What will be the value of rem after the execution of the following code snippet? 1+1
why?
code =2;
switch(code)
{case 1: rem= 8;
case 2: rem= 9;
case 3: rem= 10; break;
case 4: rem= 11; break;}
Q.13 The following commands are giving errors. Write the correct MYSQL commands. 1+1
(a)alter table student delete marks;
(b)select * from employee where name =‘%s%’;
Q.14 Ms Prabha has mistakenly entered ‘‘AMIT’’ instead of ‘‘AMITA’’ in name 2
field of table ‘TEACHER’. Help her to write the correct SQL command to make
the desired changes in the table
Q.15 A company is making database of its items and shipment. Item table includes item 1+1
code, item name, item cost . Give details of Shipment Table along with its schema.
Q.16 What is the difference between a while and a do-while loop? 1+1

Pg. 6
Answer any 2 out of the given 3 questions (3 x 2 = 6 marks)
Q.17 Consider the following code 1+1+1
int x = 1;
while(x<=5);
x = x +1;
(a)Name the coding error shown in the above code.
(b) What is the reason of the error?
(c)Write correct java code.
Q.18 (a) Give any two characteristics of a relational model. 2+1
(b) Which aggregate function is used to find the average of all the values for a
selected attribute of a table.
Q.19 List the various ways in which database management applications can be used 3
in Government Sector.

Answer any 3 out of the given 5 questions (4 x 3 = 12 marks)

Q.20 What are String Class Methods in Java? Consider the statement 1+1+1+1
String name = ‘‘Hello World’’.
Write a single line Java code using String methods to perform the
following :
(a) Convert the name to lowercase.
(b) Replace “Hello” by “Welcome” in the given string.
(c) Check whether the name contains ‘‘Sin’’ in it or not
(d) Add a new string ‘‘jackpot” at the end of original string.
Q.21 Mr. Amit wants to go for a business trip .He is thinking of booking a flight. 1+1+1+1
(a) Name any one site which he should browse for booking an air ticket.
(b) Give any one benefit of online reservation to Amit?
(c) What are the precautions to be followed while performing online
transactions?
(d) Give any one advantage to the company providing online reservation?
Q.22 Write a code in java using a for loop to display all odd numbers between 1 to 3+1
10. Is for loop an entry controlled loop or exit control loop?
Q.23 What is the need of a constructor in OOP? Explain all features of a constructor. 1+3
Q.24 Write the Mysql commands for the following queries :- 4
TRAIN
TrainID Station
0001 DELHI
0002 MUMBAI

COUNTER

TicketID Date Cost TrainNo

T1 12/3/22 500 0001
T2 15/5/22 450 0002
T3 15/5/22 500 0001

(a) To find all the stations, date for ticket id as T1.

(b) To find the total ticket amount collected from each station.
(c) To displays all the tables created in the current database.
(d) To delete table counter along with the information in it.

Pg. 7
Pg. 8