This is the Class 12 CBSE Final Term Computer Science Question Bank. The students’ challenges are met through a set of questions and answers that cut across all topics. The questions are divided into sections including multiple choice, very short answer, short answer and long answer questions so as to enhance the revision. Detailed answers are interspersed in any patient section that can be disclosed. Use this question bank for revising the concepts, practicing important questions or preparing for the final examination.
Note: These questions are based on the latest syllabus updates and include previous year questions for reference. Ensure to review the solved examples provided to grasp complex topics with ease.
Section A
- “Stack is a linear data structure which follows a particular order in which the operations are performed.”
What is the order in which the operations are performed in a Stack?
Name the list method available in Python used to remove the last element from a list-implemented stack.Write an example using Python for removing the last element of a list:
stack = [1, 2, 3, 4] stack.pop() # Removes the last element (4) - (i) Expand the following:
VoIP
PPP
(ii) Riya uses Bluetooth to transfer pictures from her phone to her laptop. Which network type (PAN/LAN/MAN/WAN) will be formed? - Differentiate between Attribute and Domain in a Relational Data Model.
- Consider the following SQL table MEMBER:
M_ID NAME ACTIVITY M1001 Amina GYM M1002 Pratik GYM M1003 Simon SWIMMING M1004 Rakesh GYM M1005 Avneet SWIMMING Predict the output of the following code:
MYCUR = DB.cursor() MYCUR.execute ("USE CLUB") MYCUR.execute ("SELECT * FROM MEMBER WHERE ACTIVITY = 'GYM'") R = MYCUR.fetchone() for i in range(2): R = MYCUR.fetchone() print(R[0], R[1], sep="#") - Write the output of SQL queries (a) to (d) based on the table VACCINATION_DATA:
VID Name Age Dose1 Dose2 City 101 Jenny 27 2021-12-25 2022-01-31 Delhi 102 Harjot 55 2021-07-14 2021-10-14 Mumbai 103 Srikanth 43 2021-04-18 2021-07-20 Delhi 104 Gazala 75 2021-07-31 NULL Kolkata 105 Shiksha 32 2022-01-01 NULL Mumbai - (a) SELECT Name, Age FROM VACCINATION_DATA WHERE Dose2 IS NOT NULL AND Age > 40;
- (b) SELECT City, COUNT(*) FROM VACCINATION_DATA GROUP BY City;
- (c) SELECT DISTINCT City FROM VACCINATION_DATA;
- (d) SELECT MAX(Dose1), MIN(Dose2) FROM VACCINATION_DATA;
- (a) SELECT Name, Age FROM VACCINATION_DATA WHERE Dose2 IS NOT NULL AND Age > 40;
Section B
- Write the definition of a user-defined function PushNV(N) that accepts a list of strings in the parameter N and pushes all strings with no vowels into a list named NoVowel.
Section C
- (i) A SQL table ITEMS contains columns INO, INAME, QUANTITY, PRICE, DISCOUNT.
Write the SQL command to remove the column DISCOUNT from the table. - (ii) Categorize the following SQL commands into DDL and DML:
CREATE, UPDATE, INSERT, DROP.
Section D
- (i) Differentiate between Bus Topology and Tree Topology. Write one advantage of each.
- (ii) What is a web browser? Write the names of any two commonly used web browsers.
Disclaimer
The question bank provided on this website is meant to be a supplementary resource for final term exam preparation. While we strive to offer accurate and relevant content, students should not rely solely on these answers. It is essential to conduct further research and consult teachers, school authorities, or subject experts to ensure thorough understanding and preparation. The solutions here are based on general interpretations and may not reflect the exact responses expected by examination boards. We are not responsible for any discrepancies or outcomes in exams resulting from the use of this material. By using this resource, you acknowledge that your academic success depends on comprehensive preparation, including active engagement with school materials and guidance from educators.
