Skip to content
← 2019

Informatics Practices · 2019 · Set 90/1/1

CBSE Class 12 Informatics Practices 2019 — Set 90/1/1

CBSE Class XII Board 2019 · Set 90/1/1

Real board examination⚠ Old pattern · pre-2020 syllabus

This paper has 6 questions on a topic removed in CBSE’s 2023-24 syllabus update (each marked Not in syllabus). It’s kept for historical accuracy — the exam really asked it that year — but isn’t in the current syllabus and doesn’t count toward a concept’s importance. Switch to to focus on what’s still examinable.

About this paper

The real Class-12 board examination held in 2019. Every question below is solved the concept-first way. Sample papers are labelled honestly — never shown as a past exam.

Total marks
—
Questions
—
Duration
—
Sections
—

The marks / questions / duration above are the official exam pattern. We currently have 29 of this paper’s questions, with 29 fully solved. Questions we couldn’t yet extract or verify are held — never shown as complete.

The question paper

The questions we hold for this paper, laid out by section. Solutions are on the Answers tab.

Board Examination

Informatics Practices

CBSE Class XII Board 2019 · Set 90/1/1

Series/Set: 90/1/1Roll No. ________
Time Allowed: —Maximum Marks: —
Section A

Q1.
In CHAR(10) and VARCHAR(10), what does the number 10 indicate ?
[1]
Q2.
‘Employee’ table has a column named ‘CITY’ that stores city in which each employee resides. Write SQL query to display details of all rows except those rows that have CITY as ‘DELHI’ or ‘MUMBAI’ or ‘CHANDIGARH’.
[1]
Q3.

Consider the following table ‘Transporter’ that stores the order details about items to be transported.

Table : TRANSPORTER

ORDERNODRIVERNAMEDRIVERGRADEITEMTRAVELDATEDESTINATION
10012RAM YADAVATELEVISION2019-04-19MUMBAI
10014SOMNATH SINGHFURNITURE2019-01-12PUNE
10016MOHAN VERMABWASHING MACHINE2019-06-06LUCKNOW
10018RISHI SINGHAREFRIGERATOR2019-04-07MUMBAI
10019RADHE MOHANTELEVISION2019-05-30UDAIPUR
10020BISHEN PRATAPBREFRIGERATOR2019-05-02MUMBAI
10021RAMTELEVISION2019-05-03PUNE

Write SQL command for the following statement : (i) To display names of drivers and destination city where TELEVISION is being transported.

[1]
Q4.

Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER

ORDERNODRIVERNAMEDRIVERGRADEITEMTRAVELDATEDESTINATION
10012RAM YADAVATELEVISION2019-04-19MUMBAI
10014SOMNATH SINGHFURNITURE2019-01-12PUNE
10016MOHAN VERMABWASHING MACHINE2019-06-06LUCKNOW
10018RISHI SINGHAREFRIGERATOR2019-04-07MUMBAI
10019RADHE MOHANTELEVISION2019-05-30UDAIPUR
10020BISHEN PRATAPBREFRIGERATOR2019-05-02MUMBAI
10021RAMTELEVISION2019-05-03PUNE

Write SQL command for the following statement : (ii) To display driver names and destinations where destination is not MUMBAI.

[1]
Page 1 of 5
Q5.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write SQL command for the following statement : (iii) To display the names of destination cities where items are being transported. There should be no duplicate values.
[1]
Q6.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write SQL command for the following statement : (iv) To display details of rows that have some value in DRIVERGRADE column.
[1]
Q7.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write SQL command for the following statement : (v) To display names of drivers, names of items and travel dates for those items that are being transported on or before 1st April 2019.
[1]
Q8.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write SQL command for the following statement : (vi) To display the number of drivers who have ‘MOHAN’ anywhere in their names.
[1]
Q9.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write SQL command for the following statement : (vii) To display the names of drivers, item names and travel dates in alphabetic (ascending) order of driver names.
[1]
Q10.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write SQL command for the following statement : (viii) To display names of drivers whose names are three characters long.
[1]
Q11.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write the output for the following SQL query : (ix) SELECT ITEM, COUNT(*) FROM TRANSPORTER GROUP BY ITEM HAVING COUNT(*) >1;
[1]
Page 2 of 5
Q12.
Consider the following table ‘Transporter’ that stores the order details about items to be transported. Table : TRANSPORTER | ORDERNO | DRIVERNAME | DRIVERGRADE | ITEM | TRAVELDATE | DESTINATION | | --- | --- | --- | --- | --- | --- | | 10012 | RAM YADAV | A | TELEVISION | 2019-04-19 | MUMBAI | | 10014 | SOMNATH SINGH | | FURNITURE | 2019-01-12 | PUNE | | 10016 | MOHAN VERMA | B | WASHING MACHINE | 2019-06-06 | LUCKNOW | | 10018 | RISHI SINGH | A | REFRIGERATOR | 2019-04-07 | MUMBAI | | 10019 | RADHE MOHAN | | TELEVISION | 2019-05-30 | UDAIPUR | | 10020 | BISHEN PRATAP | B | REFRIGERATOR | 2019-05-02 | MUMBAI | | 10021 | RAM | | TELEVISION | 2019-05-03 | PUNE | Write the output for the following SQL query : (x) SELECT MAX(TRAVELDATE) FROM TRANSPORTER WHERE DRIVERGRADE = ‘A’;
[1]
Q13.
Write 2 precautions to be followed while doing Online shopping.
⚠ This question is not in the current syllabus — Old Java+MySQL IP syllabus — online-shopping precautions are not a named CBSE IP 065 topic.
[1]
Section B

Q1.
Write the functions of the following pieces of network hardware : (i) Modem (ii) Switch
[2]
Q2.
Write two ways used to make sure that the data is secure and is available only to the intended and authorized persons in a network.
⚠ This question is not in the current syllabus — Old Java+MySQL IP syllabus — network security is not in the current CBSE IP 065 syllabus.
[2]
Q3.
Expand TCP/IP. Write the purpose of TCP/IP in communication of data on a network.
⚠ This question is not in the current syllabus — Old Java+MySQL IP syllabus — protocols (TCP/IP) are not in the current CBSE IP 065 syllabus.
[2]
Q4.
Expand the following terms : (i) MAC Address (ii) ODF
⚠ This question is not in the current syllabus — Old Java+MySQL IP syllabus — ODF is not in the current CBSE IP 065 syllabus (MAC address is).
[2]
Q5.
Explain in brief any one freedom offered by Open Source Software. Write one example for each of the following : (i) An Open Source Operating System (ii) An Open Source Office Suite
[2]
Q6.
The following HTML code has error(s). Rewrite the correct code underlining corrections made. <ol type="A" begin="4"> <li>List item 1</li> <li>List item 2</li> <li>List item 3</li> <end> OR Expand XML. For what purpose is XML used ?
⚠ This question is not in the current syllabus — Old Java+MySQL IP syllabus — HTML/XML are not in the current CBSE IP 065 syllabus.
[2]
Page 3 of 5
Q7.
Consider the following table : Table : RESULTS | STUDENTID | NAME | EXAMID | SCORE | | --- | --- | --- | --- | | 10 | Leena | 1 | 20 | | 10 | Leena | 2 | 25 | | 11 | Samarth | 1 | 30 | | 11 | Samarth | 2 | 35 | | 12 | Jai | 1 | 14 | | 12 | Jai | 2 | 15 | | 14 | Shoaib | 1 | 30 | | 14 | Shoaib | 2 | 12 | Abhay wants to know the number of students who took the test. He writes the following SQL statement to count STUDENTID without duplicates. However the statement is not correct. Rewrite the correct statement. SELECT DISTINCT(COUNT STUDENTID) FROM RESULTS;
[2]
Q8.
Aman has used the following SQL command to create a table ‘stu’ : CREATE TABLE stu ( id INTEGER, name VARCHAR(100) ); Then, Aman enters the following SQL statements to enter 4 rows : INSERT INTO stu VALUES (1, "abc"); INSERT INTO stu VALUES (2, "abc"); INSERT INTO stu VALUES (3, "bcd"); Write the output that will be produced by the following SQL statement : SELECT name, Count(*) FROM stu GROUP BY name;
[2]
Q9.
Write SQL statement to add a column “COUNTRY” with data type and size as VARCHAR(70) to the existing table named “PLAYER”. Is it a DDL or DML or TCL command ?
[2]
Q10.
Table Student has the columns RNO and SCORE. It has 3 rows in it. Following two SQL statements were entered that produced the output (AVG(SCORE) as 45 and COUNT(SCORE) as 2) : (i) AVG(SCORE) (ii) COUNT(SCORE) Data in SCORE column is same in two rows. What data is present in the SCORE column in the three rows ?
[2]
Q11.
Mr. Sen has to create a table named ‘Employee’ with Columns to store EmpID, Name, Designation, Age and Salary. EmpID is the Primary key and Name cannot be NULL. Some of the rows that will be inserted are shown below. | 101 | Smita Kumar | Secretary | 28 | 39500.00 | | --- | --- | --- | --- | --- | | 102 | Mani Scott | Programmer | 32 | 45300.00 | | 103 | Firdaus Ali | Programmer II | 45 | 67500.00 | Write SQL query to create the above table with appropriate data types and sizes of columns. OR Ms. Rajshri is the Class Teacher of Class XII. She wants to create a table named ‘Student’ to store marks in different subjects of her class. Identify any 4 columns for the table along with their suitable data types.
[2]
Q12.
Consider the following tables PARTICIPANT and ACTIVITY and answer the questions that follow : Table : PARTICIPANT | ADMNO | NAME | HOUSE | ACTIVITYCODE | | --- | --- | --- | --- | | 6473 | Kapil Shah | Gandhi | A105 | | 7134 | Joy Mathew | Bose | A101 | | 8786 | Saba Arora | Gandhi | A102 | | 6477 | Kapil Shah | Bose | A101 | | 7658 | Faizal Ahmed | Bhagat | A104 | Table : ACTIVITY | ACTIVITYCODE | ACTIVITYNAME | POINTS | | --- | --- | --- | | A101 | Running | 200 | | A102 | Hopping bag | 300 | | A103 | Skipping | 200 | | A104 | Bean bag | 250 | | A105 | Obstacle | 350 | When the table “PARTICIPANT” was first created, the column ‘NAME’ was planned as the Primary key by the Programmer. Later a field ADMNO had to be set up as Primary key. Explain the reason. OR Identify data type and size to be used for column ACTIVITYCODE in table ACTIVITY.
[2]
Page 4 of 5
Q13.
Consider the following tables PARTICIPANT and ACTIVITY : Table : PARTICIPANT | ADMNO | NAME | HOUSE | ACTIVITYCODE | | --- | --- | --- | --- | | 6473 | Kapil Shah | Gandhi | A105 | | 7134 | Joy Mathew | Bose | A101 | | 8786 | Saba Arora | Gandhi | A102 | | 6477 | Kapil Shah | Bose | A101 | | 7658 | Faizal Ahmed | Bhagat | A104 | Table : ACTIVITY | ACTIVITYCODE | ACTIVITYNAME | POINTS | | --- | --- | --- | | A101 | Running | 200 | | A102 | Hopping bag | 300 | | A103 | Skipping | 200 | | A104 | Bean bag | 250 | | A105 | Obstacle | 350 | Write command in SQL for the following : (i) To display Activity Code along with number of participants participating in each activity (Activity Code wise) from the table Participant. OR How many rows will be there in Cartesian product of the two tables in consideration here ?
[2]
Q14.
Consider the following tables PARTICIPANT and ACTIVITY : Table : PARTICIPANT | ADMNO | NAME | HOUSE | ACTIVITYCODE | | --- | --- | --- | --- | | 6473 | Kapil Shah | Gandhi | A105 | | 7134 | Joy Mathew | Bose | A101 | | 8786 | Saba Arora | Gandhi | A102 | | 6477 | Kapil Shah | Bose | A101 | | 7658 | Faizal Ahmed | Bhagat | A104 | Table : ACTIVITY | ACTIVITYCODE | ACTIVITYNAME | POINTS | | --- | --- | --- | | A101 | Running | 200 | | A102 | Hopping bag | 300 | | A103 | Skipping | 200 | | A104 | Bean bag | 250 | | A105 | Obstacle | 350 | Write command in SQL for the following : (ii) To display Names of Participants, Activity Code, Activity Name in alphabetic ascending order of names of participants.
[2]
Q15.
Consider the following tables PARTICIPANT and ACTIVITY : Table : PARTICIPANT | ADMNO | NAME | HOUSE | ACTIVITYCODE | | --- | --- | --- | --- | | 6473 | Kapil Shah | Gandhi | A105 | | 7134 | Joy Mathew | Bose | A101 | | 8786 | Saba Arora | Gandhi | A102 | | 6477 | Kapil Shah | Bose | A101 | | 7658 | Faizal Ahmed | Bhagat | A104 | Table : ACTIVITY | ACTIVITYCODE | ACTIVITYNAME | POINTS | | --- | --- | --- | | A101 | Running | 200 | | A102 | Hopping bag | 300 | | A103 | Skipping | 200 | | A104 | Bean bag | 250 | | A105 | Obstacle | 350 | Write command in SQL for the following : (iii) To display Names of Participants along with Activity Codes and Activity Names for only those participants who are taking part in Activities that have ‘bag’ in their Activity Names and Points of activity are above 250.
[2]
Q16.
How does e-governance help in increasing Accountability (answerability of the Government to the people) ? Write 2 points.
⚠ This question is not in the current syllabus — Old Java+MySQL IP syllabus — e-governance is not in the current CBSE IP 065 syllabus.
[2]
Page 5 of 5