Sample question papers play an important role in preparing for the CBSE Class 12 Information Technology (802) board exam. By solving the 2023–24 sample paper, students can understand the latest exam pattern, types of questions, and marking scheme used by CBSE. It also helps students practice important topics and improve their confidence before the final examination.
This page provides the CBSE Class 12 IT (802) Sample Question Paper 2023–24 with complete solutions. The solutions are explained in a clear and simple way so that students can easily understand the correct answers and the proper method of solving questions. Practicing this paper will help students check their preparation and improve their performance in the board exam.
CBSE Class 12 IT 402 Sample QP 2023-24 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 (2023-24)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 802)
Sample Question Paper (SQP) Solution for Class XII (Session 2023-2024)
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) ______ is feeling extremely nervous and worried because you believe that other people do not like you or are trying to harm you.
Ans: Paranoid
(ii) ______ is defined as the drive required to engage in goal-oriented behaviour.
Ans: Motivation
(iii) ______ symbol is displayed when the column in Calc is not wide enough to display the value.
Ans: #####
(iv) ______ is NOT a component of effective communication?
Ans: Interrupting
(v) Individuals, who focus on developing solutions that benefit the society, are called ______.
Ans: social entrepreneurs
(vi) "Green Skills" are primarily focused on ______.
Ans: Promoting environmental sustainability
Q.2 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) The size of double datatype in java is ______ bit.
Ans: 64
(ii) ______ is a special method that every Java application must have.
Ans: Main
(iii) Choose the correct MySql command to display 5% of salary as allowance.
a) select salary +0.5 as allowance from teacher;
b) select salary *0.5 as allowance from teacher;
c) select salary *0.5 rename as allowance from teacher;
d) select salary+salary *0.5 allowance from teacher;
(iv) They are programmers who code in high level languages.
a) Application programmers
b) System analysts
c) End users
d) Database Administrators
(v) What is a byte code?
Ans: Byte code is set of instructions or Java class file.
(vi) ______ are real time lectures, where users participate in the lecture, may ask questions and get their queries answered.
Ans: Webinars
(vii) Define the scope of the application.
Ans: The scope of an application is a clear description of the features, goals, and limitations of the application. It defines what the application will do and what it will not do.
Q.3 Answer any 6 out of the given 7 questions (1x6=6 Marks)
(i) Name one front end and one Back-end application to create Web Applications.
Ans: Front-end: Java NetBeans
Back-end: MySQL
(ii) ______ loop run at least once.
Ans: do-while
(iii) ______ clause is used to remove duplicate values.
Ans: Distinct
(iv) What is NeGP?
Ans: NeGP (National e-Governance Plan) is an initiative of the Government of India to provide government services to citizens electronically through information and communication technology (ICT) in an efficient, transparent, and convenient manner.
(v) The main purpose of this constraint is to check that data entered in one relation is consistent with the data entered in another relation. Name the constraint.
Ans: Referential Integrity
(vi) Finding of Bugs and Fixing them happens in ______ phase.
a) Design
b) Testing
c) Implementation
d) Requirement Definition
(vii) Once the class is defined, we can create ______ of the class and access its members.
Ans: Object
Q.4 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) Mr Sagar wants to purchase a product online. Help Mr Sagar in choosing the correct order of steps to be followed.
A. Provide his details (Or login into his bank account)
B. Add items in shopping cart
C. Choose payment option (Make payment if not cash on delivery)
D. Select Buy option
a) C, D, B, A
b) B, D, C, A
c) D, B, C, A
d) A, C, B, D
(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 one key characteristic of a project.
Ans: (i) A project has a beginning and an end.
(ii) A project requires finite resources that are required to complete the project.
(iii) A project has a specific time frame.
(iv) State TRUE or FALSE
binary() method is used to arrange an array of integers in ascending order.
Ans: False
(v) The number of attributes in a relation is called the ______ of a relation.
Ans: Degree
(vi) Predict the output:
double[ ]Qty = {46, 42, 13, 6.5, 87.5};
System.out.println(Qty[3]);
Ans: 13
Q.5 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) State True or False
The data connectivity is established between the Front-End interface and Back-End Database in the implementation phase.
Ans: True
(ii) Once the database is created, you can check it in the list of databases that currently exist on the server by using ______ command.
Ans: Show Databases;
(iii) Write MySQL statement that selects all products with a price between 10 and 20 from product table.
Ans: SELECT * from Products WHERE Price BETWEEN 10 AND 20;
(iv) Java is case sensitive language. Justify the statement.
Ans: Java is a case-sensitive language, which means uppercase and lowercase letters are treated as different. For example, sum, Sum, and SUM are considered different identifiers in Java.
(v) A ______ in java is a group of related classes.
a) Method
b) Package
c) Constructor
d) Variable
(vi) Which component is used to compile, debug and execute java program?
a) JVM
b) JDK (Java Development Kit)
c) IDE
d) JRE
Q.6 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) Which of the following is an invalid variable declaration?
a) my_string_1
b) 1st_string
c) mystring1
d) _mystring1
(ii) ______ method takes a String as parameter and returns the equivalent integer.
Ans: parseInt()
(iii) This portal is a one point source to access all Indian Government websites at all levels and from all sectors. Name the portal.
Ans: goidirectory.nic.in
(Government of India Web Directory)
(iv) REEMA wants to arrange names of students in alphabetical order in the student table. Give the MYSQL command to create a sorted list.
Ans: SELECT * FROM student ORDER BY name;
(v) ______ is not an aggregate function.
a) Sum( )
b) Count( )
c) Round( )
d) Avg( )
(vi) Give one benefit of online reservation.
Ans: (i) Saves time because booking can be done quickly online.
(ii) Convenient, as reservations can be made from anywhere at any time.
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 Explain any two methods to deal with stress.
Ans: (i) Exercise regularly - Physical activities like walking, yoga, or sports help reduce stress and improve mood.
(ii) Time management - Planning and organizing tasks properly helps avoid pressure and reduces stress.
(iii) Relaxation techniques - Activities like deep breathing, meditation, and listening to music help calm the mind.
Q.8 What are the essential components of effective written communication?
Ans: Effective written communication means expressing ideas clearly and accurately in written form so that the reader can easily understand the message.
Essential components of effective written communication:
- Clarity - The message should be clear and easy to understand.
- Conciseness - Use simple and brief language without unnecessary details.
- Correctness - The writing should be free from grammatical and spelling errors.
- Completeness - All necessary information should be included.
- Courtesy - The language used should be polite and respectful.
Q.9 Explain the concept of "eco-friendly consumerism." How does conscious consumer behavior influence market trends and encourage sustainable production practices?
Ans: Eco-friendly consumerism means buying products that are environmentally friendly and cause less harm to nature. People choose products that are sustainable, reusable, or made from eco-friendly materials.
How conscious consumer behavior influences the market:
- It increases demand for eco-friendly products.
- Companies start using greener production methods to satisfy customers.
- Businesses use recycled and sustainable materials in products.
- It encourages companies to adopt energy-efficient and environmentally safe technologies.
- Overall, it helps move the market towards environmentally responsible products and practices.
Q.10 Write down the steps to protect your spreadsheet in Calc?
Ans: Steps to protect a spreadsheet in LibreOffice Calc:
Step 1: Click on the Tools menu.
Step 2: Select Protect Spreadsheet option.
Step 3: Enter the password.
Step 4: Click OK to protect the spreadsheet.
Q.11 What are the two major functions performed by an Entrepreneur?
Ans: The two major functions performed by an entrepreneur are:
(i) Identifying entrepreneurial opportunities - Finding new business ideas and opportunities in the market.
(ii) Turning ideas into action - Converting business ideas into a real enterprise by planning and organizing resources.
Answer any 3 out of the given 5 questions in 20 – 30 words each (2x3=6 Marks)
Q.12 Give the output of the following code segment:
public class Main {
public static void main(String[] args) {
int day = 4;
switch (day) {
case 6:
System.out.println("Today is Saturday");
break;
case 7:
System.out.println("Today is Sunday");
break;
default:
System.out.println("Looking forward to the Weekend");
}
}
}
Ans: Looking forward to the Weekend
Q.13 Explain Drop table with Cascade command in My SQL.
Ans: DROP TABLE with CASCADE in MySQL is used to delete a table along with all the objects or constraints related to it, such as foreign key references.
When the CASCADE option is used, all the dependent objects (like constraints or related tables) are also removed automatically.
Q.14 Explain any two operations performed on database.
Ans: (i) Defining the Database - Specifying the data types and constraints of the data stored in the database.
(ii) Populating the Database - Adding or storing data into the database.
(iii) Manipulating the Database - Retrieving, updating, deleting, or modifying data in the database.
(iv) Sharing the Database - Allowing multiple users to access the database at the same time.
Q.15 A hospital is making database of its doctors and patients. Doctor table includes doc code, idoc name, dept . Give details of Patient Table along with its schema.
Ans: PATIENT (pid, docid ,dateofapp, phone)
| Name | Type | Remarks |
|---|---|---|
| pid | INT(10) | Patient number (Primary Key) |
| doc_id | INT(10) | Doctor number |
| dateofapp | DATE | Date of appointment |
| phone | CHAR(10) | Phone number |
Q.16 Find error and rewrite the correct code
i == 0;
while (i < 5) {
System.out.println(i)
i++;
Ans: Errors in the code:
(i) i = = 0 should be i = 0 (assignment operator).
(ii) Missing semicolon (;) after System.out.println(i).
(iii) Missing closing bracket } for the while loop.
Correct Code:
int i = 0;
while (i < 5) {
System.out.println(i);
i++;
}
Answer any 2 out of the given 3 questions in 30– 50 words each (3x2=6 Marks)
Q.17 Complete the code in JAVA using a loop to print "Yes" 5 times:
______ (int i = 0; i < 5; _______ )
{
______(”Yes”);
}
Ans: for, i++, System.out.println
Q.18 (a) Rina wants to display the details of employee whose name starts from s. Find errors in given MySQL command and write the correct statement.
select * from employee where name like *s;
Ans: select * from employee where name like s%;
(b) Classify them into DDL or DML commands Update, Delete, Create , Alter.
Ans: DDL (Data Definition Language): CREATE, ALTER
DML (Data Manipulation Language): UPDATE, DELETE
Q.19 Explain the application of Database management systems in banking.
Ans: Application of DBMS in Banking:
(i) Stores customer information such as name, address, PAN card, contact number, etc.
(ii) Maintains employee records like salary, joining date, and leave details.
(iii) Keeps records of daily transactions such as deposits and withdrawals.
(iv) Manages account and loan details of customers.
Answer any 3 out of the given 5 questions in 50– 80 words each (4x3=12 Marks)
Q.20 (a) Write a single line Java code using String methods to perform the following tasks
String cl = ‘‘class xii’’;
i. Convert the characters to capital letters.
Ans: cl.toUpperCase();
ii. Find the total length of string.
Ans: cl.length();
iii. Add a word ‘‘toppers” at the end of original string.
Ans: cl.concat("toppers");
(b) What is the purpose of a constructor?
Ans: The purpose of a constructor is to initialize the data members of a class when an object is created. It is automatically called when an object of the class is created.
Q.21 (a) Name two e-commerce websites.
Ans: Amazon, Flipkart, Myntra, Ajio, eBay, Alibaba
(b) Creating a strong password is vital. A strong password has:
i. 6-8 Alphanumeric characters
ii. Special symbols
iii. Only numbers
iv. Both a and b
Ans: Both i. and ii.
(c) What are the challenges in online learning?
Ans: Poor internet connectivity, Lack of face-to-face interaction with teachers, Distractions while studying at home
Q.22 (a) Name the user defined method in the code given below. Also predict the output.
static int myMethod(int x)
{ return ( 5 + x); }
public static void main(String[] args) {
System.out.println(myMethod(3)); }
Ans: User defined method: myMethod
Output: 8
(b) Explain any two access modifiers.
Ans: (i) Public: Members declared as public can be accessed from anywhere in the program.
(ii) Private: Members declared as private can be accessed only within the same class.
Q.23 (a) What is an exception?
Ans: An exception is an error or unexpected event that occurs during the execution of a program and disrupts the normal flow of the program.
(b) Explain each of the following terms in exception handling
i. try - The try block contains the code that may cause an exception.
ii. catch - The catch block is used to handle the exception if it occurs in the try block.
iii. finally - The finally block contains code that is always executed whether an exception occurs or not.
Q.24 Consider the following tables and write Mysql Commands.
STORE
| StoreId | StoreName | Location | NoOfEmployee | OpeningYear | OwnerId |
|---|---|---|---|---|---|
| S101 | Libas | Delhi | 45 | 2007 | A145 |
| S102 | Life Style | Mumbai | 68 | 2000 | B178 |
| S103 | Vogue | Mumbai | 50 | 1999 | B178 |
OWNER
| OwnerId | OwnerName |
|---|---|
| A145 | Divyam Prakash |
| B178 | Neha Sultan |
| D112 | Gargi Chhabra |
a. To display the number of employees present in each location.
Ans: SELECT Location, SUM(NoOfEmployee)
FROM STORE
GROUP BY Location;
b. To display Stores names, Location and Date of Opening of stores that were opened before 2015.
Ans: SELECT StoreName, Location, OpeningYear
FROM Store
WHERE OpeningYear < 2015;
c. To add a new column SALE of integer type.
Ans: ALTER TABLE Store
ADD SALE INT;
d. To display Store Name and Owner Name of all stores in Mumbai.
Ans: SELECT StoreName, OwnerName
FROM Store, Owner
WHERE Store.OwnerId = Owner.OwnerId
AND Location = 'Mumbai';
Download Now - Class 12 IT 802 Sample Question Paper 2023-24 with Solution
