Practice 5

PRACTICE PAPER - 5
Std : XII(CBSE) Marks : 35

Date : 05.06.2022 COMPUTER SCIENCE Time : 2 hours.
General Instructions :
1. The question paper is divided into 3 Sections - A, B and C
2. Section A consist of 7 Questions (1-7). Each question carries 2 marks.
3. Section B consist of 3 Questions (8-10). Each question carries 3 marks.
4. Section C consist of 3 Questions (11-13). Each question carries 4 marks.
5. Internal choices have been given for question numbers – 7, 8 and 12.
Section-A
Each question caries 2 marks
Q. Par Question Mark
No t s
No.
1. Differentiate Data types and Data structure. (2)
2. (i) Expand the following: (1)
TCP , RJ-45
(ii) Out of the following, which is the fastest wired and wireless medium of (1)
transmission?
Infrared, coaxial cable, optical fibre, microwave, Ethernet cable
3. Differentiate between Drop and Delete commands. (2)
4. What are the functions/methods used in MySQL – Python connectivity (2)
program?
5. (2)
Obtain the outputs of the following SQL queries based on the data
given in tables ITEMS and TRADERS above.
a. SELECT MAX (PRICE), MIN (PRICE) FROM ITEMS;
b. SELECT PRICE*QTY FROM ITEMS WHERE CODE-1004;
c. SELECT DISTINCT TCODE FROM ITEMS;
d. SELECT INAME, TNAME FROM ITEMS I, TRADERS T
WHERE I.TCODE=T.TCODE AND QTY< 100;
2
6. (i) Write the command used to change school database from college (1)
database?
(ii) What are the commands available in DML? (1)
7. (2)
Consider the following tables STORE and SUPPLIERS and answer
the following questions :
a. Identify a foreign key from the above tables.

b. What is the degree and cardinality of STORE table?
OR
a. What will be the degree and cardinality after the Cartesian
product of above two tables?
b. What are the candidate keys available in STORE table?
Section-B
8. Write PushOn(Book) and Pop(Book) methods/functions in Python to (3)

add a new Book and delete a Book froma list of Book titles,
considering them to act as push and pop operations of the Stack data
structure.
OR
Write the functions in Python push (stk, item ) and pop(stk) to check
whether the stack is empty, to add a new item, to delete an item and
display the stack respectively.
9. (i) Write SQL query to add a column total price with datatype integer (1)
with primary key in a table product.

(ii) Categorize following commands into DDL and DML commands? (2)
INSERT INTO, DROP TABLE, ALTER TABLE,
UPDATE...SET
10 Aadhi has to create a table named SCHOOL in the database to store (3)
3
. the records of various teachers. The table SCHOOL has the
following structure:
Table: SCHOOL
FIELD NAME DATA TYPE REMARKS
CODE INTEGER PRIMARY KEY
TEACHER CHAR(30)
SUBJECT CHAR(10)
DOJ DATE NOT NULL
PERIODS INTEGER
EXPERIENCE INTEGER DEFAULT 1
Help him to complete the task by suggesting appropriate SQL

commands.
Section-C
11 (4)
Consider the following tables CARDEN and CUSTOMER and answer
.
following:
Write SQL commands for the following statements:

e. To display the names of all the silver coloured cars.
f. To display names of car, make and capacity of cars in descending
order of their sitting capacity.
g. To display the highest charges at which a vehicle can be hired
from CARDEN.
h. To display the customer name and the corresponding name of the
cars hired by them.
12 (i) Give two advantages and two disadvantages of Star topology (2)
. OR
Define the following terms:
Web server , XML
(ii) Define the following terms: (2)
Interspace, Internet
4
13 G.R.K International Inc. is planning to connect its Bengaluru Office (4)
. Setup with its Head Office in Delhi. The Bengaluru Office G.R.K.
international Inc. is spread across and area of approx. 1 square
kilometer, consisting of 3 blocks – Human Resources, Academics
and Administration.
You as a network expert have to suggest answers to the four
queries (i) to (iv) raised by them.
Notes : Keep the distance between blocks and number of
computers in each block in mind, while providing them the
solutions.
a. Suggest the most suitable block in the Bengaluru Office Setup,

to host the server.
Give a suitable reason with your suggestion.
b. Suggest the cable layout among the various blocks within the
Bengaluru Office Setup for
connecting the Blocks.
c. Suggest a suitable networking device to be installed in each of
the blocks essentially required for connecting computers inside
the blocks with fast and efficient connectivity.
d. Suggest the most suitable media to provide secure, fast and
reliable data connectivity between Delhi Head Office and the
Bengaluru Office Setup.

Practice 5

Uploaded by

Copyright:

Available Formats

Practice 5

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Practice 5

Uploaded by

Copyright:

Available Formats

PRACTICE PAPER - 5

Std : XII(CBSE) Marks : 35

a. Identify a foreign key from the above tables.

8. Write PushOn(Book) and Pop(Book) methods/functions in Python to (3)

with primary key in a table product.

Help him to complete the task by suggesting appropriate SQL

Write SQL commands for the following statements:

a. Suggest the most suitable block in the Bengaluru Office Setup,

You might also like