Sample question papers are very helpful for students preparing for the CBSE Class 12 Information Technology (802) board examination. By solving sample papers, students can understand the latest exam pattern, types of questions, and marking scheme used in the board exam. It also helps them practice different types of questions and improve their time management skills. When students regularly practice these papers, they become more confident and can easily identify the topics where they need more revision.
Sample papers are also useful for teachers as they help in guiding students for better exam preparation. Teachers can use these papers to conduct practice tests, revision sessions, and discussions in the classroom. On this page, you will find CBSE Class 12 Information Technology (802) Sample Question Paper 2022–23 with complete solutions. The solutions will help students understand the correct answers and the proper way to solve the questions, making exam preparation easier and more effective.
CBSE Class 12 IT 402 Sample QP 2022-23 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 12 Information Technology (802) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 12 IT 802 Sample Question Paper Session (2022-23)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 802)
Sample Question Paper (SQP) Solution for Class XII (Session 2022-2023)
Max. Time: 3 Hours
Max. Marks: 60
General Instructions:
- Please read the instructions carefully.
- This Question Paper consists of 24 questions in two sections – Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- 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.
- All questions of a particular section must be attempted in the correct order.
- SECTION A - OBJECTIVE TYPE QUESTIONS (30 MARKS):
- This section has 06 questions.
- There is no negative marking.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
- SECTION B – SUBJECTIVE TYPE QUESTIONS (30 MARKS):
- This section contains 18 questions.
- A candidate has to do 11 questions.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
SECTION A: OBJECTIVE TYPE QUESTIONS
Q.1 Answer any 4 out of the given 6 questions on Employability Skills (1x4=4 Marks)
(i) What is a Start up?
Ans: A startup is a company that is in the first stage of its operations. Startups can be started with minimum investment.
(ii) Ms Sharma has saved marks of all students in a spreadsheet. What should she do to find out three students with the highest total marks?
Ans: She can sort the data on the total marks
(iii) Why do entrepreneurs require persistence as one of the competences to succeed?
Ans: Persistence is the ability to continue to do something, even when it is difficult. It is one of the attitudes and competencies to become a successful entrepreneur.
(iv) Vikky had big dreams when he was studying. He worked hard for achieving his 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 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.
"Self-Motivation is significant in building one’s personality."
Ans: True
Q.2 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) Which of the following is not a characteristic of a project?
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 _______.
a) Selection
b) Sequential
c) Iteration
d) None of these
(iii) Which of the following is true for self-referencing table?
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.
iv. Identify the operator that performs pattern searching in MYSQL.
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 only within the class?
Ans: To make a data member or a method member of a class visible only within the class, we add the keyword private before its declaration.
vi. Name any one central initiatives for e-governance.
Ans: Digital India, National e-Governance Plan (NeGP) UMANG, e-Courts Mission Mode Project
vii. Which website should we search for the list of NCERT e books?
Ans: www.ncert.nic.in
Q.3 Answer any 6 out of the given 7 questions (1x6=6 Marks)
(i) Name two domains where database management may be used.
Ans: (i) Education (ii) Banking
(ii) If a=20 and b=30 What will be the value of a%=b?
Ans: 20
(iii) List any two advantages of DBMS.
Ans: (i) Controls Data Redundancy - Reduces duplicate data.
(ii) Data Security - Protects data from unauthorized access.
(iii) Data Sharing - Multiple users can access data at the same time.
(iv) Data Integrity - Maintains accuracy and consistency of data.
(v) Backup and Recovery - Data can be restored after failure.
(iv) This website includes sites of different states and union territories of India, sites of 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 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 writing code is called ________.
Ans: Implemetation Phase
(vii) Identify the valid variable names from the following:
Total marks , int , marks$ , marks4
Ans: marks$ and marks4
Q.4 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) This website provide high quality online courses for free, in collaboration with 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 blank in the table. What can be the possible reason?
Ans: NOT NULL constraint in age column
(iii) Mention any two modes of payment during online shopping.
Ans: Credit Card, Devit Card, Net Banking, CoD, UPI, e-Gift Voucher
(iv) What is the need of JVM?
Ans: When the bytecode (also called a Java class file) is to be run on a computer, a Java interpreter, called the Java Virtual Machine (JVM), translates the bytecode into machine code and then executes it.
(v) Which of the following queries will give the same output
i) select rollno, name from student where subject in ('Information Technology','Informatics Practices');
ii) select rollno, name from student where subject between 'Information Technology' and 'Informatics Practices';
iii) select rollno, name from student where subject ='Information Technology' or subject =' Informatics Practices ';
iv) select rollno, name from student where subject ='Information Technology' and subject ='Informatics Practices';
Ans: i) and iii) both give the same output.
(vi) Which member function of the Integer wrapper class allows access to the int value held in it?
Ans: intValue() member function of the Integer wrapper class allows access to the int value held in it.
Q.5 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) Sagar has declared an array whose last element is having an index/position as 10.
What would be the size of this array?
Ans: 11
(ii) In the table teacher, Riya doesn't want repeated values in column marks.
Rewrite the correct command.
SELECT Marks from Teacher;
Ans: SELECT DISTINCT Marks from Teacher;
(iii) Rema wants to input the price of shoes as 999.99 .What should be the datatype and size of the column price in the table?
Ans: Decimal (5,2)
(iv) What is an exception in java?
Ans: An error situation that is unexpected in the program execution and causes it to terminate unexpectedly is called an exception.
(v) How can you write multiline comments in java program?
Ans: Writing the comment between the symbols /* and */
(vi) What is the purpose of wait () method in java threads?
Ans: This method is useful when you have multiple threads running but you want one of them to start execution only when another one finishes and notifies the first one to resume execution.
Q.6 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) What are the two ways to create a thread in java?
Ans: In Java, threads can be created in two ways:
(i) By extending the Thread class
(ii) By implementing the Runnable interface
(ii) What is the difference between the following two java statements?
(a) int x=5;
Ans: int is a primitive data type. It directly stores the value 5 in memory. It is faster and uses less memory.
(b) integer y= new integer(50);
Ans: Integer is a wrapper class (object) in Java. It stores 50 as an object. It requires more memory and supports object methods.
(iii) Roma is booking a railway ticket using an online ticketing website makemytrip.com. 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 the teacher table?
Ans: SELECT Name FROM Teacher ORDER BY Name;
(v) Write the command to see the structure of a table?
Ans: DESCRIBE
(vi) What do we mean by scope of a project?
Ans: The focus is on "what" the application must do. Recognizing the limitations that are placed on the project.
SECTION B: SUBJECT TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2x3=6 Marks)
Answer each question in 20 – 30 words.
Q.7 Rohan has a successful start-up company. According to him ‘Decision Making is considered to be one of the important entrepreneurial competencies. Do you agree with Rohan.? Justify.
Ans: Yes, I agree with Rohan.
Decision making is an important entrepreneurial competency because an entrepreneur has to take timely and appropriate decisions for the success of the business. If an entrepreneur cannot make proper decisions at the right time, they may miss business opportunities and suffer losses.
Q.8 What do we mean by SMART goals?
Ans: SMART Goals are goals that are clear, achievable, and planned properly. SMART stands for:
S - Specific: The goal should be clear and well-defined.
M - Measurable: The progress of the goal should be measurable.
A - Action-oriented: The goal should include clear actions or steps to achieve it.
R - Realistic: The goal should be practical and possible to achieve.
T - Timely: The goal should have a fixed time limit or deadline.
Q.9 What is a workbook? Name any one spreadsheet application.
Ans: A workbook is a file in a spreadsheet program that contains one or more worksheets where data is stored and calculations are performed.
Spreadsheet applications are: LibreOffice Calc, Microsoft Excel
Q.10 How do you protect your spreadsheet from unauthorised access? Which menu option you will click to protect your spreadsheet?
Ans: To protect a spreadsheet from unauthorized access, we can set a password for the spreadsheet.
Steps: Click Tools → Protect Spreadsheet and set a password to protect it.
Q.11 What are the various organizational skills required to become a successful entrepreneur?
Ans: Organizational skills required to become a successful entrepreneur include the ability to use time, energy, and resources effectively to achieve goals. These skills include time management, goal setting, efficiency, and quality management.
Answer any 3 out of the given 5 questions in 20 – 30 words each (2x3=6 Marks)
Q.12 What will be the value of rem after the execution of the following code snippet? why?
code =2;
switch(code)
{case 1: rem= 8;
case 2: rem= 9;
case 3: rem= 10; break;
case 4: rem= 11; break;}
Ans: The value of rem = 10.
Reason:
code = 2, so the switch starts executing from case 2.
In case 2, rem = 9 is assigned.
Since there is no break, execution continues to case 3 (this is called fall-through).
In case 3, rem = 10 is assigned and then break stops the switch.
Q.13 The following commands are giving errors. Write the correct MYSQL commands.
(a) ALTER table student delete marks;
Ans: ALTER TABLE student DROP marks;
(b) SELECT * from employee where name =‘%s%’;
Ans: SELECT * FROM employee WHERE name LIKE '%s%';
Q.14 Ms Prabha has mistakenly entered ‘‘AMIT’’ instead of ‘‘AMITA’’ in name field of table ‘TEACHER’. Help her to write the correct SQL command to make the desired changes in the table
Ans: UPDATE TEACHER
SET name = 'AMITA'
WHERE name = 'AMIT';
Q.15 A company is making database of its items and shipment. Item table includes item code, item name, item cost . Give details of Shipment Table along with its schema.
Ans: SHIPMENT (Shipment_id, Details, Shipment_date)
SHIPMENT Table Schema
| Name | Type | Remarks |
|---|---|---|
| Shipment_id | INT(10) | Shipment number (Primary Key) |
| Details | VARCHAR(30) | Location details |
| Shipment_date | DATE | Date of shipment |
Q.16 What is the difference between a while and a do-while loop?
Ans: The while loop checks the condition before executing the loop body. If the condition is false at the beginning, the loop will not execute even once. In contrast, the do-while loop checks the condition after executing the loop body. Therefore, the statements inside a do-while loop are executed at least once, even if the condition is false.
Answer any 2 out of the given 3 questions in 30– 50 words each (3x2=6 Marks)
Q.17 Consider the following code:
int x = 1;
while(x<=5);
x = x +1;
(a) Name the coding error shown in the above code.
Ans: Infinite loop (due to a misplaced semicolon).
(b) What is the reason of the error?
Ans: A semicolon (;) after the while condition ends the loop immediately, so the loop runs continuously and x is never updated inside the loop.
(c) Write correct java code.
Ans: int x = 1;
while(x <= 5)
{
x = x + 1;
}
Q.18 (a) Give any two characteristics of a relational model.
Ans: (i) Data is stored in the form of tables (relations) consisting of rows and columns.
(ii) Each table has a primary key that uniquely identifies each record.
(b) Which aggregate function is used to find the average of all the values for a selected attribute of a table.
Ans: AVG () Function
Q.19 List the various ways in which database management applications can be used in Government Sector.
Ans: Census records, Electoral roll, Tax collection (Income tax, Sales tax, House tax etc.), Criminal records, PAN card details, Aadhaar card details, Vehicle registration, Passport records, Birth and death certificate registration, Land records management.
Answer any 3 out of the given 5 questions in 50– 80 words each (4x3=12 Marks)
Q.20 What are String Class Methods in Java? Consider the statement
String name = ‘‘Hello World’’.
Write a single line Java code using String methods to perform the following:
(a) Convert the name to lowercase.
Ans: name.toLowerCase();
(b) Replace “Hello” by “Welcome” in the given string.
Ans: name.replace("Hello","Welcome");
(c) Check whether the name contains ‘‘Sin’’ in it or not
Ans: name.contains("Sin");
(d) Add a new string ‘‘jackpot” at the end of original string.
Ans: name.concat("jackpot");
Q.21 Mr. Amit wants to go for a business trip .He is thinking of booking a flight.
(a) Name any one site which he should browse for booking an air ticket.
Ans: www.makemytrip.com
(b) Give any one benefit of online reservation to Amit?
Ans: It saves time and can be done from anywhere.
(c) What are the precautions to be followed while performing online transactions?
Ans: Use secure websites (https) and do not share OTP or passwords.
(d) Give any one advantage to the company providing online reservation?
Ans: It reduces operational cost and increases customer reach.
Q.22 Write a code in java using a for loop to display all odd numbers between 1 to 10. Is for loop an entry controlled loop or exit control loop?
Ans: for (int count = 1; count <= 10; count = count + 2)
{
System.out.println(count);
}
Loop Type:
The for loop is an entry-controlled loop because the condition is checked before the loop body executes.
Q.23 What is the need of a constructor in OOP? Explain all features of a constructor.
Ans: Need of Constructor in OOP:
A constructor is a special method of a class that is used to initialize the data members (variables) of an object when the object is created.
Features of a Constructor:
(i) The constructor has the same name as the class.
(ii) It does not have any return type, not even void.
(iii) It may or may not have parameters.
(iv) The constructor is automatically called when an object of the class is created.
(v) It is not called explicitly like normal methods.
Q.24 Write the MySQL commands for the following queries:
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.
Ans: SELECT Station, Date
FROM TRAIN, COUNTER
WHERE TRAIN.TrainID = COUNTER.TrainNo
AND TicketID = 'T1';
(b) To find the total ticket amount collected from each station.
Ans: SELECT Station, SUM(Cost)
FROM TRAIN, COUNTER
WHERE TRAIN.TrainID = COUNTER.TrainNo
GROUP BY Station;
(c) To displays all the tables created in the current database.
Ans: SHOW TABLES;
(d) To delete table counter along with the information in it.
Ans: DROP TABLE COUNTER;
Download Now - Class 12 IT 802 Sample Question Paper 2022-23 with Solution
