CBSE Class 12 Informatics Practices Question Paper 2005 (Set 90)

CBSE CLASS XII Questions

• 1.

  Consider the following tables:

  Table 1: TEACHER, which stores Teacher ID (TID), Teacher Name (TName), Experience(Experience) and City (City) that they live in.

  TID	TName	Experience	City
  1	Kartik	5	Bhopal
  2	Shahnaz	6	Nagpur
  3	Rajendra	7	Delhi
  4	Tanvi	4	Bhopal
  5	Alam	9	Delhi

  Table 2: SUBJECT, which stores Subject ID (SID), Subject Name (SubName) and ID of the teacher (TID) teaching that Subject.

  SID	SubName	TID
  101	Physics	1
  102	Chemistry	2
  103	Mathematics	3
  104	Informatics Practices	4
  105	Computer Science	5

  Write appropriate SQL query for the following:

  (I) Delete the record of the subject whose TID is equal to 4.

  (II) Display the names of teachers who have more than 5 years of experience and who stay in Nagpur.

  (III) Display subject names along with their teacher names.

  View Solution

  ---

• 2.

  A CSV file named customer.csv contains records of customers. The first row of the file represents the header. Sample data from the file is shown below:

  Name, Age, City
  Rudra,17,Kolkata
  Divya,19,Dehradun
  Nabeel,22,Lucknow

  Write a Python program to import data from the CSV file into a Pandas DataFrame named DF and display the last two rows.

  View Solution

  ---

• 3.

  Write suitable SQL query for the following:

  I. To display only the date part from the date/time expression '2026-01-01 10:10:10'

  II. To convert all customer names from the Cust_Name column to lowercase in the Customer table.

  III. To extract the first 4 characters from the City_Name column in Location table.

  IV. To display the name of the city from the CITY column in EVENT table, after removing leading spaces.

  V. To find the average salary from Salary column in Employees table.

  View Solution

  ---

• 4.

  Consider the following table and write the output of the following SQL Queries.

  Table : ORDERS

  ORDERID	CUSTOMERNAME	TOTALAMOUNT	DISCOUNT	ORDERDATE
  101	Hemant	5000	10	2024–03-01
  102	Neha	7000	15	NULL
  103	Keshav	3000	5	2024–01-20
  104	Sandhya	4500	NULL	2023-12-25

  Write the output of the following SQL Queries:

  I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS NOT NULL;

  II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE DISCOUNT BETWEEN 5 AND 10;

  III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE ORDERDATE IS NOT NULL;

  IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;

  View Solution

  ---

• 5.

  (i) Write an SQL statement to create a table named PRODUCTS with the following specifications:

  Column Name	Data Type	Key
  PID	Integer	Primary Key
  PName	Varchar of size 30
  PCat	Char of size 15
  Price	Decimal Number

  (ii) Write an SQL query to increase the price of all items by 100, whose product category is Grocery, in the table PRODUCTS.

  View Solution

  ---

• 6.

  Consider the table LIBRARY as given below.

  BookId	Title	Genre	Price
  101	Python Basics	Technology	278
  201	The Silent Patient	Fiction	340
  301	Data Science	Technology	291
  401	Oceans	Marine Life	NULL

  (I) Which attribute(s) can be considered as the Candidate keys(s)? Justify your answer.

  (II) Write an SQL query to insert a new record with the following values: BookId: 501, Title: AI for ALL, Genre: Technology, Price: 589

  (III) Write an SQL query to add a new column Author that is a character data type of size 20.

  View Solution