CBSE Class 12 Computer Science Question Paper 2010 (Set 91/1 (Outside Delhi))

CBSE CLASS XII Questions

• 1.

  Assume that you are working in the IT Department of a Creative Art Gallery (CAG), which sells different forms of art creations like Paintings, Sculptures etc. The data of Art Creations and Artists are kept in tables Articles and Artists respectively. Following are few records from these two tables:
  
  (i) To display all the records from the Articles table in descending order of Price.
  (ii) To display the details of Articles which were created in the year 2020.
  (iii) To display the structure of the Artists table.
  (iv-a) To display the name of all artists whose Article is Painting using Equi Join.
  (iv-b) To display the name of all artists whose Article is 'Painting' using Natural Join

  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 Python function that displays all the words starting and ending with a vowel from a text file "Report.txt".
  The consecutive words should be separated by a space in the output.
  For example, if the file contains:
  Once there was a wise man in a village.
  He was an awesome story-teller.
  He was able to keep people anchored while listening to him.
  Then the output should be:
  Once a a awesome able
  

  View Solution

  ---

• 4.

  Predict the output of the following code:
  
  

  def ExamOn(mystr):
      newstr = ""
      count = 0
      for i in mystr:
          if count % 2 != 0:
              newstr = newstr + str(count - 1)
          else:
              newstr = newstr + i.lower()
          count += 1
      newstr = newstr + mystr[:2]
      print("The new string is:", newstr)
  
  ExamOn("GenX")
  

  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.

  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