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