CBSE Class 12 Informatics Practices Question Paper 2014 (Set-1)

CBSE CLASS XII Questions

• 1.

  Write suitable SQL query for the following:

  I. To display the value of 17².

  II. To display the day part of the dates in the Hire_Date column of the Employee table.

  III. To display the maximum value of the Bill_Amount column in the Bill table.

  IV. To remove leading and trailing spaces from the Location column in the Branch table.

  V. To display total salary from tot_sal column in Employees table.

  View Solution

  ---

• 2.

  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

  ---

• 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.

  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.

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

  View Solution

  ---

• 6.

  Consider the DataFrame Scholarship shown below:

  	Name	Course	Amount
  0	Ananya	B.Sc.	62000
  1	Karan	B.Tech	67000
  2	Simran	MCA	64000
  3	Rahul	BCA	70000
  4	Priya	BA	69000

  Answer the following questions: