CBSE Class 12 Computer Science Question Paper 2006 (Set 2)

CBSE CLASS XII Questions

• 1.

  What possible output from the given options is expected to be displayed when the following code is executed?
  

  import random
  Cards = ["Heart", "Spade", "Club", "Diamond"]
  for i in range(2):
      print(Cards[random.randint(1, i+2)], end="#")
  

  • Spade#Diamond#
    
  • Spade#Heart#
    
  • Diamond#Club#
    
  • Heart#Spade#
    
  View Solution

  ---

• 2.

  A CSV file "P_record.csv" contains the records of patients in a hospital. Each record of the file contains the following data:
  - Name of a patient
  - Disease
  - Number of days patient is admitted
  - Amount
  
  For example, a sample record of the file may be:
  ["Gunjan", "Jaundice", 4, 15000]
  
  Write the following Python functions to perform the specified operations on this file:
  
  (i) Write a function read_data() which reads all the data from the file and displays the details of all the 'Cancer' patients.
  
  (ii) Write a function count_rec() which counts and returns the number of records in the file.
  

  View Solution

  ---

• 3.

  Write a function Delete_Theatre() to input the value of Th_ID from the user and permanently delete the corresponding record from the THEATRE table in the CINEMA database.
  
  Given:
  Host: localhost, User: root, Password: Ex2025
  

  View Solution

  ---

• 4.

  A file PASSENGERS.DAT stores the records of passengers using the following structure:
  PNR, PName, BRDSTN, DESTN, FARE
  
  Where:
  - PNR — Passenger Number (string type)
  - PName — Passenger Name (string type)
  - BRDSTN — Boarding Station Name (string type)
  - DESTN — Destination Station Name (string type)
  - FARE — Fare amount for the journey (float type)
  
  Write user-defined functions in Python for the following tasks:
  
  (i) Create() – to input data for passengers and write it in the binary file PASSENGERS.DAT.
  (ii) SearchDestn(D) – to read contents from the file PASSENGERS.DAT and display the details of those Passengers whose DESTN matches with the value of D.
  (iii) UpdateFare() – to increase the fare of all passengers by 5% and rewrite the updated records into the file PASSENGERS.DAT.
  

  View Solution

  ---

• 5.

  A stack, named ClrStack, contains records of some colors. Each record is represented as a tuple containing four elements — ColorName, RED, GREEN, BLUE. ColorName is a string, and RED, GREEN, BLUE are integers. For example, a record in the stack may be ('Yellow', 237, 250, 68).
  
  Write the following user-defined functions in Python to perform the specified operations on ClrStack:
  
  (i) push_Clr(ClrStack, new_Clr): This function takes the stack ClrStack and a new record new_Clr as arguments and pushes this new record onto the stack.
  
  (ii) pop_Clr(ClrStack): This function pops the topmost record from the stack and returns it. If the stack is already empty, the function should display the message "Underflow".
  
  (iii) isEmpty(ClrStack): This function checks whether the stack is empty. If the stack is empty, the function should return True, otherwise the function should return False.
  

  View Solution

  ---

• 6.

  Expand and explain the term URL.
  

  View Solution