CBSE Class 12 Horticulture Question Paper 2025

CBSE CLASS XII Questions

• 1.

  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

  ---

• 2.

  (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

  ---

• 3.

  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

  ---

• 4.

  Write the output of the following code:

  import pandas as pd
  s1 = pd.Series ([1, 2, 3], index = ['a','b','c'])
  s2 = pd.Series ([4, 5, 6], index = ['b','c','d'])
  print (s1 + S2)

  View Solution

  ---

• 5.

  (a) What is data protection?

  (b) Mention any two precautionary measures one can take to avoid the risk of cybercrime.

  View Solution

  ---

• 6.

  Shalini, who works as a database designer in the hotel industry, has created a table named Guest to keep track of guest details as shown below:

  Table : Guest

  GuestID	GuestName	RoomNumber	CheckInDate	Charges
  G101	Harish	101	2025-04-03	3000
  G102	Sunita	101	2025-04-03	3000
  G103	Ramesh	102	2025-05-04	5000
  G104	Bhumika	103	2025-06-02	3500

  Write a suitable SQL query for the following:

  I. Display last 3 characters of guest name in upper case.

  II. Display the name of the guest along with the day name of check-in date.

  III. Display the remainder when charges are divided by 1000.

  IV. Extract and display three characters, starting from the second character, of each guest name.

  View Solution