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
(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?
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.
(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