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

CBSE CLASS XII Questions

• 1.

  Assume that you are the Manager of the Loans department of a Finance House. To keep track of the loans you have created two tables: CUSTOMERS and LOANS. The sample data in these tables is given below:

  Table: CUSTOMERS

  C_ID	C_Name	Phone
  00001	Raj Malhotra	1234567890
  00003	David Xavier	3456789012
  00004	Damini Iyer	3156789012
  00008	Abdul	2345678901

  Table: LOANS

  SNo	C_ID	L_Amt	L_Date	Terms	RoI
  1	00003	200000	2025-12-06	60	7.80
  2	00008	2500000	2023-08-09	60	9.00
  3	00001	500000	2025-08-13	48	6.00
  4	00003	300000	2026-12-07	36	8.00
  5	00004	600000	2026-12-07	60	6.00

  Note: The tables may contain more records than shown here.

  The management of the Finance House needs certain reports from you. Write the queries to extract the following data to create the reports:

  ---

• 2.

  List one advantage and one disadvantage of Bus topology.

  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.

  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

  ---

• 5.

  What is protocol in the context of computer networks? Which protocol is used to transmit hypertext across the web?

  View Solution

  ---

• 6.

  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