Students can access the CBSE Sample Papers for Class 12 Computer Science with Solutions and marking scheme Term 2 Set 8 will help students in understanding the difficulty level of the exam.
CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 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.
Explain any one example of stack.
Question 2.
(a) Expand the following:
HTTE IRC
(b) Neha wants to transfer data within a city at very high speed. Write the wired transmission medium and type of network.
Question 3.
What keys are used in DBMS?
Question 4.
What is a database connection? How is a database connection established?
Question 5.
Write the output of the queries (a) to (b) based on the table, Teacher given below
Table: Teacher
T_ID | Name | Age | Department | Date_of_join | Salary | Gender |
1 | Jugal | 34 | Computer Sc | 10/01/2017 | 12,000 | M |
2 | Sharmila | 31 | History | 24/03/2008 | 20,000 | F |
3 | Sandeep | 32 | Mathematics | 12/12/2016 | 30,000 | M |
4 | Sangeeta | 35 | History | 01/07/2015 | 40,000 | F |
5 | Rakesh | 42 | Mathematics | 05/09/2007 | 25,000 | M |
6 | Shyam | 50 | History | 27/06/2008 | 30,000 | M |
7 | Shiv Om | 44 | Computer Sc | 25/02/2017 | 21,000 | M |
8 | Shalakha | 33 | Mathematics | 31/07/2018 | 20,000 | F |
(a) SELECT Name FROM Teacher WHERE Salary>2 5000 ;
(b) SELECT Name, Department FROM Teacher WHERE Department LIKE ‘%Sc’;
(c) SELECT T_ID, Department FROM Teacher WHERE Gender = ‘F’;
(d) SELECT DISTINCT Department FROM Teacher;
Question 6.
(a) Which declaration doesn’t use the same number of bytes and consumption of bytes depend on the
input data?
(b) Write any two aggregate function used in SQL.
Question 7.
Consider the table, STUDENT given below:
Table: STUDENT
Admn. No. | Roll No. | Name | Class | Makrs |
2715 | 1 | Ram | 12 | 90 |
2716 | 2 | Ajay | 11 | 98 |
2811 | 3 | Jayesh | 12 | 98 |
2914 | 4 | Tarun | 11 | 94 |
(a) Which field should be made the primary key? Justify your answer.
(b) Identify the degree and cardinality of given table.
OR
(a) Identify the candidate key(s) of table STUDENT.
(b) Identify the alternate key of table STUDENT
Section – B
(3 Marks Each)
Question 8.
Write an algorithm to evaluate postfix expression.
OR
Riya has a list containing 8 integers. You need to help her create a program with separate user defined functions to perform the following operations based on this list.
- Traverse the content of the list and push the odd numbers into a stack.
- Pop and display the content of the stack.
For Example:
If the sample Content of the list is as follows:
Listl = [26,45,89,32,44,61,41,99]
Sample Output of the code should be:
99 41 61 89 45
Question 9.
(a) What is the default format for “Datetime” &”Timestamp” data type?
(b) Define Equi join.
Question 10.
Consider the following table, Emp given below:
Table: Emp
EmpNo | EmpName | Job | Mgr | Hiredate | Sal | DeptNo |
7839 | Mahesh | President | 7872 | 17/11/01 | 5,000 | 10 |
7698 | Krishna | Manager | 7839 | 01/5,81 | 2,600 | 25 |
7872 | Anubhav | Manager | 7839 | 31/3/83 | 2,700 | 30 |
7566 | Siddhant | Manager | 7839 | 23/6/82 | 2650 | 15 |
7564 | Arnav | Asst. Manager | 7698 | 18/7/81 | 1,000 | 25 |
7560 | Khyati | Receptionsit | 7872 | 21/2/84 | 1,000 | 30 |
Write Python code to insert 2 records with suitable data in the above table taking system date as Hiredate.
Section – C
( 5 Marks Each)
Question 11.
Write SQL queries for (a) to (d) on the basis of table, ITEMS and TRADERS given below:
Table: ITEMS
CODE | INAME | QTY | PRICE | COMPANY | TCODE |
1001 | DIGITAL PAD 12i | 120 | 11,000 | XENTA | T01 |
1006 | LED SCREEN 40 | 70 | 38,000 | SANTORA | T02 |
1004 | CAR GPS SYSTEM | 50 | 21,500 | GEOKNOW | T01 |
1003 | DIGITAL CAMERA 12X | 160 | 8,000 | DIGICLICK | T02 |
1005 | PEN DRIVE 32 GB | 600 | 1,200 | STOREHOME | T03 |
Table: TRADERS
TCODE | TNAME | CITY |
T01 | ELECTRONIC SALES | MUMBAI |
T03 | BUSY STORE CORP | DELHI |
T02 | DISP HOUSE INC | CHENNAI |
(a) To display the details of all the items in ascending order of item names (i.e., INAME).
(b) To display item name and price of all those items,whose price is in the range of 10000 and 22000 (both values inclusive).
(c) To display the number of items, which are traded by each trader. The expected output of this query should be:
T01 2 T02 2 T03 1
(d) To display item names and traders name from both tables who are in Delhi.
Question 12.
(a) Name the protocol:
- Used to transfer voice using packet switched network.
- Used for chatting between two groups or between two individuals.
OR
What is web hosting?
(a) What is ARPANET?
Question 13.
Uplifting Skills Hub India is a knowledge and skill community which has an aim to uplift the standard of knowledge and skills in the Society. It is planning to setup its training centers in multiple towns and villages pan India with its head offices in the nearest cities. They have created a model of their network with a city, a town and 3 villages as follows:
As a network consultant, you have to suggest the best network related solutions for their issues/problems raised in (a) to (b) keeping in mind the distance between various locations and given parameters.
Shortest distance between various location:
VILLAGE 1 to B_TOWN | 2 KM |
VILLAGE 2 to B_TOWN | 1.0 KM |
VILLAGE 3 to B_TOWN | 1.5 KM |
VILLAGE 1 to VILLAGE 2 | 3.5 KM |
VILLAGE 1 to VILLAGE 3 | 4.5 KM |
VILLAGE 2 to VILLAGE 3 | 2.5 KM |
A_CITY Head Office to B HUB | 25 KM |
Number of Computers installed at various locations are as follows:
BTOWN | 120 |
VILLAGE 1 | 15 |
VILLAGE 2 | 10 |
VILLAGE 3 | 15 |
A_CITY Head OFFICE | 6 |
Note:
- Â In Villages, there are community centres, in which one room has been given as training centre to this organization to install computers.
- The organization has got financial support from the government and top IT companies.
(a) Suggest the most appropriate location of the SERVER in the the B_HUB out of the 4 locations), to get the best and effective connectivity. Justify your answer.
(b) Suggest the best wired medium and draw the cable layout (location to location) to efficiently connect various locations within the B_HUB.
(c) Which hardware device will you suggest to connect all the computers within each location of B_HUB?
(d) Which service/protocol will be most helpful to conduct live interactions of Experts from Head Office and people at all locations of B_HUB ?