CBSE Sample Papers for Class 12 Informatics Practices Paper 1

CBSE Sample Papers for Class 12 Informatics Practices Paper 1 are part of CBSE Sample Papers for Class 12 Informatics Practices. Here we have given CBSE Sample Papers for Class 12 Informatics Practices Paper 1.

CBSE Sample Papers for Class 12 Informatics Practices Paper 1

Students who are going to appear for CBSE Class 12 Examinations are advised to practice the CBSE sample papers given here which is designed as per the latest Syllabus and marking scheme, as prescribed by the CBSE, is given here. Paper 1 of Solved CBSE Sample Paper for Class 12 Informatics Practices is given below with free PDF download solutions.

Time : 3 hrs
Maximum Marks : 70

General Instructions

• All questions are compulsory.
• Answer the’questions after carefully reading the text.

QUESTIONS

Question 1.
(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?

(b) Which of the following is /are not communication media?

1. Microwaves
2. Optical Fiber cable
3. Node
4. Radio waves

Identify which of the above mentioned communication media are Wired media and which ones are Wireless media.

(c) Write two examples each of software in the following categories :

1. Open Source Operating System
2. Open Source Web Browser

(d) Expand the following terms :

1. GSM
2. IP

(e) Name the devices :

1. This device constanUy looks at all the data entering and exiting your connection. It can block or reject data in response to an established rule.
2. This device connects multiple nodes to form a network. It redirects the received information only to the intended node(s).

Question 2.
(a) Identify the invalid variable names. State the reason if invalid.

1. Marks Unit
2. Product_1
3. Sales_123
4. 2_Marks

(b) Write the data type of variables that should be used to store :

1. Marks of students
2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’)

(c) Write examples of any two properties and any two methods of j Button component

(d) Write the purpose of HTML. Distinguish between <P> tag and <BR> tag.

(e) Distinguish between ComboBox and ListBox. When would you prefer using them over Radiobutton and Checkbox?

(f) Rewrite the following code using switch statement :

if (code = = ‘A’)
allowance = 3500 ;
else if (code = = ‘B‘)
allowance = 3200 :
else
allowance = 2000 :

Question 3.
(a) What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software?
(b) In the table “Student”, Priya wanted to increase the Marks (Column Name: 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.

(c) (i) Name the data type that should be used to store AccountCodes liko “A1001” of Customers.
(iii) Name two data types that require data to be enclosed in quotes.

(d) Given the table ‘Player’ with the following columns :

Write the output of the following statements :

(i) SELECT AVG(POINTS)
FROM PIayer :
(ii) SELECT C0UNT(POINTS) FROM Player :

(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?

(f) Name SQL Single Row functions (for each of the following) that

1. returns a number.
2. returns lowercase letters.
3. returns names of days. For example: “Monday”, “Tuesday”.
4. returns weekday number. For example : 1 for Sunday, 2 for Monday, 3 for Tuesday.

Question 4.
(a) Identify the error in the following code :

switch (c)
{
case 9.0 : a = a + 2 ;
break ;
case 8.0 : a = a + 3 ;
break ;
}

(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) ;
}

(c) Write the code given below using ‘for’ loop instead of ‘while’ loop :

int i = 1 ;
while (i <= 5)
{
if (i *i = = 4)
jTextFieldl. setText
(" " + i) ;
i = i + 1 ;
}

(c) Write the code given below using ‘for’ loop instead of ‘while’ loop :

int i = 1 ;
while (i <= 5)
{
if (i *i = = 4)
jTextFieldl. setText
(" " +i) ;
i = i + 1 ;
}

(d) Write the value that will be stored in variable a after execution of the following code if :
(i) initial value of a is 8.
(ii) initial value of a is 10.

int b = 9 ;
if(a > b)
a = a + 5 ;
a = a + 2 ;

(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) ;

(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 :

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

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

1. When ‘Calculate Charges’ button is clicked, ‘Fee per quarter’, ‘Concession Amount’, ‘Fee to be Paid’ should be calculated and displayed in the respective text fields.
2. When ‘CLEAR’ button is clicked, all the textfields, radiobuttons and checkbox should be cleared.
3. When ‘Exit1 button is clicked, the application should close.

Question 5.
Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x).

(i) To display FCODE, NAME and PRICE of items that have Price less than ? 5,000

(ii) To display NAMES and PRICE of those Furniture Items that have table anywhere in their names.

(iii) To display WCode of Furniture Items. There should be no duplicate values.

(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)

(v) To display FCODE and NAME of each Furniture Item in descending order of FCODE.

(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).

(vii) To display the average PRICE of all the Furniture Items, which are made of Wood with WCODE as W02.

(viii) To display WCODE wise, WCODE and the highest price of Furniture Items.

(ix) SELECT SUM (PRICE) FROM Furniture WHERE WCODE = ‘W03’ ;
(x) SELECT COUNT (DISTINCT PRICE) FROM Furniture ;

Question 6.
(a) Write SQL query to create a table Inventory with the following structure :

(b) Consider the following tables PATIENT and TEST and answer the questions that follow :

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.

Name the Primary keys in both the tables and foreign key in ‘PATIENT’ table. State the reason for your choice.

(c) With reference to the above given table (in Q6 b), write commands in SQL for (i) to (iii)

1. 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).
2. To display names of Patients, Test names and Cost of Test for those patients who have ‘Sharma’ in their names.
3. To increase the cost of those tests in the table ‘TEST’ by ₹ 50.00 that have cost below ₹ 200.00

Question 7.
(a) How does E-governance help in building trust between the government and citizens?
(b) How can E-learning help students learn at their own pace?
(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, Text Area, RadioButton, CheckBox, Label and CommandButton for the following entries :

ANSWERS

Answer 1.
(a) ABC Company will formed the World Area Network (WAN) to link its computers in the Head office in New Delhi to its office in Sydney.
Unguided or wireless media should be used to form World Area Network.
(b) Node is not a communication media.
Microwaves and Radio waves are wireless communication media while Optical fiber cable is a wired communication media.
(c) (i) Open Source Operating System-Google Chrome OS, Linux
(ii) Open Source Web Browser – Google Chrome, Mozilla Firefox
(d) Expanded form :
(i) GSM – Global System for Mobile Communication
(ii) IP- Internet Protocol
(e) (i) Firewall is a device that looks at all the data entering and exiting connection. It can block or reject data in response to an established rule.
(ii) A switch is an intelligent device that connects several nodes to form a network and redirects the received information only to the intended node(s).

Answer 2.
(a) Marks Unit is an invalid variable name because variable name does not allow spacing.

(b) (i) int data type
(ii) char data type

(c) Two methods of jButton component: getText ( ), setText ( )
Two properties of jButton component: Font, Label

(d) HTML is used to represent page, data on website with proper manner and attractive look to get maximum users.
Difference between <P> tag and <BR> tag :
<P> tag is a block level element, and is mainly used to add content, whereas the <BR> tag is used to force a line break within the element.

(e) Differences between ComboBox and ListBox are as follows :

When you need to select multiple option then you would prefer using ListBox over CheckBox and when you need to select only one option then you would prefer using ComboBox over Radio Button.

(f) Given code using switch statement :

switch (code)
{
case A ;
allowance = 3500 ;
break ;
case B ;
allowance = 3200 ;
break ;
default ;
allowance = 2000 ;
break ;
}

Answer 3.
(a) MySQL is a Relational Database Management System (RDBMS), used for adding, accessing and processing data in a database.
Abhay can download the MySQL software setup from Internet.

(b) Correct SQL statement :

UPDATE Student SET Marks = Marks +5
WHERE Marks <33 ;

(c) (i) varchar data type should be used to store AccountCodes like ”A100111 of customers.
(ii) char and date data types require data to be enclosed in quotes.

(d) Output of the given statements

(e) Output for the 1st SELECT * FROM Class ; statement –

Output for the llnd SELECT * FROM Class; statement

(f) (i) ASCII () function returns a number.
(ii) LCASE () function returns lowercase letters .
(iii) DAYNAME () function returns names of days.
(iv) DAYOFWEEK () function returns weekday number.

Answer 4.
(a) default case is missing in the given switch code which is optional but necessary. When user gives a wrong choice then default case’s statement is executed.
(b) No value will be displayed in JOptionPane because it will give exception in thread ‘main’ due to null.
(c) The given code using ‘for’ loop instead of ‘while’ loop :

int i
for (i = 1 ; i < = 5 ; i + +)
{
if (1 * i = = 4)
jTextFieldl. setText ( “ “ + i) ;
}

(d) (i) Value of a = 10, if initial value of a
is 8
(ii) Value of a = 17, if initial value of a
is 10

(e) Value of i = 10
Value of z = 5

(f) Here,
Name is stored in jTextField1
Fee Per Quarter is stored in jTextField2
Concession Amount is stored in jTextField3
Fee to be Paid is stored in jTextField4

(i) We need to double click at the ‘Calculate Charges’ button (jButtonl) and type the following code ;

int Fee_per_quar,
concession_amount ;
float fee_tobe_paid ;
String name = jTextFieldl.
getText ( ) ;
if (jRadioButtonl. isSelected ( )
= =True)
Fee_per_quar = 2000 ;
else if (jRadioButton2.
isSelectedO == True)
Fee_per_quar = 2500 :
else if (jRadioButton3. is
Selected ( ) == True)
Fee_per_quar = 2300 ;
else
Fee, per_quar = 0 ;
jTextField2. setText
(Fee_per_quar) ;
if (jCheckBox. isSelected ( )
= =True)
concession_amount = (Fee__per_quar * 7) / 100 ;
else
concession_amount = 0 ;
JTextField3. setText
(concession_amount) ;
fee_tobe_paid = Fee_per_quar -
concession_amount ;
jTextField4. setText (fee_tobe_paid) ;

(ii) We need to double click at the ‘Clear’ button (jButton2) and type the following code :

jTextFieldl. setText (" ") ;
jTextField2. setText (" ") ;
jTextField3. setText (" ") ;
jTextField4. setText (" ") ;
jRadioButton1. setSelected (False) ;
jRadioButton2. setSelected (False);
jRadioButton3. setSelected (False) ;
jCheckBox. setSelected (False) ;

(iii) We need to double click at the ‘Exit’ button (jButton3) and type the following code:
System., exit (0) ;

Answer 5.
SQL commands for the given statements (i) to (viii) ;

1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;

2. SELECT NAME. PRICE FROM Furniture
   
   WHERE NAME LIKE %table% ;

3. SELECT DISTINCT WCODE FROM Furniture ;

4. SELECT NAME. PRICE +500 FROM Furniture ;

5. SELECT FCODE. NAME FROM Furniture ORDER BY FCODE DESC ;

6. SELECT * FROM Furniture
   
   WHERE MANUFDATE BETWEEN ‘01 - JAN - 2016' AND ‘15 - JUN - 2017' ;

7. SELECT AVG (PRICE) FROM Furniture
   
   WHERE WCODE = 'W02' ;

8. SELECT WCODE AS wise, WCODE, MAX (PRICE) FROM Furniture ;
   
   Output for SQL queries (ix) and (x)
   

Answer 6.

(a) CREATE TABLE Inventory
(
Material Id Integer Primary Key,
Material Varchar (50) NOT NULL,
Category Char,
DatePurchase Date
) :

(b) Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.

Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).

(c) SQL commands for the given statements :

(i) SELECT NAME, TESTID, TESTNAME
FROM PATIENT, TEST
WHERE PATIENT. TESTID = TEST. TESTID
AND DTADMIT BETWEEN ‘01-DEC-2017’ AND '15-DEC-2017' ;

(ii) SELECT NAME, TESTNAME, COST
FROM PATIENT, TEST
WHERE PATIENT. TESTID = TEST. TESTID
AND NAME LIKE '% Sharma %’ ;

(iii) UPDATE TEST SET COST = COST +50 WHERE COST < 200 ;

Answer 7.
(a) Building trust between governments and citizens is fundamental to good governance. ICT can help build trust by enabling citizen engagement in the policy process, promoting open and accountable government and helping to prevent corruption.
(b) E – learning allows students to learn at their own pace, meaning a teacher can help speed up the learning process or give more advanced resources if necessary.
(c) Appropriate controls for the given entries :

We hope the CBSE Sample Papers for Class 12 Informatics Practices Paper 1 help you. If you have any query regarding CBSE Sample Papers for Class 12 Informatics Practices Paper 1, drop a comment below and we will get back to you at the earliest.