CBSE Class 12 Computer Science Sample Question Paper 2022 (Set-2)

Each question carries 2 marks

No

No.

Instructions

·         It is a LIFO data structure

·         The insertion and deletion happens at one end i.e. from the top of the stack

(2)

expansion

(1)

answer

(1)

·         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

( minimum 2 differences to be given)

(2)

(b)               tuple

each correct answer

(2)

(a) 29

(b) 19-Jul-2021

(c)

(d)

10-Mar- 2020

17-Nov-2019

½ mark for each correct output

(2)

answer

(1)

·         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

(1)

(b)   MOVIEID should be made the primary key as it uniquely identifies each record of the table.

½ mark for correct field and ½ mark for justification

(2)

OR

(a)   MOVIEID and TITLE

(b)   MOVIEID

½ mark for each correct field name

1 mark for correct answer

Each question carries 3 marks

“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

OR

# Question No 8 (second option) N=[12, 13, 34, 56, 21, 79, 98, 22,

35, 38]

def PUSH(S,N):

1 mark for correct PUSH operation

1 mark for correct POP operation

1 mark for correct function calls and displaying the output

1 mark for correct PUSH operation

(3)

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

1 mark for correct function calls and displaying the output

Note: Marks to be awarded for any other correct logic given by the

student

ADD (Discount INT);

(1)

DML: INSERT INTO, UPDATE…SET

identified

CREATE TABLE CITY (

CITYCODE CHAR(5)PRIMARY KEY, CITYNAME CHAR(30),

SIZE INT, AVGTEMP INT,

POPULATIONRATE INT, POPULATION INT,

);

2  marks for correctly creating the table.

(3)

Each question carries 4 marks

(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;

1 mark for each correct query

(4)

·         Ease of service

·         Centralized control

·         Easy to diagnose faults

·         One device per connection

Disadvantages

·         long cable length

·         difficult to expand

·         central node dependency

OR

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.

½ mark for each correct advantage / disadvantage

1 mark for each correct definition

(2)

·         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

(minimum two points should be given)

(2)

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

(a)

BeHappy Corporation

Block B

(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

1 mark for each correct answer

(4)