CBSE Class 12 Computer Science (083) Sample Question Paper 2021-22 (Term 2) with Solutions is an essential resource for students preparing for board exams. It helps students understand the latest exam pattern, marking scheme, and types of questions such as case-based and Python programming questions. By practicing this sample paper, students can improve their time management, identify weak areas, and boost their confidence before the final exam. It also serves as an effective revision tool, allowing students to cover important topics like file handling, functions, and data structures in a structured way.
For teachers, this sample paper is equally beneficial as it provides a clear idea of CBSE’s question design and evaluation criteria. Teachers can use it to create practice tests, guide students more effectively, and analyze their performance based on the official marking scheme. Overall, the CBSE Class 12 CS Sample Paper 2021-22 Term 2 with Solutions is a valuable academic tool that supports both teaching and learning, making exam preparation more focused and result-oriented.
CBSE Class 12 CS 083 Sample QP 2021-22 Term 2 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 Computer Science (083) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 12 CS 083 Sample Question Paper Session (2021-22)
CBSE | DEPARTMENT OF SKILL EDUCATION
COMPUTER SCIENCE (SUBJECT CODE - 083)
Sample Question Paper (SQP) Solution for Class XII (Session 2021-2022)
Max. Time: 2 Hours
Max. Marks: 35
General Instructions:
- The question paper is divided into 3 sections – A, B and C
- Section A, consists of 7 questions (1-7). Each question carries 2 marks.
- Section B, consists of 3 questions (8-10). Each question carries 3 marks.
- Section C, consists of 3 questions (11-13). Each question carries 4 marks.
- Internal choices have been given for question numbers 7, 8 and 12.
SECTION A
Each question carries 2 marks.
1. Give any two characteristics of stacks.
Ans: (i) Stack is a linear data structure.
(ii) It follows the LIFO (Last In First Out) principle.
2. (i) Expand the following: SMTP , XML
Ans: SMTP - Simple Mail Transfer Protocol
XML - Extensible Markup Language
(ii) Out of the following, which is the fastest wired and wireless medium of transmission?
Infrared, coaxial cable, optical fibre, microwave, Ethernet cable
Ans: Wired - optical fibre, Wireless - microwave
3. Differentiate between char(n) and varchar(n) data types with respect to databases.
Ans:
| CHAR(n) | VARCHAR(n) |
|---|---|
| Length is fixed up to n characters | Stores only the actual number of characters |
| If data is shorter, blank spaces are added (padded) | No padding is added |
| Wastes space if data is small | Saves space |
| Faster for fixed-length data | Slightly slower but more efficient for variable data |
4. A result set is extracted from the database using the cursor object (that has been already created) by giving the following statement.
Mydata=cursor.fetchone()
(a) How many records will be returned by fetchone() method?
Ans: one
(b) What will be the datatype of Mydata object after the given command is executed?
Ans: tuple
5. Write the output of the queries (a) to (d) based on the table, Furniture given below:
Table: FURNITURE
| FID | NAME | DATEOFPURCHASE | COST | DISCOUNT |
|---|---|---|---|---|
| B001 | Double Bed | 03-Jan-2018 | 45000 | 10 |
| T010 | Dining Table | 10-Mar-2020 | 51000 | 5 |
| B004 | Single Bed | 19-Jul-2021 | 22000 | 0 |
| C003 | Long Back Chair | 30-Dec-2016 | 12000 | 3 |
| T006 | Console Table | 17-Nov-2019 | 15000 | 12 |
| B006 | Bunk Bed | 01-Jan-2021 | 28000 | 14 |
(a) SELECT SUM(DISCOUNT) FROM FURNITURE WHERE COST>15000;
Ans: 29
(b) SELECT MAX(DATEOFPURCHASE) FROM FURNITURE;
Ans: 19-Jul-2021
(c) SELECT * FROM FURNITURE WHERE DISCOUNT>5 AND FID LIKE "T%";
Ans:
| T006 | Console Table | 17-Nov-2019 | 15000 | 12 |
(d) SELECT DATEOFPURCHASE FROM FURNITURE WHERE NAME IN ("Dining Table", "Console Table");
Ans: 10-Mar-2020
17-Nov-2019
6. (i) Which command is used to view the list of tables in a database?
Ans: SHOW Tables;
(ii) Give one point of difference between an equi-join and a natural join.
Ans: Equi-Join: It is a join where columns from two tables are compared using the equality (=) operator, and duplicate columns are included in the result.
Natural Join: It automatically joins tables based on common column names and removes duplicate columns, showing only one copy.
7. Consider the table, MOVIEDETAILS given below:
Table: MOVIEDETAILS
| MOVIEID | TITLE | LANGUAGE | RATING | PLATFORM |
|---|---|---|---|---|
| M001 | Minari | Korean | 5 | Netflix |
| M004 | MGR Magan | Tamil | 4 | Hotstar |
| M010 | Kaagaz | Hindi | 3 | Zee5 |
| M011 | Harry Potter and the Chamber of Secrets | English | 4 | Prime Video |
| M015 | Uri | Hindi | 5 | Zee5 |
| M020 | Avengers: Endgame | English | 4 | Hotstar |
(a) Identify the degree and cardinality of the table.
Ans: Degree: 5, Cardinality: 6
(b) Which field should be made the primary key? Justify your answer.
Ans: MOVIEID should be made the primary key as it uniquely identifies each record of the table.
OR
(a) Identify the candidate key(s) from the table MOVIEDETAILS.
Ans: MOVIEID and TITLE
(b) Consider the table SCHEDULE given below:
Table: SCHEDULE
| SLOTID | MOVIEID | TIMESLOT |
|---|---|---|
| S001 | M010 | 10 AM to 12 PM |
| S002 | M020 | 2 PM to 5 PM |
| S003 | M010 | 6 PM to 8 PM |
| S004 | M011 | 9 PM to 11 PM |
Which field will be considered as the foreign key if the tables MOVIEDETAILS and SCHEDULE are related in a database?
Ans: MOVIEID
SECTION B
Each question carries 2 marks.
8. Julie has created a dictionary containing names and marks as key value pairs of 6 students. Write a program, with separate user defined functions to perform the following operations:
Push the keys (name of the student) of the dictionary into a stack, where the corresponding value (marks) is greater than 75.
Pop and display the content of the stack.
For example:
If the sample content of the dictionary is as follows:
R={"OM":76, "JAI":45, "BOB":89, "ALI":65, "ANU":90, "TOM":82}
The output from the program should be:
TOM ANU BOB OM
Ans:
R={"OM":76, "JAI":45, "BOB":89, "ALI":65, "ANU":90, "TOM":82}
def PUSH(S,N):
S.append(N)
def POP(S):
if S!=[]:
return S.pop()
else:
return None
for k in R:
if R[k]>=75:
PUSH(ST,k)
while True:
if ST!=[]:
print(POP(ST),end=" ")
else:
break
OR
Alam has a list containing 10 integers. You need to help him create a program with separate user defined functions to perform the following operations based on this list.
Traverse the content of the list and push the even numbers into a stack.
Pop and display the content of the stack.
For Example:
If the sample Content of the list is as follows:
N=[12, 13, 34, 56, 21, 79, 98, 22, 35, 38]
Sample Output of the code should be:
38 22 98 56 34 12
Ans:
N=[12, 13, 34, 56, 21, 79, 98, 22, 35, 38]
def PUSH(S,N):
S.append(N)
def POP(S):
if S!=[]:
return S.pop()
else:
return None
for k in N:
if k%2==0:
PUSH(ST,k)
while True:
if ST!=[]:
print(POP(ST),end=" ")
else:
break
9. (i) A table, ITEM has been created in a database with the following fields:
ITEMCODE, ITEMNAME, QTY, PRICE
Give the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table.
Ans: ALTER TABLE Item ADD (Discount INT);
(ii) Categorize following commands into DDL and DML commands?
INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE...SET
Ans: DDL: DROP TABLE, ALTER TABLE
DML: INSERT INTO, UPDATE...SET
10. Charu has to create a database named MYEARTH in MYSQL.
She now needs to create a table named CITY in the database to store the records of various cities across the globe. The table CITY has the following structure:
Table: CITY
| FIELD NAME | DATA TYPE | REMARKS |
|---|---|---|
| CITYCODE | CHAR(5) | Primary Key |
| CITYNAME | CHAR (30) | |
| SIZE | INTEGER | |
| AVGTEMP | INTEGER | |
| POLLUTIONRATE | INTEGER | |
| POPULATION | INTEGER |
Help her to complete the task by suggesting appropriate SQL commands.
Ans: CREATE DATABASE MYEARTH;
CREATE TABLE CITY
(CITYCODE CHAR(5)PRIMARY KEY,
CITYNAME CHAR(30),
SIZE INT,
AVGTEMP INT,
POPULATIONRATE INT,
POPULATION INT,
);
SECTION C
Each question carries 4 marks.
11. Write queries (a) to (d) based on the tables EMPLOYEE and DEPARTMENT given below:
Table: EMPLOYEE
| EMPID | NAME | DOB | DEPTID | DESIG | SALARY |
|---|---|---|---|---|---|
| 120 | Alisha | 23-Jan-1978 | D001 | Manager | 75000 |
| 123 | Nitin | 10-Oct-1977 | D002 | AO | 59000 |
| 129 | Navjot | 12-Jul-1971 | D003 | Supervisor | 40000 |
| 130 | Jimmy | 30-Dec-1980 | D004 | Sales Rep | - |
| 131 | Faiz | 06-Apr-1984 | D001 | Dep Manager | 65000 |
Table: DEPARTMENT
| DEPTID | DEPTNAME | FLOORNO |
|---|---|---|
| D001 | Personal | 4 |
| D002 | Admin | 10 |
| D003 | Production | 1 |
| D004 | Sales | 3 |
(a) To display the average salary of all employees, department wise.
Ans: SELECT AVG(SALARY) FROM EMPLOYEE GROUP BY DEPTID;
(b) To display name and respective department name of each employee whose salary is more than 50000.
Ans: SELECT NAME, DEPTNAME FROM EMPLOYEE, DEPARTMENT WHERE EMPLOYEE.DEPTID=DEPARTMENT.DEPTID AND SALARY>50000;
(c) To display the names of employees whose salary is not known, in alphabetical order.
Ans: SELECT NAME FROM EMPLOYEE WHERE SALARY IS NULL ORDER BY NAME;
(d) To display DEPTID from the table EMPLOYEE without repetition.
Ans: SELECT DISTINCT DEPTID FROM EMPLOYEE;
12. (i) Give two advantages and two disadvantages of star topology.
Ans: Advantages:
(i) Easy to install and manage
(ii) Failure of one node does not affect others
Disadvantages:
(i) Failure of central hub stops entire network
(ii) Expensive due to more cabling
OR
Define the following terms: www , web hosting
Ans: www: The World Wide Web is a system that allows us to open and view websites on the internet using links called URLs.
web hosting: Web hosting is a service that stores a website on a server so that people can access it on the internet.
(ii) How is packet switching different from circuit switching?
Ans: Packet switching sends data in small packets through different paths and used in the Internet., while circuit switching uses a fixed path with a dedicated connection for the entire communication and used in telephone calls.
13. BeHappy Corporation has set up its new centre at Noida, Uttar Pradesh for its office and web-based activities. It has 4 blocks of buildings.
Distance between the various blocks is as follows:
| A to B | 40 m |
| B to C | 120 m |
| C to D | 100 m |
| A to D | 170 m |
| B to D | 150 m |
| A to C | 70 m |
Numbers of computers in each block
| Block A | 25 |
| Block B | 50 |
| Block C | 125 |
| Block D | 10 |
(a) Suggest and draw the cable layout to efficiently connect various blocks of buildings within the Noida centre for connecting the digital devices.
Ans:
(b) Suggest the placement of the following device with justification:
i. Repeater - between C and D as the distance between them is 100 mts.
ii. Hub/Switch - in each block as they help to share data packets within the devices of the network in each block.
(c) Which kind of network (PAN/LAN/WAN) will be formed if the Noida office is connected to its head office in Mumbai?
Ans: WAN
(d) Which fast and very effective wireless transmission medium should preferably be used to connect the head office at Mumbai with the centre at Noida?
Ans: Satellite
Download Now - Class 12 CS 083 Sample Question Paper 2021-22 Term 2 with Solution
