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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 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.
Evaluate the following postfix notation of expression,show status of stack after every operation. 12,2,4 34,20,-, +, 5, +

Question 2.
(a) Expand the following:
HTTPS, POP3

(b) Which device is used to connect all computers inside a lab?

Question 3.
Name the keys used in DBMS.

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

Question 4.
What is a cursor? Also, write a checklist before connecting to a database.

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

RCODE PLACE RENT TYPE STARTDATE
R001 GOA 15000 5 STAR 12-Jan-02
R002 HIMACHAL 9000 4 STAR 20-Dec-07
R003 KERALA 12500 5 STAR 10-Jan-06
R004 HIMACHAL 10500 2 STAR 25-Jan-05
R005 GUJARAT 8000 4 STAR 01-Jan-03
R006 GOA 18000 7 STAR 30-Jan-08
R007 ORISSA 7500 2 STAR 12-Jan-99
R008 KERALA 11000 5 STAR 03-Jan-03
R009 HIMACHAL 9000 2 STAR 15-Jan-08
R010 GOA 13000 5 STAR 12-Jan-06

(a) SELECT PLACE FROM RESORT WHERE RENT>15000;

(b) SELECT RCODE, TYPE FROM RESORT WHERE PLACE LIKE ‘%CHAL’;

(c) SELECT MAX (RENT) FROM RESORT;

(d) SELECT DISTINCT TYPE FROM RESORT;

Question 6.
(a) What is the maximum length of the char columns?

(b) “Numeric Data” is used to store, what type of value?

Question 7.
Observe the table, CLUB given below:
Table: CLUB

Member_ID Member_Name Address Age Fee
M0001 Sumit New Delhi 20 2000
M0002 Nisha Gurgaon 19 3500
M0003 Niharika New Delhi 21 2100
M0004 Sachin Faridabad 18 35000

What is the Cardinality and Degree of the given table?
If a new column Contact No is added and three more members join the club then how these changes will affect the degree and cardinality of the table.
OR
Identify the primary key of table CLUB.
Identify the candidate key(s) of table CLUB.

Section – B
(3 Marks Each)

Question 8.
Write a Python program to check if a string is a palindrome or not.

OR

What are infix, prefix, postfix notations? Also, convert following infix to postfix notation.
((A+B)*C/D+Et)/G

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

Question 9.
(a) A table CUSTOMER has 10 columns but no row. Later, 10 new rows are inserted and 3 rows are
deleted in the table. What is the degree and cardinality of the table CUSTOMER?

(b) Define the following:
Equi-Join, Natural Join

Question 10.
Write a Python code to create a table EMPLOYEE, whose fields with their data type are

  • FIRST_NAME CHAR(20) NOT NULL
  • LAST_NAME CHAR(20)
  • AGE INT
  • SEX CHAR(l)
  • INCOME FLOAT

Section – C
(4 Marks Each)

Question 11.
Write queries (a) to (d) based on the tables, WORKER and PAYLEVEL given below:
Table: WORKER

ECODE NAME DESIGN PLEVEL DOJ DOB
11 Radhe Shyam Supervisor P001 13-Sep-2004 23-Aug-1981
12 Chander Nath Operator P003 22-Feb-2010 12-Jul-1987
13 Fizza Operator P003 14-Jun-2009 14-Oct-1983
15 Ameen Ahmed Mechanic P002 21-Aug-2006 13-Mar-1984
18 Sanya Clerk P002 19-Dec-2005 09-Jun-1983

Table: PAYLEVEL

PLEVEL PAY ALLOWANCE
P001 26000 12000
P002 22000 10000
P003 12000 6000

(a) To display the name of all Workers in descending order of DOB.

(b) To display NAME and DESIGN of those Workers, whose PLEVEL is either P001 or P002.

(c) To display the content of all the worker table, whose DOB is in between T9-JAN-1984′ and ’18- JAN-1987′.

(d) To display name of workers with their allowance whose pay is more than 20000.

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

Question 12.
(a) Define microwave transmission media.
OR
What is Hypertext Transfer Protocol?

(b) Give any four differences between LAN and MAN.

Question 13.
Software Development Company has set up its new center at Raipur for its office and web based activities. It has 4 blocks of building named Block A, Block B, Block C, Block D.
Number of Computers

Block A 25
Block B 50
Block C 125
Block D 10

Shortest distances between various Blocks in meters:

Block A to Block B 60
Block B to Block C 40
Block C to Block A 30
Block D to Block C 50

(a) Name the most suitable block where the server should be installed.

(b) Suggest the type of network to connect all the blocks with suitable reason.

(c) The company is planning to link all the blocks through secure and high-speed wired medium. Suggest a way to connect all the blocks.

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

(d) Suggest the most suitable wired medium for efficiently connecting each computer installed in every block out of the following network cables:

  • Coaxial Cable
  • Ethernet Cable
  • Single Pair Telephone Cable