# Best CS Sample Paper Class 12 Term 2

Share with others

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

## Q3. Define the following terms:

1. Primary Key
2. Candidate Key

## Q5. Write the output of the queries (a) to (d) based on the table,“Student” given below:

a. Select min(Fees) from Student;

b. Select * from Student where Fee >=3000 and Class = 9;

c. Select * from Student where Name like “%n”;

d. Select * from student where Gender = “M” order by Fees;

## Q7. Consider the following table “stock” and answer the following:

1. Which field can act as primary key?
2. Write the degree and cardinality of table “stock”.

## Q8. Suman has created a dictionary “Item” with item name as key and their cost as values. Write a user defined functions to perform the following operations:

(a) Push the names of those items into a stack whose cost is less than 500
(b) Pop the elements of the stack and display the names of items.

```For example:
If the sample content of the dictionary is as follows:

D = {"Book" : 600, "Cup Set" : 450, "Mobile Cover" : 300, "Mouse" : 250}

The output from the program should be:

Cup Set
Mobile Cover
Mouse```

## Q8. Kartik has created a list ‘alpha’ containing any 10 alphabets of English alphabets. Write a user defined functions to perform the following operations:

1. Traverse the content of the list and push all the vowels into a stack.
2. Pop and display the content of the stack.
```For Example:
If the sample Content of the list is as follows:

N = ['A', 'C', 'B', 'G', 'J', 'E', 'K', 'L', 'O', 'D']
Sample Output of the code should be:

A E O```

## Q9. Aman has written the following queries. Both the queries are giving some error. Help him to write the correct query.

1. Select * from book where price = NULL;
2. Select class, fees from students where name = “%t”;

## Q10. Raman wants to perform the following task in MySQL. Help him to write the commands for the following task.

1. Create a database named “school” in MySQL.
2. Create the following table “Employee”:

## Q11. Write queries (a) to (d) based on the tables STUDENT and BOOK given below:

STUDENT :

BOOK :

1. Display details of students in increasing order of Fees.
2. Display student name and respective Author name.
3. Display Author Name, Subject of those books whose cost is more than 300 and less than 500.
4. Display details of those students whose names ends with ‘n’.

## Q12. Answer the following questions:

1. What is the difference between Switch and Hub?

OR

What is the difference between Packet switching and Circuit Switching?

2. Explain the terms VoIP and TELNET.

## Q13. A, B, C, and D are four buildings of an IT company. Mr Ramesh want to connect all the four buildings .The distance between various buildings are as follows:

A to B – 200m
A to C – 150m
A to D – 50m
B to C – 250m
B to D – 350m
C to D – 350m

Number of computers in each building are

A – 160
B – 130
C – 80
D – 50

## Based on the above specifications, answer the following questions:

1. Suggest the cable layout of connections between the buildings.
2. Suggest the most suitable building to house the server, with suitable reason.
3. Suggest the placement of the following device with justification

1. Repeater
2. Hub/Switch

4. Suggest the most suitable wire for fast and secure .

Disclaimer : I tried to give you the correct format of “CS Sample Paper Class 12 Term 2” , but if you feel that there is/are mistakes in the Questions of CS Sample Paper Class 12 Term 2 given above, you can directly contact me at csiplearninghub@gmail.com. NCERT book and CBSE study material is used to create CS Sample Paper Class 12 Term 2 questions.

## MCQ of Computer Science Chapter Wise

1. Functions in Python

2. Flow of Control (Loop and Conditional statement)

3. 140+ MCQ on Introduction to Python

4. 120 MCQ on String in Python

5. 100+ MCQ on List in Python

6. 50+ MCQ on Tuple in Python

7. 100+ MCQ on Flow of Control in Python

8. 60+ MCQ on Dictionary in Python

## 70 Practice Questions on if-else

Computer Science Syllabus 2021-2022.

Informatics Practices Syllabus 2021-2022

Class 12 Computer Science Chapter wise MCQ

Share with others
error: Content is protected !!