CBSE Class 12 Applied Mathematics Compartment Question Paper 2025

CBSE CLASS XII Questions

• 1.

  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

  ---

• 2.

  Mandeep received an email stating he won a lottery though he had never participated in any such event. He was asked to provide bank details to process the amount. Mandeep provided the required details but within next few minutes ₹ One lakh was debited from his account.

  Answer the following questions based on the given case study:

  (i) Mandeep is the victim of which type of cybercrime?

  (ii) Other than email, mention any two common methods through which this type of cybercrime is being committed these days.

  (iii) Name one law that safeguards the rights of Internet users in India.

  View Solution

  ---

• 3.

  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

  ---

• 4.

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

  View Solution

  ---

• 5.

  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

  ---

• 6.

  (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