CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

Students can access the CBSE Sample Papers for Class 12 Computer Science with Solutions and marking scheme Term 2 Set 10 will help students in understanding the difficulty level of the exam.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

Time: 2 Hours
Maximum 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 question numbers 7, 8 and 12.

Section – A
(2 Marks Each)

Question 1.
Write equivalent postfix expressions for the following infix expression : a+b*d = (a+(b*d))

Question 2.
(a) Expand the following:
ARPANET, MAN

(b) Which device is used to connect all computers to the Internet using telephone wire?

Question 3.
What is the need of DBMS? HD

Question 4.
List the most common parameters and the usage that are passed to communicate with the database.

Question 5.
Write the output (a) to (d) based on the table, CABHUB given below:
Table: CABHUB

Vode	VehicleName	Make	Colour	Capacity	Charge
100	Innova	Toyota	White	7	15
102	SX4	Suzuki	Blue	4	14
104	C Class	Mercedes	Red	4	35
105	A-Star	Suzuki	White	3	14
108	Indigo	Tata	Silver	3	12

(a) SELECT SUM(Charges) FROM CABHUB WHERE Capacity>3;

(b) SELECT MIN(Capacity) FROM CABHUB;

(d) SELECT Make FROM CABHUB WHERE Colour IN (“BLUE”, “RED”);

Question 6.
(a) Which declaration represents that “character data will consume the same number of bytes as
declared and is right padded”?

(b) Name any two DDL commands.

Question 7.
Consider the table, BOOK given below:
TABLE BOOK

CODE	BNAME	TYPE
F101	The Priest	Fiction
L102	German easy	Literature
C101	larzan in the lost world	Comic
F102	Untold Story	Fiction
C102	War heroes	Comic

(a) Identify the degree and cardinality of the table.

(b) Which field should be made the primary key? Justify your answer

(a) Identify the candidate key(s) from the table BOOK.

(b) Consider the table AUTHOR, whose fields are A_ID, CODE, N AME
Which field will be considered as the foreign key if the tables BOOK and AUTHOR are related in a database?

Section – B
(3 Marks Each)

Question 8.
Write an algorithm to implement push operation and pop operation.

Siya has created a dictionary containing names and salary as key value pairs of 5 employees.
Write a program, with separate user defined functions to perform the operation as Push the keys (name of the employee) of the dictionary into a stack, where the corresponding value (salary) is greater than 25000 and also perform the operation as Pop and display the content of the stack.
For example:
If the sample content of the dictionary is as follows:
details = {“Rahul”:25000, “Jai”:45000, “Kinshu”:20000, “Riya”:18000, “Anu”:28000}
The output from the program should be:
Anu Rahul

Question 9.
(a) What are all the domain names possible in gender?

(b) Differentiate between cardinality and degree of a table with the help of an example.

Question 10.
Write a Python code to insert following records into table Orders as follow:
Database → Sales
userid → Salesmanl password → orders
Table: Orders

ORDNUMB	CUSTNO	ORDDTE
12489	124	01-03-98
12491	311	10-3-98
12495	315	31-03-98
12498	522	10-4-98

Section – C
(4 Marks Each)

Question 11.
Write query (a) to (d) based on the tables, ACTIVITY and COACH given below:
Table: ACTIVITY

ACode	Activity Name	Stadium	Participants Num	Prize Money	Schedule Date
1001	Relay 100 x 4	Star Annex	16	10000	23-Jan-2004
1002	High Jump	Star Annex	10	12000	12- Dec-2003
1003	Shot Put	Super Power	12	9000	01-Jan-2004
1005	Long Jump	Star Annex	12	9000	01-Jan-2004
1008	Discuss Throw	Super Power	10	15,000	19-Mar-2004

Table: COACH

PCode	Name	ACode
1	Ahmad Hussain	1001
2	Ravinder	1008
3	Janila	1001
4	Naaz	1003

(a) To display the names of all activities with their Acodes in descending order.

(b) To display sum of PrizeMoney for the Activities played in each of the Stadium separately.

(d) To display the activity name and coach name whose participants are more than 15.

Question 12.
(a) What is URL? Identify the domain name and URL from the following:
http://www.income.in/home.aboutus.html

Write the features of Gateways in networking.
(b) Distinguish between MAN and WAN.

Question 13.
Rovenza Communications International (RCI) is an online corporate training provider company for IT related courses. The company is setting up their new campus in Kolkata. You as a network expert have to study the physical locations of various blocks and the number of computers to be installed. In the Physical Location of the building of RCI computers to be installed. In the
possible answers for the queries (i) to (iv) raised by them.

Block to block distance (in Mtrs)

From	To	Distance
Administrative Building	Finance Building	60
Administrative Building	Faculty Studio	120
Finance Building	Faculty Studio Building	70

Expected computers to be installed in each block
(a) Suggest the most appropriate block, where RCI should plan to install the server.

(b) Name the topology that form to connect all three blocks for efficient communication.

(d) Which wireless channel out of the following should be opted by RCI to connect to students from all over the world?

Infrared
Microwave
Satellite