Sample question papers are very helpful for students who want to prepare well for their board exams. The CBSE Class 12 IT (802) Sample Question Paper 2021-22 Term 1 with Solution helps students understand the exam pattern, types of questions, and marking scheme. By solving the sample paper, students can check their preparation level and improve their time management during the exam. The provided solutions make it easier to understand the correct answers and learn the proper way to write answers in the exam.
This Class 12 Information Technology Code 802 sample papers are also very useful for teachers. Teachers can use them to guide students about important topics and the format of the exam. The solutions help teachers explain answers clearly and discuss different ways to approach questions. It also helps teachers conduct practice tests in the classroom so that students become more confident before the final examination.
CBSE Class 12 IT 402 Sample QP 2021-22 Term 1 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 (2021-22) - Term 1
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 802)
Sample Question Paper (SQP) Solution for Class XII (Session 2021-2022)
Max. Time: 3 Hours
Max. Marks: 60
General Instructions:
- Please read the instructions carefully
- This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.
- Section A is of 05 marks and has 06 questions on Employability Skills.
- Section B is of 20 marks and has 25 questions on Subject specific Skills.
- Section C is of 05 marks and has 07 competency-based questions.
- Do as per the instructions given in the respective sections.
- Marks allotted are mentioned against each section/question.
- All questions must be attempted in the correct order
SECTION A
Answer any 5 questions out of the given 6 questions on Employability Skills (1x5=5 Marks)
1. Active listening is important in workplace because if we actively listen to other people (select the one which is not correct)
a) they will be more interested in communicating with us
b) we can develop a long-term working relationship with others
c) we can easily identify challenges and difficulties others are facing and provide solutions to it
d) we will become more popular in the workplace
2. Which of the following personality trait fall in the Big Five popular personality classification?
a) Gregarious
b) Avoidant
c) Borderline
d) Obsessive
3. The contents of cell A1, A2, A3, and A4 in a Spreadsheet application are 10, 15, 20, 25 respectively. If the formula =COUNT(A1:A4) is entered in cell A5, _____ value will be displayed in A5.
a) 70
b) 4
c) 45
d) 65
4. What not to do during an interview?
a) Do take notes
b) Let your achievements speak for you
c) Answer questions fast and use slangs
d) Ask questions
5. ______ is a condition in which people seek excessive attention and admiration and lack of empathy
a) Paranoid
b) Narcissistic
c) Antisocial
d) Dependent
6. What will be displayed, if the following formula is entered in cell A1 in a spreadsheet application
= 6^2 + 15/3 *2 – 7
a) 39
b) 15
c) -14
d) -38
SECTION B
Answer any 20 questions out of the given 25 questions (1x20=20 Marks)
7. Which of the following is a disadvantage of web based applications:
a) They do not need be installed.
b) They are available 24X7.
c) They are slow as compared to software based applications.
d) They offer cross platform compatibility.
8. Internet transactions are susceptible to frauds. Creating a strong password is vital. A strong password has:
a) 6-8 Alphanumeric characters
b) Special symbols
c) Only numbers
d) Both a and b
9. DEITY stands for:
a) Department of Electrical and Information Technology
b) Department of Electronics and Information Technology
c) Department of Electronics and Informatics Technology
d) Department of Electrical and Informatics Technology
10. Which SQL keyword is used to display the data based on certain pattern?
a) LIKE
b) IN
c) BETWEEN
d) RANGE
11. Sagun is creating a table SALESMAN with fields Salesman number, Name, Total Sales. She doesn’t want the Total Sales column to be remain unfilled i.e. she wants to make entry in this field mandatory. Which constraint she should use at the time of creating SALESMAN table:
a) Check
b) Default
c) Not null
d) Primary key
12. Ranjana wants to delete the records where name starts with A from the table CUSTOMER having fields Name, Amount, Discount. Identify the correct command:
a) Delete CUSTOMER where name like "A%";
b) Delete from CUSTOMER where name like "A%";
c) Delete CUSTOMER where name = "A%";
d) Delete from CUSTOMER where name = "A%";
13. Consider a table STAFF:
| Name | City |
|---|---|
| Akash | Mumbai |
| Ajay | Chennai |
| Banit | Delhi |
| Fauzia | Mumbai |
| Sakal | Chennai |
Select the command which will count the number of people in each city.
a) SELECT COUNT(City) , City FROM STAFF WHERE GROUP BY City;
b) SELECT COUNT(City) , City FROM STAFF GROUP BY City;
c) SELECT COUNT(City) , City FROM STAFF WHERE ORDER BY City;
d) SELECT COUNT(City) , City FROM STAFF ORDER BY City;
14. Consider the Table EMPLOYEE given below:
| Name | Zone | Age | Dept |
|---|---|---|---|
| Harit | West | 28 | 10 |
| Kritika | Centre | 30 | 10 |
| Naveen | East | 40 | 20 |
| Uday | North | 38 | 30 |
| Nupur | East | 24 | 20 |
| Moksh | South | 28 | 10 |
| Shelly | North | 24 | 30 |
Choose the correct query/queries that will give the following output:
| Name |
|---|
| Harit |
| Kritika |
| Moksh |
(i) Select Name from EMPLOYEE where DEPT in (10);
(ii) Select Name from EMPLOYEE where AGE between 25 and 30;
(iii) Select Name from EMPLOYEE where NAME like "%i%";
(iv) Select Name from EMPLOYEE where ZONE in ("West", "Centre", "South");
Choose the correct option
a) Only (i)
b) Both (i) and (ii)
c) Both (ii) and (iv)
d) All (i), (ii) and (iv)
15. The ______________command is used to modify the structure of the table STUDENT in MySQL.
a) Modify table STUDENT
b) Alter table STUDENT
c) Alter STUDENT
d) Modify STUDENT
16. Consider a table FACTORY:
| YEAR | Production |
|---|---|
| 2008 | 12000 |
| 2009 | 10000 |
| 2010 | 10600 |
| 2011 | 15000 |
| 2012 | 14500 |
Reema wants to calculate the average production of the years 2008-2012. Help her select the correct SQL command for it:
a) SELECT AVERAGE(Production) from FACTORY;
b) SELECT AVERAGE(Production) from FACTORY group by Production;
c) SELECT SUM(Production) from FACTORY;
d) SELECT AVG(Production) from FACTORY;
17. The National Portal of India provides a single window access to information and services being provided by the various Indian Government entities Which of the following is the website for the National Portal of India:
a) india.gov.in
b) india.gov.org
c) indian.gov.in
d) indian.gov.org
18. Online shopping is an e-commerce application where the customer can purchase goods over the Internet. There are several websites where the customer can go for online shopping. Select from the options given below which of the following is not an online shopping website:
a) snapdeal.com
b) myntra.com
c) coursera.org
d) infibeam.com
19. Garvit wants to change the default value of DISCOUNT in the CUSTOMER table from 10 to 15. Select the most appropriate command to do the same from the following options:
a) ALTER TABLE CUSTOMER ALTER DISCOUNT SET DEFAULT 15;
b) ALTER TABLE CUSTOMER DELETE DISCOUNT SET DEFAULT 15;
c) ALTER TABLE CUSTOMER MODIFY DISCOUNT SET DEFAULT 15;
d) ALTER TABLE CUSTOMER CHANGE DISCOUNT SET DEFAULT 15;
20. Consider a table: COACHING having fields CITY_NAME, ENROLMENTS. Shikhar wants to display the data of the above table in ascending order of enrolments. Choose the correct query/queries from the following:
(i) Select * from coaching order by enrolments asc;
(ii) Select * from coaching order by enrolments desc;
(iii) Select * from coaching order by enrolments;
(iv) Select * from coaching order by enrolments ascending;
Select the correct option:
a) Only (i) is correct
b) Both (i) and (ii) are correct
c) Both (i) and (iii) are correct
d) Only (iv) is correct
21. Geeta wants to know the usage of NULL in MySQL. Help her choose in which of the following case NULL value cannot be assigned to the column Admission_Number:
a) When the Admission_Number is zero
b) When the Admission_Number is not known
c) When the Admission_Number is not available
d) When the Admission_Number is not applicable
22. _______ are real time lectures, where users participate, may ask questions, and get their queries answered.
a) Interactive tutorials
b) Video tutorials
c) Power Point Presentation
d) Webinars
23. There are four main phases of development a Web Application Project.
Statement 1: The scope of the application is decided in the first phase.
Statement 2: The data connectivity is established between the Front-End interface and Back-End Database in the implementation phase.
Select the correct option:
a) Only Statement 1 is correct
b) Only Statement 2 is correct
c) Both Statement 1 and Statement 2 are correct
d) None of the above statements are correct
24. Which of the following is NOT an advantage of DBMS approach:
a) All the data is stored at one place. There is no repetition of the same data.
b) There is a single copy of data that is accessed or updated by all the users.
c) The DBA can provide security to the database by controlling users' database access rights.
d) Designing the database specifications and writing application programs is a time-consuming process.
25. An attribute A of datatype varchar(20) has the value “Keshav”. The attribute B of datatype char(20) has value ”Meenakshi”. How many characters are occupied in attribute A and attribute B?
a) 20, 6
b) 6, 20
c) 9, 6
d) 6, 9
26. Consider the table ‘empsal’.
| ID | Salary | Dept |
|---|---|---|
| Q101 | 54000 | 10 |
| Q103 | 67000 | 20 |
| Q105 | 75000 | 20 |
| Q109 | NULL | 30 |
Read the following two commands carefully:
(i) select COUNT(salary) from empsal;
(ii) select COUNT(*) from empsal;
Choose the correct option:
a) Both (i) and (ii) will give the same output as 3.
b) The output of (i) is 3 and the output of (ii) is 4.
c) Both (i) and (ii) will give the same output as 4.
d) The output of (i) is 4 and the output of (ii) is 3
27. Cardinality of a table is four and degree is three. If two columns and four rows are added to the 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
28. Consider a table 'SCORE'
| ROLLNO | NAME | STREAM | OPTIONAL |
|---|---|---|---|
| 1 | Greesha | Science | 10 |
| 2 | Satish | Commerce | 30 |
| 3 | Teena | NULL | 20 |
| 4 | Yasmine | Humanities | 10 |
| 5 | Yashika | Science | 10 |
| 5 | Lalit | Humanities | 20 |
Reema wants to display names of those students who have not been assigned any stream. Help her select the correct query:
a) Select name from SCORE where stream =NULL;
b) Select name from SCORE where stream =null;
c) Select name from SCORE where stream = “ “;
d) Select name from SCORE where stream is NULL;
29. Consider the table SCORE in Q28. Select the correct query from the options given below to display the names of all streams only once.
a) Select distinct stream from score;
b) Select distinct(stream) from score;
c) Select unique stream from score;
d) Select stream from score where stream = distinct;
30. Online reservation systems are advantageous both for the company providing reservation services and for the consumer who uses the online reservation system for booking.
i. User can read reviews posted by people while making choices during reservation.
ii. More man-power is required by providers to ensure smooth functioning.
Choose the correct justification to the statement given above:
a) Only (i)
b) Only (ii)
c) Both (i) and (ii)
d) Neither (i) nor (ii)
31. Reeta is going to her aunt’s house to spend her vacations. To book her rail tickets online she needs to create new account on the reservation portal. Which of the following is NOT a correct step to do the same?
a) Sign up on the reservation portal.
b) Fill the registration form.
c) The fields marked with a star (*) are optional.
d) Click the submit button after filling the form.
SECTION B: COMPETENCY BASED QUESTIONS
Answer any 5 questions out of the given 7 questions (1x5=5 Marks)
32. Read the following statements carefully about E-governance
(i) It is the use of electronic tools for governance.
(ii) It has decreased the transparency in the system.
(iii) E-governance empowers the citizens socially and economically.
(iv) It enables citizens to access information after paying money.
Choose the correct option from the following:
a) Both (i) and (ii) are correct
b) Both (ii) and (iii) are correct
c) Both (i) and (iii) are correct
d) Only (iv) is correct
33. Consider a Table STORE shown below:
| 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 |
| S104 | Pantaloon | Chennai | 78 | 2004 | D112 |
| S105 | Max Fashions | Delhi | 80 | 2020 | A145 |
Consider a table OWNER shown below:
| OwnerId | OwnerName |
|---|---|
| A145 | Divyam Prakash |
| B178 | Neha Sultan |
| D112 | Gargi Chhabra |
Choose the correct query to display the number of employees present in Delhi and Mumbai.
(i) Select SUM(noofemployee), Location from STORE group by location HAVING location in ("Delhi","Mumbai");
(ii) Select SUM(noofemployee), Location from STORE group by location WHERE location in ("Delhi","Mumbai");
(iii) Select SUM(noofemployee), Location from STORE group by location HAVING location ="Delhi" and location="Mumbai";
(iv) Select SUM(noofemployee), Location from STORE group by location WHERE location ="Delhi" or location="Mumbai";
Choose the correct option:
a) Both (i) and (ii)
b) Both (ii) and (iii)
c) Both (iii) and (iv)
d) Both (i) and (iii)
34. Consider the table STORE given in Q33. Choose the correct query to display Stores names, Location and Date of Opening of stores that were opened before 2015.
a) Select storename, location, OpeningYear from store where OpeningYear <"2015";
b) Select storename, location, OpeningYear from store where OpeningYear >"2015";
c) Select storename, location, OpeningYear from store where OpeningYear =2015;
d) Select storename, location, OpeningYear from store where OpeningYear !=2015;
35. Consider the table STORE given in Q33. Radhika wants to add a new column SALE on type integer to the table. Choose the correct query for the same:
a) Add column SALE integer;
b) Alter table add SALE integer;
c) Alter table store add SALE integer;
d) Alter table store modify SALE integer;
36. Consider the table STORE and OWNER given in Q33. Seema wants to display StoreName and OwnerName of all stores in Mumbai. Help her select the correct query from the options given below:
a) Select StoreName, OwnerName from STORE, OWNER where store.OwnerId=Owner.OwnerId or Location="Mumbai";
b) Select StoreName, OwnerName from STORE, OWNER where store.OwnerId=Owner.OwnerId and Location="Mumbai";
c) Select StoreName, OwnerName from STORE, OWNER where Location="Mumbai";
d) Select StoreName, OwnerName from STORE, OWNER where OwnerId=OwnerId and Location="Mumbai";
37. Consider the table STORE given in Q33. Radhika wants to display the following output:
| Store Id | Store Name | No Of Employee |
|---|---|---|
| S101 | Libas | 45 |
| S102 | Life Style | 68 |
i. Select StoreId, StoreName, NoOfEmployee from STORE where StoreId=102 or StoreId=101;
ii. Select StoreId, StoreName, NoOfEmployee from STORE where StoreName=”Libas” or StoreName="Life Style";
iii. Select StoreId, StoreName, NoOfEmployee from STORE where Location=”Delhi” or Location="Mumbai";
iv. Select StoreId, StoreName, NoOfEmployee from STORE where StoreName like "L%";
Choose the correct option:
a) (i) and (ii) are correct
b) (i), (ii) and (iii) are correct
c) (i), (ii) and (iv) are correct
d) All are correct
38. Rajat is compiling a detailed list with a clear description of application features of his project and recognizing the limitations that are placed on the project. Out of the given options choose the phase of the project in which Rajat is currently in:
a) Requirements Definition Phase
b) Testing Phase
c) Implementation Phase
d) Design Phase
Download Now - Class 12 IT 802 Sample Question Paper 2021-22 (Term 1) with Solution
