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:
2. (i) Expand the following: SMTP , XML
Ans:
(ii) Out of the following, which is the fastest wired and wireless medium of transmission?
Infrared, coaxial cable, optical fibre, microwave, Ethernet cable
Ans:
3. Differentiate between char(n) and varchar(n) data types with respect to databases.
Ans:
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:
(b) What will be the datatype of Mydata object after the given command is executed?
Ans:
5. Write the output of the queries (a) to (d) based on the table, Furniture given below:
Table: FURNITURE
----table
(a) SELECT SUM(DISCOUNT) FROM FURNITURE WHERE COST>15000;
Ans:
(b) SELECT MAX(DATEOFPURCHASE) FROM FURNITURE;
Ans:
(c) SELECT * FROM FURNITURE WHERE DISCOUNT>5 AND FID LIKE "T%";
Ans:
(d) SELECT DATEOFPURCHASE FROM FURNITURE WHERE NAME IN ("Dining Table", "Console Table");
Ans:
6. (i) Which command is used to view the list of tables in a database?
Ans:
(ii) Give one point of difference between an equi-join and a natural join.
Ans:
7. Consider the table, MOVIEDETAILS given below:
Table: MOVIEDETAILS
-----table
(a) Identify the degree and cardinality of the table.
Ans:
(b) Which field should be made the primary key? Justify your answer.
Ans:
OR
(a) Identify the candidate key(s) from the table MOVIEDETAILS.
Ans:
(b) Consider the table SCHEDULE given below:
Table: SCHEDULE
-----table
Which field will be considered as the foreign key if the tables MOVIEDETAILS and SCHEDULE are related in a database?
Ans:
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:
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:
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:
(ii) Categorize following commands into DDL and DML commands?
INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE...SET
Ans:
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
-----table
Help her to complete the task by suggesting appropriate SQL commands.
Ans:
SECTION C
Each question carries 4 marks.
11. Write queries (a) to (d) based on the tables EMPLOYEE and DEPARTMENT given below:
Table: EMPLOYEE
-----table
Table: DEPARTMENT
-----table
(a) To display the average salary of all employees, department wise.
Ans:
(b) To display name and respective department name of each employee whose salary is more than 50000.
Ans:
(c) To display the names of employees whose salary is not known, in alphabetical order.
Ans:
(d) To display DEPTID from the table EMPLOYEE without repetition.
Ans:
12. (i) Give two advantages and two disadvantages of star topology.
Ans:
OR
Define the following terms: www , web hosting
Ans:
(ii) How is packet switching different from circuit switching?
Ans:
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.
-----image
Distance between the various blocks is as follows:
-----table
Numbers of computers in each block
-----table
(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 -
ii. Hub/Switch -
(c) Which kind of network (PAN/LAN/WAN) will be formed if the Noida office is connected to its head office in Mumbai?
Ans:
(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:
Download Now - Class 12 CS 083 Sample Question Paper 2021-22 Term 2 with Solution
