Online Tution   »   Sample Papers   »   CBSE Class 12 Computer Science Term...

CBSE Class 12 Computer Science Term 2 Sample Paper & Solutions

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
CBSE Class 12 Computer Science Term 2 Sample Paper & Solutions_40.1
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 Class 12 Computer Science Term 2 Sample Paper & Solutions_50.1

 

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: 

  1. It is a LIFO data structure  
  2. 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):  

  1. stores a fixed length string between 1 and 255 characters  
  2. if the value is of smaller length, adds blank spaces  
  3. some space is wasted 

varchar(n) :  

  1. stores a variable length string  
  2. no blanks are added even if value is of smaller length  
  3. 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:  

  1. The join in which columns from two tables are compared for equality  
  2. Duplicate columns are shown 

Natural Join  

  1. The join in which only one of the identical columns existing in both tables is present
  2. 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:

CBSE Class 10 Computer Applications Term 2 Sample Paper & Solutions CBSE Class 10 English Term 2 Sample Paper & Solutions
CBSE Class 10 Science Term 2 Sample Paper & Solutions CBSE Class 10 Maths Term 2 Sample Paper & Solutions
CBSE Class 10 Hindi Term 2 Sample Paper & Solutions CBSE Class 10 Social Science Term 2 Sample Paper & Solutions
CBSE Class 12 Mathematics Term 2 Sample Paper With Solutions CBSE Class 12 Computer Science Term 2 Sample Paper & Solutions
CBSE Class 12 History Sample Paper 2022 For Term 2 With Solutions CBSE Class 12 Geography Term 2 Sample Paper & Solutions 2022
CBSE Class 12 Chemistry Term 2 Sample Paper & Solutions CBSE Class 12 Business Studies Term 2 Sample Paper And Solutions
CBSE Class 12 Biology Term 2 Sample Paper & Solutions CBSE Class 12 Physics Term 2 Sample Paper & Solutions
CBSE Class 12 Physical Education Term 2 Sample Paper & Solutions CBSE Class 12 Accountancy Term 2 Sample Paper & Solutions

CBSE Class 12 Computer Science Term 2 Sample Paper & Solutions: FAQs

Q. Which sample paper is best for CBSE Class 12 Term 2 Computer Science?
The sample paper given on this page is best for CBSE Class 12 Term 2 Computer Science.
Q. Where can I get Computer Science sample papers for CBSE Class 12 Term 2?
You can get Computer Science sample papers for CBSE Class 12 Term 2 on this page.
Q. How many sample papers does CBSE release?
CBSE has released sample papers of all the subjects.

Sharing is caring!

Thank You, Your details have been submitted we will get back to you.
Was this page helpful?

Leave a comment

Your email address will not be published. Required fields are marked *