Class 12 Computer Science Term 2 Sample Paper 2022
CBSE has released the Class 12 Computer Science Term 2 Sample Paper on its official website. As the CBSE Term 2 exam dates are near students must solve the Class 12 Computer Science Term 2 Sample Paper given on this page to assess their preparation for CBSE Term 2 Exam 2022. Central Board of Secondary Education is going to conduct CBSE Term 2 Exam 2022 for Class 12 from 26th April 2022 onwards. By using the Class 12 Computer Science Term 2 Sample Paper students can get an idea about the exam pattern of CBSE Term 2 Exam 2022. In this article, we have given the solved Class 12 Computer Science Term 2 Sample Paper with answers. Students must solve this paper and bookmark this page to get all the latest updates from CBSE regarding CBSE Term 1 Result 2021 and CBSE Term 2 Exam 2022.
Check: CBSE Term 2 Exam Sheet 2022
Are you in class12th/passed and willing to get admission in TOP COLLEGE of India ?
Fill up google form for the right guidance towards your GOAL
Read:
- CBSE Term 2 Class 10 Maths Sample Paper 2022 with Answers
- CBSE Term 2 Exam 2022- Latest News
- CBSE Term 1 Result Predictor 2022
- CBSE Term 2 Class 10 Maths Sample Paper 2022 With Answers
- Competitive Exams After 12th Arts, Commerce, Science
CBSE Term 2 Sample Paper Class 12 Computer Science: Exam Pattern
Class 12 Computer Science Term 2 Sample Paper is divided into 3 sections namely Section A, Section B, and Section C. Check out the brief information about these sections given below:
Section A: Questions from this section hold 2 marks each.
Section B: Questions from this section hold 3 marks each.
Section C: Questions from this section hold 4 marks each.
Class 12 Computer Science Term 2 Sample Paper with Solutions
Q. Give any two characteristics of stacks
Characteristics of Stacks:
- It is a LIFO data structure
- The insertion and deletion happens at one end i.e. from the top of the stack
Q. Expand the following: SMTP , XML
SMTP : Simple Mail Transfer Protocol
XML: Extensible Mark Up Language
Q. Out of the following, which is the fastest wired and wireless medium of transmission? Infrared, coaxial cable, optical fibre, microwave, Ethernet cable
Wired- optical fibre
Wireless – microwave
Q. Differentiate between char(n) and varchar(n) data types with respect to databases.
char(n):
- stores a fixed length string between 1 and 255 characters
- if the value is of smaller length, adds blank spaces
- some space is wasted
varchar(n) :
- stores a variable length string
- no blanks are added even if value is of smaller length
- no wastage of space
Q. A resultset 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?
(b) What will be the datatype of Mydata object after the given command is executed?
(a) One record
(b) tuple
Q. 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;
(b) SELECT MAX(DATEOFPURCHASE) FROM FURNITURE;
(c) SELECT * FROM FURNITURE WHERE DISCOUNT>5 AND FID LIKE “T%”;
(d) SELECT DATEOFPURCHASE FROM FURNITURE WHERE NAME IN (“Dining Table”, “Console Table”);
(a) 29
(b) 19-Jul-2021
(c)
| T006 | Console Table | 17-Nov-2019 | 15000 | 12 |
(d) 10-Mar- 2020
17-Nov-2019
Q. Which command is used to view the list of tables in a database?
SHOW TABLES;
Q. Give one point of difference between an equi-join and a natural join
Equi- join:
- The join in which columns from two tables are compared for equality
- Duplicate columns are shown
Natural Join
- The join in which only one of the identical columns existing in both tables is present
- No duplication of columns
Q. 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.
(b) Which field should be made the primary key? Justify your answer.
(a) Degree: 5 Cardinality: 6
(b) MOVIEID should be made the primary key as it uniquely identifies each record of the table.
Q. (a) Identify the candidate key(s) from the table MOVIEDETAILS.
(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 | 2 PM to 5 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?
(a) MOVIEID and TITLE
(b) MOVIEID
Q. 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
# Question No 8 (first option)
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
ST=[ ]
for k in R:
if R[k]>=75:
PUSH(ST,k)
while True:
if ST!=[ ]:
print(POP(ST),end=” “)
Else:
break
Q. 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
# Question No 8 (second option)
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
ST=[ ]
for k in N:
if k%2==0:
PUSH(ST,k)
while True:
if ST!=[]:
print(POP(ST),end=” “)
else:
Break
Q. 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.
ALTER TABLE Item
ADD (Discount INT);
Q. Categorize following commands into DDL and DML commands?
INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE…SET
DDL: DROP TABLE, ALTER TABLE
DML: INSERT INTO, UPDATE. ..SET
Q. 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.
CREATE DATABASE MYEARTH;
CREATE TABLE CITY
(
CITYCODE CHAR(5)PRIMARY KEY ,
CITYNAME CHAR(30),
SIZE INT,
AVGTEMP INT,
POPULATIONRATE INT,
POPULATION INT,
);
Q. 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- Jan1978 | D001 | Manager | 75000 |
| 123 | Nitin | 10- Oct1977 | D002 | AO | 59000 |
| 129 | Navjot | 12- Jul1971 | D003 | Supervisor | 40000 |
| 130 | Jimmy | 30- Dec1980 | D004 | Sales Rep | |
| 131 | Faiz | 06- Apr1984 | 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.
(b) To display name and respective department name of each employee whose salary is more than 50000.
(c) To display the names of employees whose salary is not known, in alphabetical order. (d) To display DEPTID from the table EMPLOYEE without repetition
(a) SELECT AVG(SALARY)
FROM EMPLOYEE
GROUP BY DEPTID;
(b) SELECT NAME, DEPTNAME
FROM EMPLOYEE, DEPARTMENT
WHERE
EMPLOYEE.DEPTID=
DEPARTMENT.DEPTID
AND SALARY>50000;
(c) SELECT NAME FROM EMPLOYEE
WHERE SALARY IS NULL
ORDER BY NAME;
(d) SELECT DISTINCT DEPTID
FROM EMPLOYEE;
Q. Give two advantages and two disadvantages of star topology
Advantages
- Ease of service
- Centralized control
- Easy to diagnose faults
- One device per connection
Disadvantages
- long cable length
- difficult to expand
- central node dependency
Q. Define the following terms:
www , web hosting
www: a set of protocols that allow you to access any document on the internet through the naming systems based on URLs
Web hosting: Web hosting is a service that allows organizations and individuals to post a website or web page onto the server, which can be viewed by everyone on the Internet.
Q. How is packet switching different from circuit switching?
Packet switching:
- uses store and forward concept to send messages
- no physical path is actually establishes
- message is divided into smaller parts, known as packets and then sent forward
- tight upper limit on block size
- Each data unit knows only the final receiver’s address
Circuit switching
- physical connection is established between sender and receiver
- Each data unit knows the entire path from sender to receiver
- It does not follow store and forward concept
Q. 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 120m
C to D 100m
A to D 170m
B to D 150m
A to C 70m
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.
(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?
(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?
(a)
(b) Repeater : between C and D as the distance between them is 100 mts.
Hub/ Switch : in each block as they help to share data packets within the devices of the network in each block
(c) WAN.
(d) Satellite
Read More About:
CBSE Term 2 Class 10 English Sample Paper 2022 with Answers
When will CBSE Term 1 Result 2022 will be declared?
CBSE Class 12 Physics Term 2 Sample Paper & Solutions
Related Post:
