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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 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.
Define the term Overflow and Underflow in stack.

Question 2
(a) Expand the following:
WWW, RJ45

(b) XYZ company is planning to connect all computers, each spread over a distance of 50 meters. Suggest an economic cable type having high speed data transfer to connect these computers.

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

Question 3.
Define Database Management System.

Question 4.
Consider the following statement: db.rollback()
(a) What is the function of this statement in a program?

(b) Name the method when, rollback() method can be used to retrieve the original data that was changed through that method.

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

No Name TDATE KM TCODE NOP
11 Tanish Khan 2015-12-13 200 101 32
13 Danish Sahai 2016-06-21 100 103 45
15 Ram Kumar 2016-02-23 350 102 42
12 Fen Shen 2016-01-13 90 102 40
17 Aan Kumar 2015-02-10 75 104 2
14 Veena 2016-06-28 80 105 4
16 Raj pal Kirti 2016-06-06 200 101 25

Note :
NO is Driver Number
(a) SELECT NAME FROM TRIP WHERE KM>100;

(b) SELECT SUM (NOP) FROM TRIP WHERE TCODE=102;

(c) SELECT MAX (KM) FROM TRIP;

(d) SELECT * FROM TRIP WHERE NAME LIKE ‘%Kumar%’;

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

Question 6.
(a) Explain the degree of table.

(b) Which clause is used to remove the duplicating rows of the table?

Question 7.
Consider the table PERSON given below:
Table: PERSON

Name BankA/CNum AadharNum
Rahul 1290889909 1800991222
Gopal 1909090909 1908909090
Bhavish 1902090909 8298291282

(a) Differentiate between the primary key and alternatekey.

(b) Identify the primary key of given table.

OR

(a) Identify the candidate key(s) of table PERSON.

(b) Identify the alternate key of table PERSON.

Section – B
(3 Marks Each)

Question 8.
Write a program to implement a stack for these book details (book no, book name). That is, now each item node of the stack contains two types of information -a book no and its name. Just implement push and display operations.

OR

Convert the following infix into postfix form using stack.
(True AND False) OR (False AND True)

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

Question 9.
(a) In SQL, write the query to display the current Date and Time.

(b) Give Some examples of integrity constraints.

Question 10.
Write Python code to insert following records into the order details table.
Database → sales
Userid → Admin Password →salAd345 table name OrderDetails

ORDNUMB RARTNUMS NUMBORD QUOTPRIC
12489 AX12 11 14.95
12491 BT04 1 402.99
12492 BZ66 1 311.95
12498 CX11 2 57.95

Section – C
(4 Marks Each)

Question 11.
Write queries (a) to (d) based on tables, SCHOOL and ADMIN given below: IBB
Table: SCHOOL

CODE TEACHER SUBJECT DOJ PERIODS EXPERIENCE
1001 RAVI

SHANKAR

 ENGLISH 12/3/2000 24 10
1009 PRIYA RAI PHYSICS 03/09/1998 ! 26 12
1203 LIS ANAND ENGLISH 90/04/2000 27 5
1045 YASHRAJ MATHS 28/8/2000 24 15
1123 GAGAN PHYSICS 16/7/1999 ! 28 3
1167 1 lansh B Chemistry 19/10/1999 | 27 5
1215 Umesh Physics 11/05/1998 i 22 16

Table: ADMIN

CODE Gender Designation
1001 Male Vice Principal
1009 Female Co-ordinator
1203 Female Co-ordinator
1045 Male HOD
1123 Male Senior Teacher
1167 Male Senior Teacher
1215 Male HOD

(a) To display TEACHERNAME, PERIODS of all teachers whose periods are more than 25.

(b) To display all the information from the table SCHOOL in descending order of experience.

(c) To display DESIGNATION without duplicate entries from the table ADMIN.

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

(d) To display TEACHERNAME, CODE and corresponding DESIGNATION from tables SCHOOL and ADMIN of Male teachers.

Question 12.
(a) Differentiate between Web server and web browser. Write any two popular web browsers.
OR
Write one advantage of star topology of network. Also, illustrate how five(5) computers can be connected with each other using star topology of network.

(b) What is an IP address?

Question 13.
ABC is professional consultancy company. The company is planning to set up their new offices in India with its hub at Bengaluru. As a network adviser, you have to understand their requirement and suggest them the best available solutions.
Their queries are mentioned as (a) to (d) below:
Block to Block distances (in Mtr):

Block (From) Block (To) Distance
Human Resource Conference 110
Human Resource Finance 40
Conference Finance 80

Expected Number of computers to be installed in each block:

Block Computers
Human Resource 25
Finance 120
Conference 90

(a) What will be the most appropriate block,where ABC should plan to install their server?

(b) Draw a block diagram showing cable layout to connect all the buildings in the most appropriate manner for efficient communication.

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

(c) What will be the best possible connectivity out of the following, you will suggest to connect the new setup of offices in Chennai with its London based office.

  • Satellite link
  • Infrared
  • Ethernet cable

(d) Which of the following device will be suggested by you to connect each computer in each of the buildings?

  • Switch
  • Modem
  • Gateway