2022 CBSE Class 12 Computer Science Question Paper with Detailed Solutions

by Himanshu Garg

 

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

  1. “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?
    SHOW ANSWER
    Answer: The order is LIFO (Last In, First Out).
    Name the list method available in Python used to remove the last element from a list-implemented stack.
    SHOW ANSWER
    Answer: The pop() method.

    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)
            
  2. (i) Expand the following:
    VoIP
    PPP
    SHOW ANSWER
    Answer: VoIP: Voice over Internet Protocol, PPP: Point-to-Point Protocol
    (ii) Riya uses Bluetooth to transfer pictures from her phone to her laptop. Which network type (PAN/LAN/MAN/WAN) will be formed?
    SHOW ANSWER
    Answer: PAN (Personal Area Network).
  3. Differentiate between Attribute and Domain in a Relational Data Model.
    SHOW ANSWER
    Answer: Attribute: Column in a table representing a specific property. Domain: Set of allowable values for an attribute.
  4. Consider the following SQL table MEMBER:
    M_IDNAMEACTIVITY
    M1001AminaGYM
    M1002PratikGYM
    M1003SimonSWIMMING
    M1004RakeshGYM
    M1005AvneetSWIMMING

    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="#")
            
    SHOW ANSWER
    Answer: M1002#Pratik, M1004#Rakesh
  5. Write the output of SQL queries (a) to (d) based on the table VACCINATION_DATA:
    VIDNameAgeDose1Dose2City
    101Jenny272021-12-252022-01-31Delhi
    102Harjot552021-07-142021-10-14Mumbai
    103Srikanth432021-04-182021-07-20Delhi
    104Gazala752021-07-31NULLKolkata
    105Shiksha322022-01-01NULLMumbai
    1. (a) SELECT Name, Age FROM VACCINATION_DATA WHERE Dose2 IS NOT NULL AND Age > 40;
      SHOW ANSWER
      Answer: Harjot 55, Srikanth 43
    2. (b) SELECT City, COUNT(*) FROM VACCINATION_DATA GROUP BY City;
      SHOW ANSWER
      Answer: Delhi 2, Mumbai 2, Kolkata 1
    3. (c) SELECT DISTINCT City FROM VACCINATION_DATA;
      SHOW ANSWER
      Answer: Delhi, Mumbai, Kolkata
    4. (d) SELECT MAX(Dose1), MIN(Dose2) FROM VACCINATION_DATA;
      SHOW ANSWER
      Answer: MAX(Dose1): 2022-01-01, MIN(Dose2): 2022-01-31

Section B

  1. 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.
    SHOW ANSWER
    
    def PushNV(N):
        NoVowel = []
        for word in N:
            if not any(vowel in word for vowel in 'AEIOUaeiou'):
                NoVowel.append(word)
        return NoVowel
            

Section C

  1. (i) A SQL table ITEMS contains columns INO, INAME, QUANTITY, PRICE, DISCOUNT.
    Write the SQL command to remove the column DISCOUNT from the table.
    SHOW ANSWER
    ALTER TABLE ITEMS DROP COLUMN DISCOUNT;
  2. (ii) Categorize the following SQL commands into DDL and DML:
    CREATE, UPDATE, INSERT, DROP.
    SHOW ANSWER
    Answer: DDL: CREATE, DROP; DML: INSERT, UPDATE

Section D

  1. (i) Differentiate between Bus Topology and Tree Topology. Write one advantage of each.
    SHOW ANSWER
    Answer: Bus Topology: Easy to install. Tree Topology: Scalable and supports multiple device hierarchies.
  2. (ii) What is a web browser? Write the names of any two commonly used web browsers.
    SHOW ANSWER
    Answer: A web browser is an application used to access the internet. Examples: Google Chrome, Mozilla Firefox

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.

Leave a Reply

[script_15]

This site uses Akismet to reduce spam. Learn how your comment data is processed.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. OK Read More

Privacy & Cookies Policy
-
00:00
00:00
Update Required Flash plugin
-
00:00
00:00
✓ Customized M.Tech Projects | ✓ Thesis Writing | ✓ Research Paper Writing | ✓ Plagiarism Checking | ✓ Assignment Preparation | ✓ Electronics Projects | ✓ Computer Science | ✓ AI ML | ✓ NLP Projects | ✓ Arduino Projects | ✓ Matlab Projects | ✓ Python Projects | ✓ Software Projects | ✓ Readymade M.Tech Projects | ✓ Java Projects | ✓ Manufacturing Projects M.Tech | ✓ Aerospace Projects | ✓ AI Gaming Projects | ✓ Antenna Projects | ✓ Mechatronics Projects | ✓ Drone Projects | ✓ Mtech IoT Projects | ✓ MTech Project Source Codes | ✓ Deep Learning Projects | ✓ Structural Engineering Projects | ✓ Cloud Computing Mtech Projects | ✓ Cryptography Projects | ✓ Cyber Security | ✓ Data Engineering | ✓ Data Science | ✓ Embedded Projects | ✓ AWS Projects | ✓ Biomedical Engineering Projects | ✓ Robotics Projects | ✓ Capstone Projects | ✓ Image Processing Projects | ✓ Power System Projects | ✓ Electric Vehicle Projects | ✓ Energy Projects Mtech | ✓ Simulation Projects | ✓ Thermal Engineering Projects

© 2024 All Rights Reserved Engineer’s Planet

Digital Media Partner #magdigit