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

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

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

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

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

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

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

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

(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.
CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice 1

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.

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

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