CBSE Class 12 Informatics Practices Question Paper 2007 (Set 90/1)

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.

  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.

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

  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.

  Write a Python program to create and display a Pandas Series as shown below:

  July	31
  Aug	31
  Sept	30
  Oct	31

  The index labels are the names of the months – July, Aug, Sept, Oct.

  The corresponding scalar values are the number of days in these respective months – 31, 31, 30, 31.

  View Solution

  ---

• 6.

  My Solutions Pvt. Ltd. is a reputed software development and IT consulting firm. The company's head office is located in Mysuru, and it has a regional office in Chennai. The Mysuru office comprises four departments: Human Resources, Research, Design and Technical Support.

  The distances between these departments and between Mysuru and Chennai are as follows:

  Human Resources to Research	55 metres
  Human Resources to Design	75 metres
  Human Resources to Technical Support	140 metres
  Research to Design	40 metres
  Research to Technical Support	80 metres
  Design to Technical Support	60 metres
  Mysuru Office to Chennai Office	350 kilometres

  The number of computers in each department/office is as follows:

  Human Resources	30
  Research	80
  Design	50
  Technical Support	20
  Chennai Office	35

  As a network engineer, you have to propose solutions for various queries listed from I to V.

  I. Identify the most suitable department to install the main server in the Mysuru office. Justify your answer with a valid reason.

  II. Create a cable layout design to establish Wired network connectivity between the departments in the Mysuru Office.

  III. Suggest the appropriate network device to connect multiple computers within the Research department.

  IV. What type of network (LAN, MAN, WAN) would best connect the Mysuru and Chennai office?

  V. Which device should be used if the signal strength weakens while transmitting data between the Human Resources and Technical Support departments due to the long distance between them?

  View Solution