Sample papers are extremely important for CBSE board exam preparation because they help students improve time management, accuracy, and conceptual understanding. When students regularly solve sample question papers, they become familiar with the structure of the exam and can identify their strong and weak areas. CBSE Class 12 IT (802) Sample Question Paper 2019-20 with detailed solutions also helps learners understand the correct approach to answering questions and scoring better marks. Practicing sample papers along with revision and previous year question papers is one of the best strategies to perform well in the CBSE Class 12 Information Technology board examination.
Preparing for the CBSE Class 12 Information Technology (802) Board Exam becomes much easier when students practice with the right study resources. One of the most effective preparation tools is solving CBSE sample question papers. The CBSE Class 12 IT (802) Sample Question Paper 2019-20 with Solution helps students understand the latest exam pattern, marking scheme, and types of questions asked in the board examination. By practicing this sample paper, students can evaluate their preparation level, improve their problem-solving skills, and gain confidence before appearing in the final exam. Teachers can also use this sample paper to guide students and conduct practice tests in the classroom.
CBSE Class 12 IT 402 Sample QP 2019-20 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 (2019-20)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 802)
Sample Question Paper (SQP) Solution for Class XII (Session 2019-2020)
Max. Time: 3 Hours
Max. Marks: 60
General Instructions:
- This Question Paper consists of two parts viz. Part A: Employability Skills and Part B: Subject Skills.
- Part A: Employability Skills (10 Marks)
- Answer any 4 questions out of the given 6 questions of 1 mark each.
- Answer any 3 questions out of the given 5 questions of 2 marks each.
- Part B: Subject Skills (50 Marks)
- Answer any 10 questions out of the given 12 questions of 1 mark each.
- Answer any 5 questions from the given 7 questions of 2 marks each.
- Answer any 5 questions from the given 7 questions of 3 marks each.
- Answer any 3 questions from the given 5 questions of 5 marks each.
- This question paper contains 42 questions out of which 30 questions are to be answered.
- All questions of a particular part/section must be attempted in the correct order.
- The maximum time allowed is 3 hrs
PART A: EMPLOYABILITY SKILLS (10 MARKS)
Answer any 4 questions out of the given 6 questions of 1 mark each:
1. A complex sentence is a sentence that combines one ______ clause with at least one dependent clause.
Ans: independent
2. Self-motivation increases individuals’ ________ and ________.
Ans: energy, activity
3. What is the shortcut key to insert current date in a cell?
a) CTRL + ;
b) CTRL + T
c) CTRL + D
d) CTRL + ’
4. In ________ form of business, the finished product can be directly sold to the customer.
Ans: manufacturing
5. Green building offers a chance to be part of the solution to _______.
Ans: global challenges
6. Music is one of the source of _________.
Ans: Self-motivation
Answer any 3 questions out of the given 5 questions of 2 marks each:
7. Explain the any two types of Verbal Phrases with the help of suitable examples.
Ans: A verbal phrase is a group of words that starts with a verb form but works like another part of speech in a sentence.
There are three types of verbal phrases:
- Participial Phrase
- Gerund Phrase
- Infinitive Phrase
1. Participial Phrase: It starts with a present participle (-ing form) or a past participle (-ed / -en form) and describes a noun or pronoun.
Examples: Watching silently, the teacher observed the students.
Driven to succeed, she studied very hard.
Here, the phrases "Watching silently" and "Driven to succeed" describe someone in the sentence.
2. Gerund Phrase: It begins with a gerund (-ing form of a verb) and works like a noun in a sentence.
Examples: Practicing every day helps a lot. (Subject)
I enjoy reading books. (Object)
Here, the phrases "Practicing every day" and "reading books" act like nouns.
8. What is the source of self motivation?
Ans: (i) Having clear goals in life motivates a person to work harder and stay focused to achieve success.
(ii) A positive attitude helps a person believe in their abilities and stay motivated even during difficult situations.
9. Write down the steps to insert picture from file.
Ans: Steps to Insert a Picture from a File
Step 1: Click on the Insert menu.
Step 2: Select Picture → From File option.
Step 3: The Insert Picture dialog box will appear.
Step 4: Select the picture file you want to insert.
Step 5: Click on the Open button.
10. Differentiate between Manufacturing business and trading business.
Ans:
| Manufacturing Business | Trading Business |
|---|---|
| A manufacturing business produces or makes goods from raw materials. | A trading business buys and sells finished goods. |
| It converts raw materials into finished products. | It does not produce goods, it only sells them. |
| It requires machines, labor, and production process. | It mainly requires buying and selling activities. |
| Example: A company making furniture from wood. | Example: A shop selling ready-made furniture. |
11. Write any four steps that green jobs can take to reduce greenhouse gas emission.
Ans: (i) Green jobs promote the use of renewable energy sources such as solar, wind, and hydro power instead of fossil fuels.
(ii) They encourage the use of energy-efficient machines, appliances, and lighting to reduce energy consumption.
(iii) Green jobs focus on reducing, reusing, and recycling waste to lower pollution and emissions.
(iv) They promote the use of electric vehicles, public transport, and bicycles to reduce fuel consumption.
(v) Encouraging tree plantation and sustainable environmental practices helps absorb carbon dioxide and reduce greenhouse gases.
PART B: SUBJECT SKILLS (50 MARKS)
Answer any 10 questions out of the given 12 questions:
12. _________ is a collection of raw facts which have not been processed to reveal useful information.
Ans: Data
13. Define Data Redundancy.
Ans: Data Redundancy is the situation where the same data is stored in multiple places in a database.
14. ________ constraint is used to restrict the values of an attribute within a range.
Ans: Check
15.________ command is used to modify the base table definition.
a) Create Table
b) Alter Table
c) Update Table
d) Modify Table
16. _________ is a special method that every Java application must have.
a) Getter
b) Setter
c) Main
d) Default
17. ________ method test whether this string end with the given suffix or not.
Ans: endsWith
18. The ________ method of Array class is used to arrange the Array of integers in ascending order.
Ans: sort()
19. Which of the following is not an example of eGovernance?
a) To file property tax
b) To apply for renewal of Passport
c) To start an online coding course for 3 months
d) To get Voters ID card issued
20. What are webinars?
Ans: Webinars are live online lectures where people can attend, ask questions, and get answers in real time.
21. Finding of Bugs and Fixing them happens in _________.
a) Design Phase
b) Testing Phase
c) Implementation Phase
d) Requirement Definition Phase
22. Choose the correct sequence to be followed while buying online.
i. Provide your details (Or login into your bank account)
ii. Add items in shopping cart
iii. Choose payment option (Make payment if not cash on delivery)
iv. Select Buy option
a) iii, iv, ii, i
b) ii, iv, iii, i
c) iv, ii, iii, i
d) i, iii, ii, iv
23. Predict the output of the following expression of the initial value of x is 5.
x=((++x)*2)+7
a) 19
b) 21
c) 18
d) 20
Answer any 5 questions out of the given 7 questions of 2 marks each:
24. Illustrate any two DML commands with the help of suitable example.
Ans: DML (Data Manipulation Language) commands are used to add, modify, delete, and retrieve data from a database table.
(i) INSERT: Used to add new data into a table.
Example: INSERT INTO Student VALUES (101, 'Ravi', 12);
(ii) UPDATE: Used to modify existing data in a table.
Example: UPDATE Student SET Name = 'Rahul' WHERE RollNo = 101;
(iii) DELETE: Used to remove data from a table.
Example: DELETE FROM Student WHERE RollNo = 101;
25. List any four advantages of DBMS.
Ans: (i) Reduces Data Redundancy: DBMS reduces duplicate data by storing data in a centralized database.
(ii) Improves Data Security: DBMS protects data by allowing only authorized users to access it.
(iii) Easy Data Sharing: DBMS allows multiple users to access and share data at the same time.
(iv) Backup and Recovery: DBMS provides backup and recovery features to restore data if it is lost.
(v) Data Consistency: DBMS maintains accurate and consistent data in the database.
26. Explain the concept of Candidate Key with the help of a suitable example.
Ans: A Candidate Key is a field or a set of fields in a table that can uniquely identify each record in that table. A table may have more than one candidate key, but only one of them is selected as the Primary Key.
| RollNo | AadharNo | Name | Class |
|---|---|---|---|
| 101 | 234567890123 | Rahul | 12 |
| 102 | 345678901234 | Neha | 12 |
In this table, RollNo and AadharNo can uniquely identify each student.
So, RollNo and AadharNo are Candidate Keys.
27. What is the purpose of using default in a switch statement?
Ans: The default statement is executed when the value of the expression does not match any of the case values in the switch statement.
switch(dy)
{
case 6:
day = "Saturday";
break;
case 7:
day = "Sunday";
break;
default:
day = "Incorrect Day";
break;
}
System.out.println(day);
If the value of dy is other than 6 or 7, the default statement will be executed.
28. The following code has error(s). Rewrite the correct code underlining all the corrections made:
int n=15,
int i=10,x=1;
do;
{
x=x*i;
i++;
while[i<=n]
jTextField1.settext(""+x);
Ans:
int n = 15; // corrected ',' to ';'
int i = 10, x = 1;
do // removed ';' after do
{
x = x * i;
i++;
}
while (i <= n); // corrected [ ] to ( ) and added ';'
jTextField1.setText("" + x); // corrected settext to setText
29. Rewrite the following code using WHILE loop:
int x=100;
for(int i=2;i<=22;i=i+4)
{
jTextArea1.append("\n"+(i+x));
x=x-2;
}
Ans:
int x = 100;
int i = 2;
while(i <= 22)
{
jTextArea1.append("\n" + (i + x));
x = x - 2;
i = i + 4;
}
30. Explain important phases of Web Application Development.
Ans: (i) Requirement Definition Phase: In this phase, the problem and purpose of the web application are identified.
(ii) Design Phase: In this phase, the structure and layout of the application are planned.
(iii) Implementation Phase: In this phase, the frontend, backend, and database are created and connected.
(iv) Testing Phase: In this phase, the complete application is tested using different sets of data to check if it works correctly.
Answer any 5 questions out of the given 7 questions of 3 marks each:
31. What is the purpose of group by command? How is it different from Order by command? Give example.
Ans: GROUP BY clause is used with aggregate functions such as COUNT, MAX, MIN, SUM, AVG to group rows having the same values in one or more columns.
Example: SELECT Dept_No, COUNT(*) AS No_of_Teachers FROM Teacher GROUP BY Dept_No;
ORDER BY clause is used to sort the result in ascending or descending order.
Example: SELECT First_Name, Last_Name FROM Teacher ORDER BY First_Name;
32. Radha has given the following query, she is unable to run due to errors, rectify the errors and underline the correction made:
(a) Select unique department from employee;
Ans: Select distinct department from employee;
(b) Select * from employee where name =”%a”;
Ans: Select * from employee where name like ”%a”;
(c) Select name, salary from employee where phone = Null;
Ans: Select name, salary from employee where phone IS Null;
33. A garment Company is planning to launch its website and a Mobile App. Mention various factors that the company shall keep in mind to attract people for online shopping.
Ans: Following are the factors to be kept in mind
(i) It shall have easy to use interface : simple design for the end user to interact easily.
(ii) Website must be secured and must be free from malware.
(iii) It shall not leak customer details and must provide different payment methods such as Credit card/ debit card/ COD etc.
(iv) Must provide good offers/ deals to the user.
34. With an alarming rate of increase in Cyber fraud write at least three points to be kept in mind while making an online transactions.
Ans: Following points to be considered:
(i) Avoid using public Wi-Fi
(ii) Keep your device protected with updated antivirus
(iii) Always use SSL protected sites.
Some precautions to keep safe passwords:
(i) Make a password complex, like mix case, use numbers and special characters. This decreases ability of automated attacks by trying different character combinations.
(ii) Be cautious not to leave passwords around and do not share them with friends.
(iii) Never use names of near and dear ones as passwords.
35. What are variables? What are the rules to be followed while naming a variable. Give example.
Ans: A variable is a name given to a memory location used to store data, and its value can change during program execution.
Example: int age = 20;
Rules for Naming Variables
(i) Variable names must begin with a letter, underscore (_), or dollar sign ($).
Example: age, _count, $total
(ii) Variable names can contain letters, digits, and underscore only.
Example: marks1, total_marks
(iii) Variable names cannot contain spaces.
(iv) Variable names must not be Java reserved words.
Example: int, class, while cannot be used as variable names.
(v) Java is case-sensitive, so variable names with different cases are different.
Example: Total and total are two different variables.
36. How are exceptions handled in Java? Explain with the help of a suitable example.
Ans: An exception is an unexpected error that occurs during program execution and may cause the program to terminate.
In Java, exceptions are handled using the following keywords:
(i) try - The try block contains the code that may cause an exception.
(ii) catch - The catch block handles the exception when it occurs.
(iii) finally - The finally block (optional) always executes whether an exception occurs or not.
Example: Division by Zero Exception
try
{
int quotient = 10 / 0;
System.out.println(quotient);
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
In this example, division by zero causes an exception, which is handled by the catch block, preventing the program from crashing.
37. State the potential areas of Work Integrated Learning in the field of education.
Ans: Work Integrated Learning can be used in the following areas:
(i) Storing student information such as student details, marks, and results.
(ii) Maintaining faculty and staff records including teaching, non-teaching, and support staff members.
(iii) Managing institutional information such as infrastructure details, transport, library, fees, departments, and courses offered.
Answer any 3 questions out of the given 5 questions of 5 marks each:
38. Consider the following and answer the questions.
(a) Wrtite a query to create a table TravelAgency.
| AgentCode | CHAR(4) | Primary Key |
| AgentName | VARCHAR(20) | NOT NULL |
| Location | VARCHAR(25) | - |
| Package | VARCHAR(30) | - |
| Charges | DECIMAL | - |
Ans: Create table TravelAgency
(AgentCode char(4) primary key,
AgentName varchar(20),
Location Varchar(25),
Package Varchar(30),
Charges decimal));
(b) Wtite a query to add a new row to a table TravelAgency
(“A006”, “John Sharon”, “Sam Ana Travel”, “Domestic”, 45000)
Ans: Insert into TravelAgency values (“A006”, “John Sharon”, “Sam Ana Travel”, “Domestic”, 45000);
(c) Write a query to add a new column EmailId to a table TravelAgency
Ans: Alter table TravelAgency Add EmailId varchar(30);
39. Mention any three advantanges of Online reservation and two challenges faced by end user while booking online railway ticket.
Ans: Advantages of Online Reservation
(i) Users can book tickets anytime and from anywhere.
(ii) Customers can check prices and compare options before booking.
(iii) Users can view seat availability and select their preferred seat.
Challenges Faced by End Users
(i) Security issues while making online payments, especially on public networks.
(ii) Different cancellation policies, which may confuse users or cause inconvenience.
40. What are the objectives of eGovernance? How does eGovernance empowers the citizens.
Ans: e-Governance (Electronic Governance) refers to the use of Information and Communication Technology (ICT) by the government to provide services and information to citizens.
The main objectives of e-Governance are:
(i) To provide easy access to government information and services.
(ii) To improve transparency and accountability in government work.
(iii) To make government services faster and more efficient.
Example: India.gov.in
How e-Governance Empowers Citizens:
(i) It provides citizens with quality information and better public services.
(ii) Citizens can access government services directly online without middlemen or agents.
(iii) It increases transparency and reduces corruption in the system.
41. Write a JAVA program (method) to develop an application in JAVA to calculate Marks in 5 subjects and show the percentage of Students.
Ans: float m1, m2, m3, m4, m5, total, perc;
m1 = Float.parseFloat(jTextField1.getText());
m2 = Float.parseFloat(jTextField2.getText());
m3 = Float.parseFloat(jTextField3.getText());
m4 = Float.parseFloat(jTextField4.getText());
m5 = Float.parseFloat(jTextField5.getText());
total = m1 + m2 + m3 + m4 + m5;
perc = (total / 500.0f) * 100;
jTextField6.setText(Float.toString(perc));
42. (a) Define Constructors . Also write two charactertics of a constructor.
Ans: A constructor is a special method of a class that is used to initialize the data members of an object when the object is created.
Characteristics of a Constructor:
(i) A constructor has the same name as the class and does not have any return type. It may or may not have parameters.
(ii) A constructor is automatically called when an object of the class is created.
(b) What is a wrapper class? Explain with the help of a suitable example.
Ans: A Wrapper Class is a class whose object wraps (contains) a primitive data type. It converts primitive data types into objects. Each primitive data type in Java has a corresponding wrapper class.
Examples:
int → Integer
float → Float
char → Character
Example
Integer num = Integer.valueOf("25");
System.out.println(num);
In this example, the Integer wrapper class converts the string "25" into an integer value.
Download Now - Class 12 IT 802 Sample Question Paper 2019-20 with Solution
