Reg No:-

CONFEDERATION OF KERALA SAHODAYA COMPLEXES

COMMON MODEL TERM II EXAMINATION 2021-22
Computer Science (083)

CLASS : XII TIME ALLOWED: 2hrs

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 some questions.

Section -A
Each question carries 2 marks
Q.No Part Question Marks
No.
1. What is LIFO data structure? Give any two applications of a stack? 2
2. a. 1
Compare the Hub and Switch?
b. 1
Expand DNS, URL?
3. 2
Write two points of difference between DDL & DML commands?
4. 1. 1
Write two examples of DBMS software?
2. 1
Differentiate between fetchone() and fetchall() methods?
5.` Consider the following table FITNESS with details about fitness products being 2
sold in the store. Write output for (i) to (iv)

Table: FITNESS
PCODE PNAME PRICE MANUFACTURER
P1 Treadmill 21000 Coscore
P2 Bike 20000 Aone
P3 Cross 14000 Reliable
Trainer
P4 Multi Gym 34000 Coscore
P5 Massage chair 5500 Regrosene
i. SELECT PCODE,PRICE FROM FITNESS WHERE MANUFACTURER
LIKE “%e”;
ii. SELECT COUNT (DISTINCT MANUFACTURER) FROM FITNESS;

1
 iii. SELECT MAX (PRICE) FROM FITNESS;
iv. SELECT PCODE,PNAME FROM FITNESS WHERE MANUFACTURER IS
Coscore;
6. 1. Write the SQL command to display the structure of the table DEPT? 1
2. Explain the concept of CARTESIAN JOIN with example? 1
7. Consider the table TEACHER given below. Write commands in SQL for (a) 2
to (b)

Table:TEACHER
TNo. T_Name Age Department Dateofadm Salary Sex
001 Jugal 34 Computer 10-01-1997 12000 M
002 Sharmila 31 History 24-03-1998 20000 F
003 Sandeep 32 Maths 12-12-1996 30000 M
004 Sangeeta 35 History 01-07-1999 40000 F
005 Rakesh 42 Maths 05-09-1997 25000 M
006 Shyam 50 History 37/06/98 30000 M
007 Shivam 44 Computer 25-02-1997 21000 M
008 Shalakha 33 Maths 31-07-1997 20000 F

Table:STUDENT
Roll TNo. Name Age Sex
No
100 001 Harikesh 34 M
101 002 Rudra 31 F
102 003 Sreedev 32 M
103 004 Gouthami 35 F
104 005 Roopesh 42 M
105 006 Sharan 50 M
106 007 Shivadaksh 44 M
107 008 Malavika 33 F

a. Identify the degree and cardinality of the table TEACHER?

b. Which field should be made the primary key? Justify your answer?
OR
a. Which field will be considered as the foreign key if the tables TEACHER and
STUDENT are related in a database?
b. Identify the candidate key(s) from the table TEACHER?
SECTION – B
Each question carries 3 marks
8. Javid has created a dictionary containing names and marks as key 3
value pairs of 5 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
79.
• Pop and display the content of the stack.
For example:
If the sample content of the dictionary is as
follows:
R={"RAKESH":70, "OMESH":50, "VISWAS":70, "ANITA":80,
"ANUSHRI":90}

The output from the program should be: ANUSHRI ANITA

2
 OR
Alam has a list containing marks of 10 students . 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 numbers higher than 33
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:

34,56,79,98,35,38

38,35,98,79,56,34

9. a. A table, PURCHASE has been created in a database with the following fields: 2
PCODE, PNAME, QTY, PPRICE
Give the SQL command to add a new field, DISCOUNT (of type Integer) to the
PURCHASE table.
b. Write one point of difference between Delete & Drop ? 1
10. Write a Query to Create a database named as “INDUSTRY” and after 3
creating write a query to open it?
Write a SQL statement to create a table named Job under this database
industry, the table
includes columns JOB_ID, JOB_TITLE, MIN_SAL and MAX_SAL,
BONUS and make sure that the
job_id column should be primary key and job_title should not be empty.

Database :- INDUSTRY

Table:- Job

FIELD NAME DATA TYPE REMARKS

JOB_ID VARCHAR(10) PRIMARY KEY
JOB_TITLE VARCHAR(35) NOT EMPTY
MIN_SAL INTEGER
MAX_SAL INTEGER
BONUS INTEGER

3
 Section C
Each question carries 4 marks
11. 4
Write queries (a) to (d) based on the tables VEHICLE and OWNER given below:

TABLE: VEHICLE

VNO COMPANY MODEL MAKE PRICE

RJ06AB1234 MARUTI SUZUKI BALENO 2018 8.5

RJ27CD5243 HONDA AMAZE 2015 9.5

RJ27BK3245 MARUTI SUZUKI ALTO K10 2021 4.3
RJ14AJ0053 HONDA JAZZ 2020 5.5
RJ30KA2364 TATA TIAGO 2020 4.8
TABLE:OWNER

ID OWNER_NAME AGE CITY VNO

101 HARSH SINGH 35 JODHPUR RJ14AJ0053
102 ANMOL SAINI 40 KOTA RJ30KA2364
103 RAJAT SHARMA 45 ALWAR RJ06AB1234
104 RITIKA SINHA 30 BIKANER RJ27CD5243
105 MONIKA 25 BHILWARA RJ27BK3245

A. To display details of vehicles of MARUTI SUZUKI in the ascending order

of price.
B. To display maximum price based on the year of make.
C. To display vehicle number, Owner name and model of vehicles.
D. Display average age of owners of MARUTI SUZUKI.
a. Which of the following (i) is not a broadcast device (ii) offers a dedicated
12. bandwidth ? 2
(a) Repeater
(b) Bridge
(c) Hub
(d) Switch OR
(i)Aman works for an IT company which provides custom-application softwares.
One of his clients does not know how to install one such software on his computer.
Which protocol would Aman use to assist the client for remote installation of a
particular application software?
(ii) Tejas wants to download all his emails on his ipad and read them whenever he is
free. Which protocol would be used?
b. (i) Identify the following from the URL : https://www.sample.com/cs_books.html 2
Name the protocol being used
Name of the server on the Internet Domain Indicator
Name of the resource being accessed
(ii) What is the difference between HTML and XML?(any two)

4
13. Motherson Corporation has set up its new centre at Jaipur, Rajasthan for its office 4
and web-based activities. It has 4 blocks of buildings.

Distance between the various blocks is as follows:

A to B - 50 m
B to C - 110m
C to D - 90m
A to D - 160m
B to D - 140m
A to C - 80m

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 Jaipur 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 Jaipur 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 Jaipur.