Students preparing for the CBSE Class 12 Information Technology (802) board exam should practice sample question papers regularly. The CBSE Class 12 IT 802 Sample Question Paper 2020-21 with solution helps students understand the exam pattern, types of questions, and marking scheme. Solving this paper allows students to evaluate their preparation and improve their time management skills before the final examination.
Advantage of solving the CBSE IT 802 sample question paper with answers is that students can easily check their solutions and identify their weak areas. The detailed solutions help students learn the correct approach to answering questions, writing SQL commands, and explaining theoretical concepts clearly.
Students are advised to download the CBSE Class 12 IT 802 Sample Question Paper 2020-21 PDF with solutions and solve it in exam-like conditions. This practice will help them improve accuracy, speed, and overall performance in the board examination. Teachers and students also use Class 12 IT 802 solved sample papers for revision and self-assessment. Regular practice improves confidence and helps students score better marks in the CBSE Class 12 Information Technology (802) examination.
CBSE Class 12 IT 402 Sample QP 2020-21 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 (2020-21)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 802)
Sample Question Paper (SQP) Solution for Class XII (Session 2020-2021)
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 it important to clearly communicate instructions, ideas and concepts that can help you find success in any career? State True or False.
Ans: True
(ii) All formulae in Spreadsheet begin with _____ sign.
a) &
b) =
c) @
d) #
(iii) _________ work in collaboration with Green Builders to lay the idea of how the building will look like after its completion. They also provide artistic beauty to buildings to make them look innovative and interesting.
Ans: Green Design Professionals
(iv) List one benefit of Team Building.
Ans: (i) Enhanced Problem-Solving Skills
(ii) Higher Motivation and Morale
(iii) Improved Productivity
(v) ________ is feeling extremely nervous and worried because you believe that other people do not like you or are trying to harm you.
a) Paranoid
b) Antisocial
c) Narcissistic
d) Dependent
(vi) Personality affects all aspects of an individual’s performance, enlist any two personality traits.
Ans: (i) Confidence (ii) Honesty (iii) Responsibility (iv) Self-discipline (v) Positive Attitude
Q.2 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) __________ command is used to modify the value of attribute of one or more tuple in a table.
a) Update
b) Modify
c) Alter
d) Create
(ii) Keyword used to display the structure of the table.
a) Describe
b) Show
c) Select
d) Display
(iii) __________ method of a String Class returns true if the length of this string is 0.
a) indexAt()
b) length()
c) isEmpty()
d) indexOf()
(iv) _________ Constraint is used to restrict the values of an attribute within a range.
Ans: Check
(v) What are member methods?
Ans: Member methods are functions defined inside a class that work with the objects of that class. They are used to access or change the data members (variables) of the class.
(vi) Give one online website of B2C (Business to Consumer) segment.
Ans: Amazon, Flipkart, Myntra, Ajio, Nykaa, Firstcry
(vii) What is the importance of password field on online reservation site?
Ans: The password field on an online reservation site is important because it protects the user’s account and personal information.
Q.3 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) Predict the Output
int x=9, k=0;
int y=10;
y=++x;
x+=y;
k=x;
What will be the value of k?
Ans: 20
(ii) ________ is an e-commerce application where the customer can purchase goods over the Internet.
Ans: Online shopping
(iii) ___________ Phase of Web Application development problem statement for which the web application is to be developed is identified.
a) Requirement
b) Design
c) Implementation
d) Test
(iv) select distinct dept_name from department;
What does the above query do?
a) It gives all the tuples having dept_name
b) It gives the dept_name attribute values of all tuples without repetition
c) It gives all the dept_name attribute of all the tuples
d) It gives all the dept_name attribute of all the tuples
(v) Define Referential Integrity.
Ans: Referential Integrity means ensuring that relationships between tables in a database remain accurate and consistent.
(vi) Identify the type of operator used
If (A>=B)
a) Arithmetic
b) Relational
c) Logical
d) Assignment
(vii) E business offers advantages and opportunities, there are also risks and barriers. These include
a) Violation of customer privacy
b) Spikes causing websites to fail at peak times
c) Internet hackers penetrating company security
d) All of the above
Q.4 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) What is an Object?
Ans: It is an instance of a class.
(ii) Predict the output
double[ ]Qty = {346, 142, 103, 26.5, 387.5};
System.out.println(Qty[3]);
Ans: 103
(iii) Define Shopping cart.
Ans: A shopping cart is an online tool where customers add and keep the products they want to buy before making payment on a website.
(iv) _________ is not an aggregate function.
a) Sum()
b) Count()
c) Round()
d) Avg()
(v) _________ replaces zero or more number of random character, when used with Like keyword.
a) _
b) %
c) $
d) @
(vi) _________ is a special method that every Java application must have.
a) Getter
b) Setter
c) Main
d) Default
Q.5 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) ___________ Phase of Web Application development problem statement for which the web application is to be developed is identified.
a) Requirement
b) Design
c) Implementation
d) Test
(ii) _________ method of a String Class Return the index of the first occurrence of given substring.
a) indexOf()
b) indexAt()
c) length()
d) isEmpty()
(iii) ________ command which displays list of databases available on the current server.
a) Show databases
b) Show tables
c) Create tables
d) Display table
(iv) Define Data Redundancy.
Ans: Data Redundancy means the repetition of the same data in a database.
(v) _________ is a collection of raw facts which have not been processed to reveal useful information.
Ans: Data
(vi) ________ method test whether this string end with the given suffix.
Ans: endsWith
Q.6 Answer any 5 out of the given 7 questions (1x5=5 Marks)
(i) Which SQL keyword is used to sort the result?
a) ORDER BY
b) SORT
c) ORDER
d) SORT BY
(ii) __________ commands deletes the tuples from a Table.
a) Drop
b) Delete
c) Modify
d) None of the above
(iii) Define JVM.
Ans: JVM (Java Virtual Machine) is a program that runs Java bytecode and allows Java programs to run on different operating systems.
(iv) Which of the following is not an example of e-Governance.
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
(v) Which of the following is an invalid variable declaration?
a) my_string_1
b) 1st_string
c) my string 1
d) _mystring1
(vi) Name one front end and one Back end application to create Web Applications.
Ans: Front End Application: HTML, Java NetBeans
Back End Application: PHP, MySQL
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 Sandeep has to appear for his first job interview. Mention at least 2 points he shall keep in mind before appearing.
Ans: (i) Research the company - Learn about the company, its work, and services.
(ii) Prepare your resume - Carry updated copies of your resume.
(iii) Dress professionally - Wear clean and formal clothes.
(iv) Be punctual - Reach the interview venue on time.
Q.8 Self-Motivation is significant in building one's personality. Comment.
Ans: Self-Motivation is very important in building one's personality. It encourages a person to work hard and achieve goals without depending on others. A self-motivated person stays positive, confident, and focused even during difficulties.
Q.9 What is Cell referencing in a spreadsheet?
Ans: Cell Referencing in a spreadsheet means referring to a cell by its column letter and row number (such as A1, B2) to use its value in formulas or calculations. It is called cell address or cell.
Q.10 Rohan has a successful startup company. According to him ‘Decision Making is considered to one of the important entrepreneurial competency’. Do you agree with Rohan’s opinion? Justify.
Ans: Yes, I agree with Rohan's opinion. Decision making is an important entrepreneurial competency because an entrepreneur has to take many important decisions related to business, such as planning, investment, and problem solving. Good decision making helps in choosing the right opportunities, solving problems quickly, and achieving business success.
Q.11 What is the role of Water Quality technician?
Ans: The role of a Water Quality Technician is to monitor, test, and analyze water quality to ensure it is safe and clean for use. They collect water samples, check for pollution or harmful substances, and help in treating water to maintain safe water standards.
Answer any 3 out of the given 5 questions in 20 – 30 words each (2x3=6 Marks)
Q.12 Explain Drop table with Cascade command.
Ans: DROP TABLE with CASCADE command is used to delete a table along with all the dependent objects such as constraints, views, or references related to that table.
Example:
DROP TABLE table_name CASCADE;
Q.13 The following code has some error(s). Rewrite the correct code underlining all the corrections. Also categorize the loop as Entry / Exit Control Loop.
int p
p = 14;
do;
p = p-2;
System.out.displayln(p);
}while p >= 2
Ans:
int p;
p = 14;
do {
p = p - 2;
System.out.println(p);
} while (p >= 2);
Q.14 Differentiate between = and = = operator in JAVA.
Ans: = is an assignment operator. It is used to assign a value to a variable.
Example: int a = 10; → assigns the value 10 to variable a.
= = is a comparison operator. It is used to compare two values and check if they are equal.
Example: a = = 10 → checks whether the value of a is equal to 10.
Q.15 Explain Work integrated learning with respect to education sector.
Ans: Work Integrated Learning in the education sector refers to learning that combines classroom education with practical work experience. It helps students apply their theoretical knowledge in real-life situations.
In the education sector, computer-based systems and databases are used:
(i) To store information about students, such as student details, marks, and results.
(ii) To maintain records of faculty and staff members.
(iii) To store details about the school or college, such as infrastructure, departments, and courses offered.
Q.16 A company is making database of Employees having personal details and Salary details
Personal details have columns Empid, Name, Address, BloodGroup.
Suggest Columns for Salary Table
Ans: EmpID, BasicSalary, Leave, Deductions, Allowances, NetSalary
Answer any 2 out of the given 3 questions in 30– 50 words each (3x2=6 Marks)
Q.17 How eGovernance does empowers the citizens. Give 3 points.
Ans: e-Governance empowers citizens in the following ways:
(i) Easy access to government services through online portals.
(ii) Saves time and cost as people do not need to visit government offices.
(iii) Increases transparency in government processes.
(iv) Reduces corruption by minimizing direct contact with officials.
Q.18 Predict the output of the following code; Also categorize the loop as Entry / Exit Control Loop.
int j=1,s=0;
while (j<10)
{
System.out.print(j+"+");
s=s+j;
j=j+j%3;
}
System.out.println("="+s);
Ans: Output: 1+2+4+5+7+8+=27
while loop is an Entry Control Loop because the condition is checked before entering the loop body.
Q.19 (i) Mention at least 2 work areas which uses Database Management Systems.
Ans: (i) School Management, (ii) Hotel Management, (iii) Railway reservation, (iv) Employee management
(ii) Jatin has given the following query from the table Student but he is unable to execute it successfully. Write the correct query after rectifying the error.
Select Name, Marks From student Table Where Name ="P%";
Ans: SELECT Name, Marks FROM Student WHERE Name LIKE "P%";
Answer any 3 out of the given 5 questions in 50– 80 words each (4x3=12 Marks)
Q.20 Consider the following table and write SQL statements.
Table Menu
| ID | Item | Description | Price |
|---|---|---|---|
| P001 | Sambar Vada | South Indian | 40 |
| P002 | Dal Maakhani | North Indian | 150 |
| P003 | Noodles | Chinese | 100 |
| P004 | Idli Sabar | South Indian | 50 |
| P006 | Sarson Saag | North Indian | 170 |
| P007 | Dosa | South Indian | 120 |
| P008 | Pizza | Italian | 200 |
(i) To add a new row with the following data
"P009", "Lemon Rice", "South Indian", 140
Ans: Insert into Menu values ("P009", "Lemon Rice", "South Indian", 140);
(ii) Display details of all Menu items in the descending order of Price
Ans: SELECT * FROM Menu ORDER BY Price DESC;
(iii) Display Item and Description of those Items whose price is between 100 and 150
Ans: SELECT Item, Description FROM Menu WHERE Price BETWEEN 100 AND 150;
(iv) Add a new column Rating datatype as int to the table Menu
Ans: ALTER TABLE Menu ADD Rating INT;
Q.21 How students are benefitted from online learning? What are the various ways of online learning? Name 2 educational websites.
Ans: Online learning helps students in many ways. Students can learn anytime and anywhere using the internet. They get many study materials like videos, notes, and e-books online. It also allows students to learn at their own pace. Moreover, it helps them improve their digital and technical skills.
Various ways of Online Learning:
(i) Online classes or virtual classrooms
(ii) Educational videos and tutorials
(iii) Online quizzes and assignments
(iv) E-books and study websites
Two Educational Websites:
(i) LearnCSE.in (ii) Khan Academy (iii) Coursera
Q.22 Write a program in Java to display Area of a square.
Differentiate between return type and method arguments with a suitable example.
Ans: static double rectangle_area(double length, double breadth)
{
return (length * breadth);
}
OR
class SquareArea
{
public static void main(String args[])
{
int side = 5;
int area = side * side;
System.out.println("Area of Square = " + area);
}
}
Difference between Return Type and Method Arguments
| Return Type | Method Arguments |
|---|---|
| It specifies the type of value a method returns. | They are values passed to a method when it is called. |
| It is written before the method name. | They are written inside the parentheses of the method. |
| Example: int sum() returns an integer value. | Example: sum(int a, int b) where a and b are arguments. |
Q.23 Aman wants to shop shoes online. Write detailed Steps/ procedure to be followed while shopping online.
Ans: Step 1: Open an online shopping website or app (such as Amazon, Flipkart, etc.).
Step 2: Create an account or log in using your email ID or mobile number.
Step 3: Search for shoes using the search bar.
Step 4: Browse different options and select the shoes you like.
Step 5: Check product details such as size, price, brand, and customer reviews.
Step 6: Select the correct size and quantity.
Step 7: Add the product to the shopping cart.
Step 8: Proceed to checkout.
Step 9: Enter the delivery address and choose a payment method (online payment or cash on delivery).
Step 10: Confirm the order and wait for the shoes to be delivered.
Q.24 (i) Write a program in Java to display Area of a square.
Ans: static double square_area(double side)
{
return (side * side);
}
(ii) What are comment entries in Java? Mention two ways to give comments.
Ans: Comments in Java are notes written in the program to explain the code. They are not executed by the compiler.
Two ways to give comments in Java:
(i) Single-line comment
// This is a single-line comment
(ii) Multi-line comment
/* This is a
multi-line comment */
Download Now - Class 12 IT 802 Sample Question Paper 2020-21 with Solution
