CBSE Class 12 IP 065 Board Question Paper 2017-18 with Solution

Preparing for the CBSE Class 12 Informatics Practices (065) Board Examination requires proper planning, regular practice, and a clear understanding of all concepts. Class 12 IP 065 Previous Year Question Papers (PYQs) and CBSE Class 12 IP 065 Sample Question Papers play an important role in exam preparation as they help students understand the examination pattern, marks distribution, and types of questions asked in the board examination. By solving previous year papers, students can identify important topics, improve their time management, increase accuracy, and gain confidence.

Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2017-18-with-Solution

To help students prepare effectively, we are providing the CBSE Class 12 Informatics Practices (065) Board Question Paper 2017-18 with Solutions. Students are advised to solve the complete question paper within the given examination time before checking the solutions. Regular practice of previous year question papers and sample papers, along with proper revision of the CBSE syllabus, can significantly improve examination performance. Remember, understanding concepts, practising regularly, and learning from mistakes are the keys to achieving excellent marks. Prepare smartly, practise consistently, and aim for full marks in your board examination!

CBSE Class 12 IP 065 Board Question Paper 2017-18 with Solution

Exam Date Mar 23, 2018
Series SGN
Question Paper Code 90 Set 4

INFORMATICS PRACTICES (065) - PYQP 2018
(Session 2017-18)

Time allowed : 3 hours
Maximum Marks : 70

General Instructions :
  1. All questions are compulsory.
  2. Answer the questions after carefully reading the text.
------

Q1. (a) ABC Company wants to link its computers in the Head office in New Delhi to its office in Sydney. Name the type of Network that will be formed. Which Communication media should be used to form this Network?
Ans: ABC Company will use a Wide Area Network (WAN) to connect its offices over large distances.
Wireless media such as microwave, radio waves, satellites, or infrared will be used for communication.

(b) Which of the following is/are not communication media?
I. Microwaves
II. Optical Fiber cable
III. Node
IV. Radio waves
Identify which of the above mentioned communication media are Wired media and which ones are Wireless media.
Ans: Node is not a communication media.
Wired media: Optical Fiber cable
Wireless media: Radio waves, Microwaves

(c) Write two examples each of software in the following categories:
(i) Open Source Operating System
Ans: Linux, Android, ReactOS etc.
(ii) Open Source Web Browser
Ans: Mozilla Firefox, Brave, Chromium, LibreWolf etc.

(d) Expand the following terms:
I. GSM - Global System for Mobile-Communication
II. IP - Internet Protocol

(e) Name the devices:
I. This device constantly looks at all the data entering and exiting your connection. It can block or reject data in response to an established rule.
Ans: Firewall
II. This device connects multiple n odes to form a network. It redirects the received information only to the intended node(s).
Ans: Switch

Q2. (a) Identify the invalid variable names. State the reason if invalid.
I. Marks Unit
II. Product_1
III. Sales123
IV. 2 Marks
Ans: I. Marks Unit
Reason: Invalid because variable names cannot contain spaces.
IV. 2 Marks
Reason: Invalid because a variable name cannot begin with a digit.

(b) Write the data type of variables that should be used to store:
I. Marks of students - float/double/long/int/byte/short
II. Grades of students (Grade can be ‘A’ or ‘B’ or ‘C’) - char

(c) Write examples of any two properties and any two methods of the jButton component.
Ans: Properties: (i) text - Sets or changes the text displayed on the button. (ii) background - Sets the background colour of the button.
Methods: (i) setText() - Changes the text displayed on the button. (ii) setEnabled() - Enables or disables the button.

(d) Write the purpose of HTML. Distinguish between <P> tag and <BR> tag.
Ans: HTML (HyperText Markup Language) is used to create and design web pages. It defines the structure and content of a web page using various tags.
Difference between <P> and <BR> tags:
<P> Tag: It is used to create a new paragraph. It is a container (paired) tag.
<BR> Tag: It is used to insert a single line break. It is an empty (unpaired) tag.

(e) Distinguish between ComboBox and ListBox. When would you prefer using them over the Radio button and Checkbox?
Ans: ComboBox displays options in a drop-down list.
ListBox displays multiple options in a visible list.
Combo box or List Box would be preferred over Radio button and Check box when the number of items are more.

(f) Rewrite the following code using switch statement:
if (code == ‘A’)
allowance = 3500;
else if (code ==’B’)
allowance= 3200;
else
allowance =2000; 2
Ans:
switch (code)
{
    case 'A':
        allowance = 3500;
        break;

    case 'B':
        allowance = 3200;
        break;

    default:
        allowance = 2000;
}

Q3. (a) What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software?
Ans: MySQL is a Relational Database Management System (RDBMS) used to store, manage, retrieve and manipulate data in the form of tables.
Abhay can download MySQL software from the official MySQL website: https://www.mysql.com/downloads

(b) In the table ‘‘Student’’, Priya wanted to increase the Marks (ColumnName: Marks) of those students by 5 who have got Marks below 33.
She has entered the following statement:
SELECT Marks+5 FROM Student WHERE Marks<33;
Identify errors (if any) in the above statement. Rewrite the correct SQL statement.
Ans: Use command UPDATE instead of SELECT.
Command: UPDATE Student SET Marks= Marks+5 WHERE Marks<33;

(c) I. Name the Data type that should be used to store AccountCodes like ‘‘A1001’’ of Customers. - char or varchar
II. Name two Data types that require data to be enclosed in quotes. - char, varchar, date

(d) Given the table ‘Player’ with the following columns:
Table: Player
PCODEPOINTS
150
2NULL
340
Write the output of the following statements:
I. SELECT AVG(POINTS) FROM Player;
Ans: 45
II. Select COUNT(POINTS) FROM Player;
Ans: 2

(e) Class’ table has columns RNO and NAME.
The following statements are executed:
SET AUTOCOMMIT = 0;
INSERT INTO CLASS VALUES(5,'Rajiv');
COMMIT;
UPDATE CLASS SET NAME='Rajeev' WHERE ID=5;
SAVEPOINT A;
INSERT INTO CLASS VALUES(6,'Chris');
SAVEPOINT B;
INSERT INTO CLASS VALUES(7,'Feroze');
SELECT * FROM CLASS;
ROLLBACK TO B;
SELECT * FROM CLASS;
What will be the output of both the above given SELECT statements?
Ans: Output of first SELECT statement is:
RNONAME
5Rajeev
6Chris
7Feroz
Output of first SELECT statement is:
RNONAME
5Rajeev
6Chris

(f) Name SQL Single Row functions (for each of the following) that
I. returns a number.
Ans: ROUND() - Returns a number.
II. returns lowercase letters.
Ans: LOWER() - Returns lowercase letters.
III. returns names of days. For example: ‘‘Monday’’, ‘‘Tuesday’’.
Ans: DAYNAME() - Returns the name of the day, such as Monday or Tuesday.
IV. returns weekday number. For example: 1 for Sunday, 2 for Monday, 3 for Tuesday.
Ans: DAYOFWEEK() - Returns the weekday number (1 for Sunday, 2 for Monday, and so on).

Q4. (a) Identify the error in the following code:
switch(c)
{
case 9.0 : a= a+2;
break;
case 8.0 : a=a+3;
break;
}
Ans: Error: The case labels contain decimal values (9.0 and 8.0), which are not allowed in a switch statement in C++.
Correction: Use integer values (9 and 8) instead of decimal values.
(b) What values will be displayed in JOptionPane when the following code is executed?
int a=5, b = 2;
while (a < 20)
{
a = a + b;
b = a - b;
JOptionPane.showMessageDialog(null,a);
}
Ans: Output: 7, 12, 19, 31
(c) Write the code given below using ‘for’ loop instead of ‘while’ loop:
int I = 1;
while(I <= 5)
{
if(i * i == 4)
jTextField1.setText(""+i);
I = i+1;
}
Ans:
for(int i = 1; i <= 5; i++)
{
    if(i * i == 4)
        jTextField1.setText("" + i);
}
(d) Write the value that will be stored in variable a after execution of the following code if:
I. The initial value of a is 8.
II. The initial value of a is 10.
int b = 9;
if (a > b)
a=a+5;
a=a+2;
Ans: When initial value of a = 8: then Final value of a = 10
When initial value of a = 10: then Final value of a = 17
(e) What will be the values of i and z after the following code is executed:
int i = 0;
int z = 10;
do
{
i = i+2;
z--;
}
while (i<10);
Ans: i=10, z=5
(f) Ms. Priya works as a programmer in ‘‘Avon Education’’ where she has designed a software to compute fee charges to be paid by the students. A screenshot of the same is shown below:

Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2017-18-with-Solution-Q-4

  • Name of the student is entered by the user.
  • Any one Course out of Pharmacy, Architecture and Arts & Design is chosen by the user.
  • If the student is eligible for Concession, the required checkbox is selected by the user.
Based on the course selected, Fee Per Quarter is displayed in the appropriate textfield according to the following criterion:
CourseFee Per Quarter
Pharmacy2000.00
Architecture2500.00
Arts & Design2300.00
  • If the student is eligible for Concession, a concession of 7% of Fee per quarter is calculated as the concession amount, otherwise concession amount is 0.
  • Fee to be paid is the Fee per quarter with the concession amount (if any) deducted from it.
Help Ms. Priya in writing the code to do the following:
I. When the ‘Calculate Charges’ button is clicked, ‘Fee per quarter’, ‘Concession Amount’, ‘Fee to be Paid’ should be calculated and displayed in the respective text fields.
II. When ‘CLEAR’ button is clicked, all the text fields, radio buttons and checkbox should be cleared
III. When the ‘Exit’ button is clicked; the application should close.
Ans:
double feeperquarter = 0.0, concession = 0.0, feetopay = 0.0;
if (jRadioButton1.isSelected())
    feeperquarter = 2000;
else if (jRadioButton2.isSelected())
    feeperquarter = 2500;
else if (jRadioButton3.isSelected())
    feeperquarter = 2300;
if (jCheckBox1.isSelected())
    concession = 0.07 * feeperquarter;
feetopay = feeperquarter - concession;
jTextField2.setText("" + feeperquarter);
jTextField3.setText("" + concession);
jTextField4.setText("" + feetopay);
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jRadioButton1.setSelected(false);
jRadioButton2.setSelected(false);
jRadioButton3.setSelected(false);
jCheckBox1.setSelected(false);
System.exit(0);

Q5. Consider the following table ‘Furniture’. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x).
FCODENAMEPRICEMANUFDATEWCODE
10023Coffee Table400019-DEC-2016W03
10001Dining Table2050012-JAN-2017W01
10012Sofa3500006-JUN-2016W02
10024Chair250007-APR-2017W03
10090Cabinet1800031-MAR-2015W02
I. To display FCODE, NAME and PRICE of items that have Price less than < 5,000.
Ans: SELECT FCODE, NAME, PRICE FROM Furniture WHERE PRICE <5000;
II. To display NAMES and PRICE of those Furniture Items that have 'table' anywhere in their names.
Ans: SELECT NAME, PRICE FROM Furniture WHERE NAME LIKE '%table%';
III. To display WCode of Furniture Items. There should be no duplicate values.
Ans: SELECT DISTINCT(WCODE) FROM Furniture;
IV. To display the NAMES and PRICE increased by 500.00 of all the furniture items. (Price should only be displayed as increased; there should be no increase in the data in the table)
Ans: SELECT NAME, PRICE+500 FROM Furniture;
V. To display FCODE, NAME of each furniture item in descending order of FCODE.
Ans: SELECT FCODE, NAME FROM Furniture ORDER BY FCODE DESC;
VI. To display the details of all the Furniture Items which have Manufacturing date (MANUFDATE) between 01-JAN-2016 and 15-JUN-2017 (inclusive of both the dates).
Ans: SELECT * FROM FURNITURE WHERE MANUFDATE BETWEEN ’2016-01-01’ AND ’2017-06-15’;
VII. To display the average PRICE of all the Furniture Items, which are made of Wood with WCODE as W02.
Ans: SELECT AVG(PRICE) FROM Furniture WHERE WCODE = 'W02';
VIII. To display WCODE wise, WCODE and the highest price of Furniture Items.
Ans: SELECT WCODE, MAX(PRICE) FROM Furniture GROUP BY WCODE;
IX. SELECT SUM(PRICE) FROM Furniture WHERE WCODE='W03';
Ans: 
SUM (PRICE)
6500
X. SELECT COUNT(DISTINCT PRICE) FROM Furniture;
Ans:
COUNT (DISTINCT PRICE)
5

Q6. (a) Write SQL query to create a table ‘Inventory’ with the following structure:
FieldTypeConstraint
MaterialIDIntegerPrimary Key
MaterialVarchar (50)NOT NULL
CategoryChar
DatePurchaseDate
Ans: CREATE TABLE Inventory (MaterialID INT PRIMARY KEY, Material VARCHAR(50) NOT NULL, Category CHAR, DatePurchase DATE);
(b) Consider the following tables PATIENT and TEST and answer the questions that follow:
Table: PATIENT
PCODENAMEPHONEDTADMITTESTID
6473Amit Sharma91235689919-JUN-2017T102
7134Rose Mathew88674453612-NOV-2017T101
8786Tina Sharma Arora88908876506-DEC-2017T102
6477Vijay Shah71456744507-DEC-2017T502
7658Venkat Fazal86554534331-DEC-2017T101
Note: NAME holds the Names of patients.
DTADMIT holds Dates on which a patient was admitted to hospital.
TESTID holds Ids of Medical tests done on patients.
Table: TEST
TESTIDTESTNAMECOST
T101Platelet Count200.00
T102Hemogram190.00
T301Malaria Detection350.00
T502Glucose Test150.00
Name the Primary keys in both the tables and foreign key in the ‘PATIENT’ table.
State the reason for your choice.
Ans: Primary key in (Table: PATIENT) - PCODE as it is unique for each row of table.
Primary key in (Table: TEST) - TESTID as it is unique for each row of table.
Foreign key in (Table: PATIENT) - TESTID as it links two tables and is also Primary key in the table TEST.
(c) With reference to the above given tables (in Q6 b), write commands in SQL for (i) to (iii).
I. To display Names of Patients, TESTID and Test names for those Patients who were admitted between ‘01-DEC-2017’ and ‘15-DEC-2017’ (both dates inclusive).
Ans: SELECT NAME, PATIENT.TESTID, TESTNAME
FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID
AND DTADMIT BETWEEN '01-DEC-2017' AND '15-DEC-2017';
II. To display Names of Patients, Test names and Cost of Test for those Patients who have “Sharma” in their names.
Ans: SELECT NAME, TESTNAME, COST
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID
AND NAME LIKE '%Sharma%';
III. To increase the cost of those tests in the table ‘‘TEST’’ by < 50.00 that have cost below < 200.00
Ans: UPDATE TEST
SET COST = COST + 50.00
WHERE COST < 200.00;
Q7. (a) How does e-governance help in building trust between the Government and citizens?
Ans: E-governance helps build trust between the Government and citizens in the following ways:
(i) Transparency: It makes government work and decisions clear to everyone.
(ii) Awareness: It provides information about new government policies and facilities.
(iii) Participation: It allows citizens to take part in government decisions.
(iv) Time Saving: It reduces waiting time and makes services faster.
(v) Reduces Corruption: It helps reduce bribery and unfair practices.
(b) How can e-learning help students learn at their own pace?
Ans: E-learning helps students learn at their own pace in the following ways:
(i) Students can access study materials as many times as they need.
(ii) Students can study anytime and from anywhere according to their convenience.
(c) Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls from ListBox, ComboBox, TextField, TextArea, RadioButton, CheckBox, Label and Command Button for the following entries:
S.No.Function
1To let the user enter NAME
2To let the user enter MOBILE NUMBER
3To let user choose one PROFESSION out of the categories : Teaching/Non-Teaching/ Research Scholar
4To allow the user to select facilities out of Gym, Yoga, Table Tennis, Aerobics and Badminton. More than one facility can be chosen.
Ans:
S.No.FunctionControls
1To let the user enter NAMETextField
2To let the user enter MOBILE NUMBERTextField
3To let user choose one PROFESSION out of the categories : Teaching/Non-Teaching/ Research ScholarRadioButton/ComboBox
4To allow the user to select facilities out of Gym, Yoga, Table Tennis, Aerobics and Badminton. More than one facility can be chosen.CheckBox/ListBox

Download Now - Class 12 IP 843 CBSE Board Previous Year Question Paper (PYQP) 2017-18 with Solution

download-class-12-ip-065-previous-year-cbse-board-qp-with-solution

Year wise Question Papers with Solution – Class 12 Informatics Practices (Code 065)

CBSE Class 12 IP 065 Board Question Paper 2026-27 with Solution

CBSE Class 12 IP 065 Board Question Paper 2025-26 with Solution

CBSE Class 12 IP 065 Board Question Paper 2024-25 with Solution

CBSE Class 12 IP 065 Board Question Paper 2023-24 with Solution

CBSE Class 12 IP 065 Board Question Paper 2022-23 with Solution

CBSE Class 12 IP 065 Board Question Paper 2021-22 (Term 2) with Solution

CBSE Class 12 IP 065 Board Question Paper 2021-22 (Term 1) with Solution

CBSE Class 12 IP 065 Board Question Paper 2019-20 with Solution

CBSE Class 12 IP 065 Board Question Paper 2018-19 with Solution

CBSE Class 12 IP 065 Board Question Paper 2017-18 with Solution

Post a Comment

Previous Post Next Post