CBSE Class 12 Bengali Question Paper 2025

CBSE CLASS XII Questions

• 1.

  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

  ---

• 2.

  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

  ---

• 3.

  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

  ---

• 4.

  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

  ---

• 5.

  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

  ---

• 6.

  Differentiate between add-ons and plug-ins in a web browser.

  View Solution