CBSE Class 12 Computer Science Question Paper 2008 (Set 91)

CBSE CLASS XII Questions

• 1.

  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

  ---

• 2.

  The code given below accepts N as an integer argument and returns the sum of all integers from 1 to N. Observe the following code carefully and rewrite it after removing all syntax and logical errors. Underline all the corrections made.
  
  

  def Sum(N):
      S = 0
      for I in range(1, N + 1):
          S = S + I
      return S
  
  print(Sum(10))
  

  View Solution

  ---

• 3.

  Expand and explain the term URL.
  

  View Solution

  ---

• 4.

  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

  ---

• 5.

  Nisha is assigned the task of maintaining the staff data of an organization. She has to store the details of the staff in the SQL table named EMPLOYEES with attributes as EMPNO, NAME, DEPARTMENT, BASICSAL to store Employee’s Identification Number, Name, Department, and Basic Salary respectively. There can be two or more Employees with the same name in the organization.
  (i)
  (a) Help Nisha to identify the attribute which should be designated as the PRIMARY KEY. Justify your answer.
  OR
  (b) Help Nisha to identify the constraint which should be applied to the attribute NAME such that the Employees’ Names cannot be left empty or NULL while entering the records but can have duplicate values.
  (ii)
  (a) Write the SQL command to change the size of the attribute BASICSAL in the table EMPLOYEES to allow the maximum value of 99999.99 to be stored in it.
  OR
  (b) Write the SQL command to delete the table EMPLOYEES.
  

  View Solution

  ---

• 6.

  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