WEST CHENNAI SAHODAYA CI.

USTER COMMON EXAMINATION, 2022

(TERM)
SUBJECT: COMPUTER SCIENCE
CODE 083

CLASS XII, 2021-22 Dar O3.2 2

Maxlmum Marks: 35 Time: 2 hours

General Instructions
The question paper is divided into 3 sections - A,B and C

Section A, conslsts of 7 questions (1-7). Each question carries 2 marks.

Section B, consists of 3 questions (8-10). Each question carries 3 marks.

Sectlon C, consists of3 questions (11-13). Each question carries 4 marks.

Internal choices have been given for question numbers 7, 8 and 12.

Section A Each question carries2 marks

1. aWhat is the situation called when a deletion is attempted in an empty stack?

(1)
b) Why is stack referred as LIFo data structure? (1)

2. a) Expand the following: a) TCP/1P b) SIP (1)

b) What is packet switching? (1)
3. Differentiate between PRIMARY KEY and UNIQUE constraints with respect to tables
in databases. (2)
4.

a) Which methodffunction) is used while changing the data of the database table
with the connection object so that the changes are reflected in the database?

(1)
 2

from the table using

resultset is extracted
From a table which contains 10 records,a
D giving the following statements,
the object (that has been already created) by
cursor

what will be the output of the code givenbelow (1

data = [Link]()

data1 [Link](3)
print([Link])
5. Write the output of the queries (a) to (d) based on the table, EQUIPMENT given

below: (2)
TABLE:EQUIPMENT
EONo EQName QDateofPurchas
EI Safety goggles 60 2019-12-20

E2 Beakers 120 2020-09-01

E3 Florence flasks | 100 2019-12-05

E4 Funnels 80 2019-10-10
E5 Volumetric flasks 90 2019-12-08

E6 Graduated cylinders 40 2020-02-17

daSELECT SUM(QTY) FROM EQUIPMENT WHERE QTY <>100;

b SELECT MAX(DATEOFPURCHASE) FROM EQUIPMENT; E
c SELECT EQNAME, QTY FROM EQUIPMENT WHERE NAME LIKE 'F%' AND QTY>
80;
d) SELECT FROM EQUIPMENT WHERE EQNO
IN(E2', ES',E6')
6. i) Which command is used to display all the
available databases? (1)
i) Give the difference between count(") and count{attribute)
in a SELECT query. (1
1. Consider the tables given below and answer the
foltowing: 2
a) What is Cartesian product? Give the degree and the cardinality of the
resultant
table if Cartesian product is performed on the tables
given below.
 3

TABLE B0OK
Bookid Booktitle Price
1001 PYTHON 595
1002 WEB DESIGN 675
1003 Al 500

TABLE: SALES

STOREID AMT
S01 15000
S02 14000
(OR)
b) Consider the table given below:

TABLE: GARMENT

GCODEICODE DESCRIPTION PRICE ECODE

10023 COl SAREE 1150 F03
10001 C02 FORMAL SHIRT 1250 FO1
10012 C08
INFORMAL SHIRT |1550 FO2
10024 CO6 BABY TOP |750 F03
10090 C04 TULIP SKIRT 850 F02
10019 C10 EVENING GOWN 850 F03
10009 CO5 INFORMAL PANT 1500 | F02
10007 C07 FORMAL PANT 1350 FO1
10020 C03 FROCK 850 F04
10089 C09 SLACKS 750 F03

TABLE: FABRIC

FCODE TYPE
F04 POLYSTER
F02 COTTON
F03 SILK
FO1 TERELENE

i)Jdentify the PRIMARY KEY and ALTERNATE KEY for the Table GARMENT
ü Which is the FOREIGN KEY when these tables are related?
 SECTION-B

Each question carrles 3 marks

8. SUPRAJA has list containing 10integers. You need to help her create a program
a

parate user defined functions to perform the following operations based on this
list.
(3)
raverse the content of the list and push the prime numbers that are present in the
list into a stack.

Pop and display the content of the stack.

(OR)
Write a program, with separate defined functions
user to perform the following
operations on a given string
Push the characters of the string into a stack

Pop and display the content of the stack to the

reverse string.

a) Write SQL statement to add a column "CITY" with data

type and size as
VARCHAR(20) to the existing table named "STUDENT".
(1)

b) Consider the table given below

TABLE: DEPARTMENT

DEPTIDDEPTNAME FLOORNO
DO01 Personal
DO02 Admin NULL
DO03 Production 1
DO04 Sales NULL

i) Write a SQL command to display all the records for which the data is not entered.

(1)
ii) WriteSQL command to delete all the records from the
a
table whose
names contain the letter P. department
(1)
 5

10. A scan centre has to create a database named COvID in

MYSQL. Create table
a
named CITY in the database to store the records of various
cities
table CITY has the
acro the globe. The
following structure: (3)
FIELD NAME TYPE OF
DATA CONSTRAINTS
CITYID CHARACTER OF SIZE 5 PRIMARY KEY
TDATE DATE NO DUPLICATE VALUES
COUNTRRY CHARACTER OF SIZE 20 MANDATORY COLUMN
CONFIRMED NUMERIC
RECOVERED NUMERIC
DEATHS NUMERIC
ACTIVE NUMERIC

Help the scan centre to complete the task by suggesting appropriate SQL commands.

Section C Each question carries 4 marks

11.
Write SQL commands for the following queries (i) to (v} based on the relations
TRAINER and COURSE given below: (4)
TRAINER

101 RAKSHITHA CHENNAI 2002-12-14 90000

102 SHAHID COIMBATORE 2003-01-24 70000

103 JANANI CHANDIGARH 2005-05-11 55000

104 REHANA BANGALORE 2004-10-14 78000

105 AKSHAY MUMBAI 2005-11-02 85000

BRINDHA CHENNA 2004-10-01 95000

106

107 RAKESH BANGALORE 2002-09-10 74000

 COURSE

2018-07-02 101
C201 PYTHON 12000

2018-07-15 103
c202 JAVA 15000

10000 2018-10-01 102

C204 C

c205 WEB DESIGN 9000 2018-09-15 104

C206 DATA ANALYTICS 20000 2018-08-01 101

C207 MACHINE 18000 2018-07-25 105

LEARNING

a) DISPLAY THE TRAINER NAME, CITY AND SALARY IN DESCENDING ORDER OF THEIR
HIREDATE.
b TO DISPLAY THE TRAINER ID, TRAINER NAME, CITY WHO JOINED THE INSTITUTE
IN THE YEAR 2004.
cTO DISPLAY TRAINER NAME, HIREDATE, COURSE NAME, START DATE FROM
TRAINER AND COURSE WHOSE FEES IS GREATER THAN 15000.
TO DISPLAY NUMBER OF TRAINERS FROM EACH CITY wHOSE CITY NAME STARTS
WITH "B" OR "C".

M Write two advantages of 46 over 3G Mobile Telecommunication Technologies in

terms of speed and services. (2)
iyDifferentiate between PAN and LAN type networks with suitable examples. (2)

OR
i) Differentiate between Web server and web browser. Write any two popular web
browsers. (2)
i) Define Domain Naming System. Give an URL and identify its domain name. (2)
13. "Shiksha for All" is an educational NGO. It is
for its
setting up its new
web-based activities. The campus has four campus at Jaipur
below: buildings as shown in the diagram
(4)

MAIN RESOURCE TRAINING

BUILDING BUILDING BUILDING

ACCOUNTS
BUILDINGG

Center to center distance between various

buildings as per architectural drawings (in
metres) is as follows:

Main Building to Resource Building 120m

Main Building to Training Building 40m
Main Building to Accounts Building 13Sm
Resource Building to Training 125m
Building
Resource Building to Accounts 4Sm 8
Building
Training Building to Accounts 110m
Building

Number of computers:

Main Building 15
Resource Building 25

Training Building 250

Accounts Building 10
 8

various blocks of buildings

connect
draw the cable lavout to efficiently
() Suggest and devices
within the centre for connecting
the digital
this NGo.
house the s e r v e r of
(i.e., buildings) to
place
(in) Suggest the most suitable
with justification.
Also, provide a suitable reason,
devices with justification:
the placement of the following
ii) Suggest
(a) Repeater (b) Hub/Switch
International office situated
in Delhi. Which
its
(iv) The NGO is planning to
connect
conmmunication links, will you
suggest for a very high speed
out of the following
wired

connectivity?
Fiber (ii) Ethernet Cable
Telephone Analog line (ii) Optical

ALLTHE BEST**