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

CBSE CLASS XII Questions

• 1.

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

  View Solution

  ---

• 2.

  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:

  ---

• 3.

  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

  ---

• 4.

  (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

  ---

• 5.

  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

  ---

• 6.

  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