Practicing sample question papers is one of the best ways to prepare for the CBSE Class 12 Information Technology (802) examination. The sample paper for the session 2024–25 helps students understand the format of the board exam and the level of questions that may appear in the final paper. It also helps students revise important concepts and improve their problem-solving skills.
Here you will find the CBSE Class 12 IT (802) Sample Question Paper 2024–25 with complete solutions. The detailed solutions will help students learn the correct answers and understand how to write answers in the exam. By practicing this sample paper, students can improve their preparation and feel more confident for the board examination.
CBSE Class 12 IT 802 Sample QP 2024-25 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 (2024-25)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 802)
Sample Question Paper (SQP) Solution for Class XII (Session 2024-2025)
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) A _______ is the most basic type of sentence, its purpose is to relay information, and it is punctuated with a period.
a) Declarative sentences
b) Interrogative sentences
c) Imperative sentences
d) Exclamatory sentences
(ii) Which of the following are not true for Physiological motivation?
a) Physiological motivation is based on the physical needs to satisfy hunger or thirst.
b) Psychological motivations can be guided by need for achievement and need for affiliation.
c) Physiological motivation directs the behaviour towards satisfying specific bodily needs.
d) Physiological motivation are made up of emotional, behavioral and mental set of characteristics.
(iii) Samiara spends all her after-school hours practicing more and more sample question papers. She wants to do well in her exams so that she can get admission in her dream college in the city. This is an example of:
a) Internal motivation
b) External motivation
c) Inspiration
d) Self-management
(iv) ______ rearranges the range of cells but filtering only hides temporarily the rows/columns you do not want.
a) Charts
b) Built in functions
c) Sorting
d) Solve
(v) Dhruv had multiple factories in different states of India. On an unfortunate day one of his factory caught fire, and everything got burnt down. There was a huge financial loss, but luckily there was no threat to anyone's life, and no injuries.
On the day of the fire, the workers of the factory had tried all possible ways to extinguish the fire, but to no avail.
The next day when Dhruv reached the factory, he got to know about the details from the Fire Brigade Incharge about the valour shown by the workers, without fearing for their lives to save the factory. Dhruv was moved on hearing the details.
He always had respect for loyalty. So that he did not lose the loyal workers that were working in the factory, he got them relocated to another factory of his, by the time the damaged factory of his was rebuilt, as it was insured.
a) Self Confidence
b) Effective Monitoring
c) Concern for Employees Welfare
d) Goal Setting
(vi) Individuals, who focus on developing solutions that benefit the society, are called _______.
a) Social Entrepreneurs
b) Industrial entrepreneurs
c) Agricultural entrepreneurs
d) Technical entrepreneurs
Q.2 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) Which of the following is not an example of relational operator?
a) >
b) =
c) <
d) !=
(ii) How many primitive data types are supported by Java ? Name any two of them.
Ans: In all, Java supports eight primitive data types. (byte, short, int, long, float, double, char, Boolean)
(iii) Which command will display all those names from a table which have the alphabet 'a' present anywhere in the Name column in a table Employee?
a) SELECT Name FROM Employee where Name in ("a", "%a");
b) SELECT Name FROM Employee where Name in ("a", "%a");
c) SELECT Name FROM Employee where Name in ("a", "%a");
d) SELECT Name FROM Employee where Name ="%a%";
(iv) ________ is a set of attributes in a relation, for which no two tuples in a relation state have the same combination of values.
a) Superkey
b) Candidate Key
c) Primary Key
d) Candidate Key
(v) What is a method?
Ans: A method is a group of statements written to perform a specific task. The method body is enclosed within a pair of curly braces and contains the statements that the method will execute. Main is a special method that every Java application must have. When you run a program, the statements in the main method are the first to be executed.
(vi) An application that can be accessed via a web browser, over a network connection is called a _______.
Ans: Web-based Application
(vii) Complete the sentence:
The web-based online applications can be broadly categorized into
Ans: The web-based online applications can be broadly categorized into applications that require financial online transactions and applications that provide information and allow interaction via filling forms, posting query, viewing information, sending email or chatting.
Q.3 Answer any 6 out of the given 7 questions (1x6=6 Marks)
(i) Name the National Portal of India.
Ans: https://www.india.gov.in
(This is the National Portal of India, which provides a single window access to information and services being provided by the various Indian Government entities)
(ii) What are the two ways of writing comments in a Java program?
Ans: You can write comments in a Java program in the following two ways:
(i) Writing the comment between the symbols /* and */
(ii) Beginning a comment line with two consecutive forward slashes (//)
(iii) Consider the table, Vehicle given below:
Table: VEHICLE
| MID | NAME | BRAND | CAPACITY | COLOR |
|---|---|---|---|---|
| H101 | I20 | Hyundai | 5 | WHITE |
| M012 | XUV500 | Mahindra | 5 | BLUE |
| T107 | Innova | Toyota | 7 | SILVER |
| H131 | Verna | Hyundai | 5 | BLUE |
| M010 | Celerio | Maruti | 5 | RED |
| R100 | Duster | Renault | 7 | WHITE |
Identify the degree and cardinality of the table Vehicle.
Ans: Degree = 5, Cardinality = 6
(iv) Internet transactions are susceptible to frauds. The combination of username and password is the most common method of user identification and authentication. List any one Some actions that can be taken to make the passwords safer.
Ans: Make a password complex, like mix case, use numbers and special characters. This decreases ability of automated attacks by trying different character combinations.
(v) Consider the following tables - ORDERS and PRODUCTS:
Table: ORDERS
| ORDERNO | DATE | ID | QTY |
|---|---|---|---|
| 1001 | 2022-01-12 | P001 | 180 |
| 1002 | 2022-12-31 | P002 | 175 |
| 1003 | 2023-01-20 | P001 | 125 |
| 1004 | 2023-12-25 | P003 | 190 |
| 1005 | 2023-11-20 | P002 | 155 |
| 1006 | 2022-11-15 | P001 | 130 |
Table : PRODUCTS
| ID | PNAME | PRICE |
|---|---|---|
| P001 | PEN | 50 |
| P002 | NOTEBOOK | 120 |
| P003 | PENCIL | 20 |
Identify the Primary key and Foreign Key of the table ORDERS
Ans: Primary Key is ORDERNO and Foreign key is ID
(vi) Which of the following ICT-enabled services have not been set up by the Indian Government?
a) Booking of railway tickets,
b) Registration of birth/death certificate
c) Purchase of movie tickets
d) RTI application submission
e) Registration of birth certificate
(vii) Find the invalid identifier from the following:
a) While
b) Score1
c) My_Name
d) break
Q.4 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) Adrisa wanted to book her flight to attend an international conference on “Women and AI” . She needs to book her tickets using on online reservation system. Help her to follow the correct sequence of steps to do the same.
A. Make the payment
B. Open the online reservation website
C. Choose the dates of travel
D. Browse and search for the required information
a) B, D, C, A
b) A, B, C, D
c) A, D, C, B
d) B, A, D, C
(ii) The _______ aggregate function in SQL is used to find the average values of a numeric column:
a) AVERAGE()
b) MEAN()
c) AVG()
d) MID()
(iii) Which of the following is not true for Online Shopping?
a) The customer can view the goods that are displayed along with the details of the goods.
b) Once the goods are purchased they cannot be returned or exchanged.
c) The goods are then delivered at the address specified by the customer.
d) The customer can select the goods to be purchased and store them in their online shopping basket.
(iv) State TRUE or FALSE
Private data members of a class cannot be accessed outside the class however, you can give controlled access to data members outside the class through getter and setter methods.
Ans: True
(v) Which of the following will display the highest and lowest value of the column Fee from the table COACH?
a) SELECT HIGH(FEE), LOW(FEE) FROM COACH;
b) SELECT HIGHEST(FEE), LOWEST(FEE) FROM COACH;
c) SELECT MAXIMUM(FEE), MINIMUM(FEE) FROM COACH;
d) SELECT MAX(FEE), MIN(FEE) FROM COACH;
(vi) Predict the output
System.out.println(4*4*4==8*8);
Ans: true
Q.5 Answer any 5 out of the given 6 questions (1x5=5 Marks)
(i) State True or False
Fixing of all the application bugs and fixing them is part of the Testing Phase of the project.
Ans: True
(ii) Aparna wanted to remove the table PERSONAL permanently from the database SCHOOL. Write the command to help her do the same.
Ans: USE SCHOOL;
DROP TABLE PERSONAL;
(iii) A named constraints in a table can be easily deleted or updated using the _______ command.
Ans: ALTER TABLE
(iv) Differentiate between the following two java statements:
char Alpha=’A’ ; //Statement #1
String Name=”Manish”; //Statement #2
Ans: Statement 1: A variable of the primitive data type char can be used to store a single character. To assign a value to a char variable we enclose the character between single quotes.
Statement 2: To store more than one character, we use the String class in Java. To assign a text value to a String variable we enclose the text between double quotes.
(v) A special method member called the _______ method is used to initialize the data members of the class.
a) Variable
b) Constructor
c) Private
d) Package
(vi) A Java compiler instead of translating Java code to machine language code, translates it into _______.
Ans: java Bytecode
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) char Section=’A’;
b) String First_Name=”Arun”;
c) int Num==10;
d) double percentage = 87.6;
(ii) A ______ is an arithmetic operator that returns the remainder of division of values of operands.
Ans: % (modulus)
(iii) An application that can be accessed via a web browser, over a network connection is called a ______ application.
Ans: Web-based
(iv) Prerna wants to ensure that while data entry, the ADMNO field should not be left blank. Name the constraint that should be used.
Ans: Constraint NOT NULL should be used to ensure data entry in a field
(v) Which of the following command is used to retrieve information from a database?
a) INSERT
b) SELECT
c) UPDATE
d) CREATE
(vi) How does e-governance benefits its citizens?
Ans: E-governance empowers the citizens socially and economically, and enhances their lives by providing them with quality information and better services. It enables citizens to access information directly, without paying any money to a middleman or a tout. It ushers transparency in the system.
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 List any two importance of self-motivation.
Ans: (i) Helps in Achieving Goals - Self-motivation keeps you focused and driven toward your goals, ensuring consistent effort and progress.
(ii) Builds Confidence & Resilience - It boosts self-confidence and helps overcome challenges by maintaining a positive attitude and determination.
Q.8 What is active listening? List any two factors that affect active listening.
Ans: Active listening is an art, which comprises both a desire to comprehend, as well as, offer support and empathy to the speaker. It can affect your job effectiveness, the quality of your relationship with others, and
hence, your overall well-being. Active listening allows you to understand the problems and collaborate to develop solutions.
The various factors that affect active listening are as follows:
(i) Eye contact (ii) Giving feedback
Q.9 Do you think there are toxins in our environment? What is your view of toxins in our homes?
Ans: Well, yes, there are toxins present in our environment and environment including our homes also. Hence, the role of green jobs in our homes is to make them toxin free so that we have a healthy life. Toxins may be present in our homes in many ways such as – refrigerators releasing CFCs, cleaning and washing products, cosmetics, upholstery fabrics, rugs, mattresses, paint used on the walls, chemicals used to polish the floors, fragrances, some kind of clothes that uses chemicals, use of RO and Microwaves in our kitchens etc. So, in order to ensure that our homes are safe from toxins and healthy places to breathe, people with green collar jobs help us maintain a healthy environment.
Q.10 What is sorting in a spreadsheet? Can data be sorted on more than one column?
Ans: Once you have entered data and applied relevant formulas in a worksheet, you can arrange the data in ascending or descending order. This is called sorting of data. Sorting on numerical and textual values is one of the main features of any spreadsheet software. Yes data can be sorted on more than one column that is called multi-level sorting.
Q.11 Name any two Qualities of a successful entrepreneur.
Ans: The following are some of the qualities of a successful entrepreneur:
(i) Initiative - The ability to take proactive steps and act on new opportunities without waiting for direction.
(ii) Willingness to take risks - The courage to make bold decisions and invest in uncertain situations to achieve business success.
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:
int Num=4;
int Fact=1;
for (int i=1;i<=Num;i++)
{
Fact*=i;
System.out.println(Fact);
}
Ans:
1
2
6
24
Q.13 Rajni is assigned the task to maintain the SQL database for PowerStock Ltd. She has created a table named STOCKDATA with the following structure:
Stock_id integer PRIMARY KEY
Symbol char(10)
Value integer(5)
Type char(10)
The table presently contains following data:
| Stock_id | Symbol | Value | Type |
|---|---|---|---|
| 2624 | REL | 6653 | Sell |
| 7660 | INFY | 3064 | Buy |
| 4361 | NFY | 3117 | Buy |
| 7292 | TC | 6865 | Buy |
The company wants the attribute Value for the table to store values as real numbers with a precision upto 4 decimal places.
a) What SQL statement Rajni should write to make the desired change?
Ans: ALTER TABLE STOCKDATA MODIFY COLUMN (VALUE FLOAT);
b) What SQL statement will she write if all the values of the Value attribute in the existing table STOCKDATA are to be increased by 25%?
Ans: UPDATE STOCKDATA SET VALUE=VALUE*1.25;
Q.14 Mention any two usages of a Database Management System in Education.
Ans: Usages of DBMS in Education are:
(i) For storing information about faculty and staff members.
(ii) For storing information such as student details, marks and result.
Q.15 A school is making database of its teachers and students. Table TEACHER includes TeaCode, TName, TSubject, TDOJ, TDesig.
Give details of table STUDENT along with its schema.
Ans: STUDENT (StuID, StuName, Class,Sec, TeaCode, ContactNo)
| Name | Type | Remarks |
|---|---|---|
| StuID | INT(10) | Student number (Primary Key) |
| StuName | VARCHAR(30) | Name of the student |
| Class | INT(2) | Class of the student |
| Sec | CHAR(1) | Section of the student |
| TeaCode | INT(10) | Teacher code (Foreign Key) |
| ContactNo | CHAR(10) | Student contact number |
Q.16 Rewrite the following code after correcting the syntax errors, underline each correction made:
int number= = 1;
while (number <= 5);
{
System.out.print("Square of " + number);
System.out.println(" = " , number*number);
Number+=1;
}
Ans:
int number = 1;
while (number <= 5)
{
System.out.print("Square of " +number);
System.out.println(" = " +number*number);
number+=1;
}
Answer any 2 out of the given 3 questions in 30– 50 words each (3x2=6 Marks)
Q.17 Convert the following Java code from for loop to while loop without changing the logic.
int X=4,Y=3;
int Pow=1;
for (int i=1;i<=Y;i++)
Pow*=X;
System.out.println(Pow);
Ans:
int X=4,Y=3;
int Pow=1;
int i=1;
while(i<=Y)
{
Pow*=X;
i++;
}
System.out.println(Pow);
Q.18 (a) Define Referential Integrity.
Ans: Referential integrity is a term used in database design to describe the relationship between two tables. Referential integrity is the logical dependency of a foreign key on a primary key.
(b) Consider the following table TEACHER and answer the following questions:
Table: TEACHER
| TID | TNAME | DOA | DEPT | PAY |
|---|---|---|---|---|
| 501 | SUBHAV JAIN | 2014-07-09 | COMPUTER | 450000 |
| 203 | SHUBH NANGIA | 2009-11-23 | CHEMISTRY | 340000 |
| 510 | VARUN KAPOOR | 2015-02-15 | HINDI | 320000 |
| 307 | KAMAL PATRA | 2010-12-29 | ACCOUNTS | 310000 |
| 490 | SUJAN REDDY | 2012-09-11 | ENGLISH | 270000 |
| 370 | IKAT GOSWAMY | 2011-05-08 | COMPUTER | 510000 |
DOA - Date of Appointment, DEPT - Department
Write the statements:
i) To display the number of teachers and the corresponding department name, in each department.
Ans: SELECT count(TNAME), DEPT FROM TEACHER GROUP BY DEPT;
ii) To display the minimum PAY of teachers whose Date of Appointment is after 2010.
Ans: SELECT min(PAY) FROM TEACHER WHERE DOA IS BETWEEN "2010-01-01" AND "2010-12-31";
Q.19 Differentiate between DROP and DELETE commands in SQL with appropriate examples.
Ans:
| DROP | DELETE |
|---|---|
| Used to remove the entire table from the database. | Used to remove specific records (rows) from a table. |
| Deletes both table structure and data. | Deletes only the data, table structure remains. |
| WHERE clause cannot be used. | WHERE clause can be used to delete specific rows. |
| Example: DROP TABLE student; | Example: DELETE FROM student WHERE rollno = 10; |
Answer any 3 out of the given 5 questions in 50– 80 words each (4x3=12 Marks)
Q.20 (a) Give the output for the following code:
String myString = "Welcome to Java";
System.out.println (myString.concat("Session"));
System.out.println (myString.length());
System.out.println (myString.replace("to","2"));
Ans: Welcome to Java Session
15
Welcome 2 Java
(b) Expand the term OOP.
Ans: Object Oriented Programming
Q.21 (a) Name any two educational websites that provide online courses for free, in collaboration with various universities across the globe.
Ans: coursera.org and edx.org provide high quality online courses for free, in collaboration with various universities across the globe.
(b) What is a project?
Ans: A project is a task that is undertaken to create a unique product, service, or result.
(c) The process of development of web based applications is broadly categorized in four phases. List down the Phases in a Web Application Project.
Ans: The process of development of web based applications is broadly categorized in four phases. During the development process, one needs to follow the following four main phases of development:
i) Requirements Definition Phase
ii) Design Phase
iii) Implementation Phase
iv) Testing Phase
Q.22 (a) Consider the following co and answer the following questions:
static int MyMethod(int N)
{ return (N*N); }
public static void main(String[] args) { System.out.println(MyMethod(7)); }
i) Name the user defined method.
Ans: MyMethod
ii) What will be the output on executing the above code?
Ans: 49
(b) What is exception handling in Java? Explain the terms try and catch in exception handling.
Ans: Exception Handling in Java: Exception handling is a mechanism in Java that handles runtime errors so that the normal flow of the program can continue or terminate properly. It prevents the program from crashing when an error occurs.
try: It contains the code that may cause an exception. Java monitors this block for errors.
catch: It handles the exception that occurs in the try block and prevents the program from terminating abruptly.
Q.23 (a) What are Arrays? Give an example.
Ans: Arrays are variables that can hold more than one value, they can hold a list of values of the same type.
One way to declare an array is :
marks = new double[5];
(b) Write Java code to do the following:
i) Create an array Marks that stores values 78,65,85,91,82
Ans: double[] Marks = {78,65,85,91,82};
ii) To print all the values of the array Marks using a loop.
Ans: for (int i = 0; i< 5; i++)
System.out.println(Marks[i]);
iii) Display the average stored in the array Marks.
Ans: System.out.println((Marks[0] + Marks[1]+ Marks[2]+ Marks[3] +Marks[4])/5);
Q.24 Consider the following tables - TRAIN and PASSENGER:
Table: TRAIN
| TID | TName | Boarding | Destination | Cost |
|---|---|---|---|---|
| 305 | VandeBharat | New Delhi | Katra | 2500 |
| 206 | Shatabdi | Mumbai | Delhi | 3500 |
| 307 | Superfast | Lucknow | Chennai | 4500 |
| 208 | HolidayExpress | Goa | Delhi | 2000 |
Table: PASSENGER
| PID | TID | Name | DOT |
|---|---|---|---|
| P108 | 307 | Gagandeep Singh | 14-10-2022 |
| P209 | 206 | Rahat Ali | 01-01-2023 |
| P110 | 305 | Cristopher | 10-12-2022 |
| P677 | 208 | Diksha Luther | 11-09-2019 |
| P555 | 307 | Nira Kadam | 06-11-2020 |
| P211 | 208 | Ritam Ahuja | 17-12-2021 |
Write SQL queries for the following:
(a) To display the count of passengers travelling by each train
Ans: Select count(Name),TName from Train, Passenger where Train.TID=Passenger.TID group by TName;
(b) To add a new record in the table TRAIN:
(12471, “Garib Rath”, “New Delhi”, “Mumbai”, 1105)
Ans: Insert into Train values (12471, “Garib Rath”, “New Delhi”, “Mumbai”, 1105);
(c) To display TName, Name and Boarding of all passengers.
Ans: Select TName, Name, Boarding from Train, Passenger where Train.TID=Passenger.TID;
(d) To display details of all trains whose cost is between 3000 and 5000.
Ans: Select * from Train where cost between 3000 and 5000;
Download Now - Class 12 IT 802 Sample Question Paper 2024-25 with Solution
