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

CBSE CLASS XII Questions

• 1.

  Peter has created a table named Account in MySQL database, SCHOOL, having following structure:

  Stud_id – integer
  Sname – string
  Class – string
  Fees – float

  Help him in writing a Python program to display records of those students whose fees is less than 5000.

  Note the following to establish connectivity between Python and MySQL: Username – admin, Password – root, Host – localhost

  View Solution

  ---

• 2.

  A csv file "States.csv" contains some data about all the states of India. Each record of the file contains the following data: Name of the State, Capital of the State, Population of the State, Official Language of the State.

  For example, a sample record in the file is:

  ['Andhra Pradesh','Amaravati',52221000,'Telugu']

  Write a Python program which reads the data from this file and appends all those records where population is more than 10000000 into another csv file 'More.csv'.

  Note: "States.csv" also contains the Header row. The Header row should NOT be copied to "More.csv".

  View Solution

  ---

• 3.

  Ms. Zoya is a Production Manager in a factory which packages mineral water. She decides to create a table in a database to keep track of the stock present in the factory. Each record of the table will have the following fields:

  W_Code – Code of the item (type – CHAR(5))
  W_Description – Description of the item (type – VARCHAR(20))
  B_Qty – Balance quantity of the item (type – INTEGER)
  U_Price – Unit Price of the item (type – FLOAT)

  The name of the table is W_STOCK.

  ---

• 4.

  List one advantage and one disadvantage of Bus topology.

  View Solution

  ---

• 5.

  Assuming that D1 is a dictionary in Python,

  ---

• 6.

  Write a Python program to accept 10 integers from the user. If the entered number is a three-digit even integer, push it onto a stack. After all inputs are taken, pop all the three-digit even integers from the stack and display them. For example, if the user enters 12, 31, 320, 457, 6, 92, 924, 220, 1, 218, then the stack should contain:

  320, 924, 220, 218

  and the output of the program should be:

  218 220 924 320

  View Solution