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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 6 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.
Convert to postfix notation:
(A+B)*C/D

Question 2.
(a) Expand the following:
PPP, HTML

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

(b) Rahul has to share the data among various computers of his two office branches situated in the same city. Name the network (out of LAN, MAN,PAN and MAN) which is being formed in this process.

Question 3.
Explain database.

Question 4.
Consider the statement given below:
MySQLdb.connect(‘localhost’,’LibMan’,’isspwd’,’Library’)

(a) What is “Library” in the statement?

(b) What is “LibMan” in the statement?

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

ADMNO GAME COACHNAME GRADE
1215 CRICKET MR RAVI A
1213 VOLLEYBALL MR. AMANDEEP B
1211 VOLLEYBALL MR. GOVARDHAN A
1212 BASKETBALL MR. TEWARI B

(a) SELECT GAME FROM SPORTS WHERE GRADE=’A’;

(b) SELECT COACHNAME FROM SPORTS WHERE GAME LIKE ‘%KET’;

(c) SELECT ADMNO, GRADE FROM SPROTS WHERE ADMNO>1215;

(d) SELECT GRADE FROM SPORTS WHERE GAME=”BASKETBALL;

Question 6.
(a) Which command is used to modify the records of the table?

(b) What is a query result set?

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

Question 7.
Consider the table Patients:
Table: Patients

PatNO PatName Dept DocID
1 Leena ENT 100
2 Supreeth Ortho 200
3 Madhu ENT 100
4 Neha ENT 100
5 Deepak Ortho 200

(a) What is degree?

(b) Define cardinality.

OR

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

(b) Identify the primary key of table Patients.

Section – B
(3 Marks Each)

Question 8.
Write a function to push any student’s information to stack.
OR
Convert (A+ (B*C – (D/ E ^ F) * G) * H) into postfix form showing stack status after every step.

Question 9.
(a) Which type of relationship is supported by network model?

(b) What is join in SQL?

Question 10.
Create following table using Python code.
Table Name = Customer
Database – xyzcorp Userid – Adminxyz Password – Axydml2

CUSTNUMB CUSTNAME ADDRESS BALANCE CREDLIM SLSRNUMB
124 TINA ADAMS 481 Tilak lane, CP, Delhi 41800.75 50,000 3
256 R VENKAT 215 Mylapore, Chennai 100000.75 80,000 6
567 BHUVNA BALAJI 808,  Bala  Nagar, Hyderabad 57,000.75 50000 6
622 PRATHAMJAIN 149, Plot 182, sec-9 Dwarka, Delhi 57500.75 80,000 12

Section – C
(4 Marks Each)

Question 11.
Write SQL queries for (a) to (d) based on tables, ACCOUNT and TRANSACT given below:
TABLE: ACCOUNT

ANO ANAME ADDRESS
101 Nirja Singh Bangalore
102 Rohan Gupta Chennai
103 Ali Reza Hyderabad
104 Rishabh Jain Chennai
105 Simran Kaur Chandigarh

TABLE: TRANSACT

TRNO ANO AMOUNT TYPE DOT
T001 101 2500 Withdraw 2017-12-21
T002 103 3000 Deposit 2017 – 06 -1
T003 102 2000 Withdraw 2017-06-12
T004 103 1000 Deposit 2017-10-22
T005 101 12000 Deposit 2017-11-06

(a) To display details of all transactions of TYPE Deposit from Table TRANSACT.

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

(b) To display the ANO and AMOUNT of all Deposits and Withdrawals done in the month of October 2017 from table TRANSACT

(c) To display the last date of transaction (DOT) from the table TRANSACT for the Accounts having ANO as 103.

(d) To display the ANAME and AMOUNT from tables given above for those whose address is Chennai.

Question 12.
(a) Write one advantage of bus topology of network. Also illustrate how four (4) computers can be
connected with each other using bus topology of network.
OR
Explain the purpose of a Switch.

(b) What is the difference between e-mail and chat?

Question 13.
Meerut school in Meerut is starting up the network between its different wings. There are four buildings named as S, J, A and H.
The distance between various buildings is as follows:

A to S 200 m
A to J 150 m
AtoH 50 m
S to J 250 m
StoH 350 m
J to H 350 m

Number of computers in each Building:

S 130
J 80
A 160
H 50

(a) Suggest the cable layout of connections between the buildings.

(b) Suggest the most suitable place (i.e. building) to house the server of this school, provide a suitable reason.

(c) Suggest the placement of the following devices with justification:

  • Repeater
  • Hub/Switch

(d) The organization also has inquiry office in another city about 50-60 km away in hilly region. Suggest the suitable transmission media to interconnect to school and inquiry office out of the following:

  • Fibre optic cable
  • Micro wave
  • Radio wave