Sample paper for class 12 Informatics Practices

Download CBSE sample paper for class 12 Informatics Practices from myCBSEguide. Sample paper for class 12 Informatics Practices for board exams are available for download in myCBSEguide app, the best app for CBSE students. Sample Paper for class 12 Informatics Practice includes questions from Informatic Practices, Published by CBSE. CBSE conducts board exam for CBSE students which will cover the whole book.

Download Complete set of sample paper for class 12 Informatics Practices

For study on the go download myCBSEguide app for android phones. Sample paper for class 12 Informatics Practices and other subjects are available for download as PDF in app too.

Informatics Practices Sample papers

Here is Sample paper for class 12 Informatics Practices. To get the answers and more sample papers, visit myCBSEguide App or website stated above.

Sample Paper for class 12 Informatics Practices
Session 2017-2018

---

1. (a) Mr. Ravi, an IT Help Desk executive needs to remotely login a customer’s PC to provide him technical support. Suggest a remote access software to him. (1)

(b) Identify the type of network (out of LAN/PAN/MAN/WAN) formed in the given diagram: (1)

(c) Identify the fastest wired media out of the following: Ethernet cable, Optical fiber, Co-axial cable (1)

(d) Mention any two main advantages of star topology over bus topology. (1)

(e) Discuss the significance of Bluetooth technology. (2)

(f) I. Write down any two advantages of Open Source Software over Proprietary software.

II. Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, she is denied of an access to the bank’s website, in spite of having a swift internet connection. What do you think the reason behind this problem is and suggest her few simple precautions in order to overcome any such type of network security threats. (4)

2 (a) I. Help Manish in identifying the incorrect variable name with justification from the following: (4)
i. unit@price; ii. fee; iii. userid; iv. avg marks;
II. Write Java code to declare a variable named Price of integer type. Assign a value 10 to this variable. Overwrite the value of price with its double value. Decrease the value of price by 5.

(b) Rewrite the following code using switch case: (2)

int day=Integer.parseInt(jTextField1.getText());

2if(day>=1 && day<=5)

jOptionPane1.showMessageDialog(this, “Working Day”);

else if(day>=6 && day<=7)

jOptionPane1.showMessageDialog(this, “Off Day”);

else

jOptionPane1.showMessageDialog(this, “Invalid Entry”);

(c) i. Ms. Sangeeta wants to add few descriptive lines in the HTML code which should not be displayed on the webpage rather should remain inactive during execution. Suggest her the solution along with example. (4)

ii. How HTML is different from XML? Mention any two point of difference.

3 (a) Mention any two example of common Database Management System. (1)

(b) Write the full forms of the following: (1)

i. DDL ii. DML

(c) Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between Alter and Update command with suitable example. (4)

Also suggest her suitable command for the following purpose:

i. To display the list of the database already existing in MySQL.

ii. To use the database named City.

iii. To remove the pre-existing database named Clients.

iv. To remove all the records of the table named “Club” at one go along with its structure permanently.

(d) Observe the given table named “Loan” carefully and predict the output of the following queries: (4)

Loan

File_no	Cust_Name	PhoneNo	Loan_Amt	Bank	Cheque_Dt
619095	Ms. Roshni	9899965430	809876	HBDC Ltd.	2017-06-15
234252	Mr. Rajesh	8654327890	745738	ICUCI Ltd.	2017-07-22
543613	Mrs. Sapna	8883546354	NULL	NBI Ltd.S	2017-07-24
435467	Mr. Navneet	9764747474	647484	ICUCI Ltd.	2017-08-13
263427	Ms. Puja	8746454742	546373	HBDC Ltd.	2017-08-30

i. select count(file_no)-count(loan_amt) from loan;

ii. select Cust_Name,Loan_Amt from loan where month(cheque_dt)=7;

iii. SELECT concat(left(file_no,2),right(cust_name,2)) AS “ID” from loan

where Bank=’ICUCI Ltd.’;

iv. select round(loan_amt-loan_amt*10/100) As “Discounted Payment” from

loan where loan_amt>700000;

4 (a) Write down the full forms of the following: (1)

i. URL ii. IDE

(b) Which property is to be used during design time to add a number of countries in the list box? (1)

(c) What will be the final value of variable x after the following code is executed: (1)

int x=10;

while(x>1)

{

x=x/3;

++x;

}

(d) i. Find the output of the following Java code snippet after execution of each java statement labelled as Line 1, Line 2, Line 3, Line 4: (4)

String userid=”INDIA”,pwd=””;

pwd=userid.substring(0,2); //Line 1

int l=userid.length(); //Line 2

pwd=pwd.toLowerCase(); //Line 3

pwd=pwd.concat(“”+l); //Line 4

ii. Rewrite the following code using for loop:

int attempt=0;

while(attempt<=3)

{

String login=jTextField1.getText();

String pwd=jTextField2.getText();

if(login.equals(“XII”) && pwd.equals(“IP”))

{

jOptionPane1.showMessageDialog(null, “Welcome”);

break;

}

else

jOptionPane1.showMessageDialog(null, “Pl try again”);

attempt++;

}

(e) The following code has error(s). Rewrite the correct code underlining all the corrections made: (2)

int start=2;end=20;

do;

{

start=start+start;

while(start<=end)

(f) Ms. Neelam works as a programmer in “Kidz Entertainment Zone”. She has designed a Registration Page to calculate the total fee of summer camp depending upon the number of activities selected by the user considering age eligibility as well. A screenshot of the same is shown below:

Help her in writing the code to do the following: (6)

i. After entering the age in the specified text field, when ‘Chk Eligibility’ button is clicked, a dialogue box should be displayed with a message “Welcome” if age is in between 3-13 years else there should be a message “Sorry! You are either underage or overage!!”. Additionally the application should be closed if age is inappropriate.

ii. After selecting the desirable activities, total fee should be displayed in the specified text field on the click of “Proceed” button at the rate of Rs. 1000 per activity.

iii. A discount of 20% is applicable if more than one activity is chosen by the user.

iv. After clicking on the “Net Fee” button, Net Fee should be calculated and displayed in the respective text field as per the given formula:
Net Fee = Fee – Discount

5 (a). While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. Help him in choosing the right data type to store employee name. Give valid justification for the same. (2)

(b) Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary.
After creating the table, she realized that she has forgotten to add a primary key column in the table. Help her in writing SQL command to add a primary key column empid. Also state the importance of Primary key in a table. (2)

(c) Consider the following table: (4)

Student:

Admn	Name	Stream	Optical	Average
1001	Shrishti	Science	CS	90
1002	Ashi	Humanities	Maths	80
1003	Aditya	Commerce	IP	60
1004	Ritu Raj	Science	IP	65
1005	Sonali	Commerce	Maths	60
1006	Saumya	Science	IP	65
1007	Ashutosh	Science	IP	95
1008	Parshant	Commerce	P.ED	80
1009	Aman	Commerce	IP	70
1010	Rishabh	Humanities	P.ED	85

Write commands in SQL for (i) to (iv):

i. To display the details of all those students who have IP as their optional subject.

ii. To display name, stream and optional of all those students whose name starts with ‘A’.

iii. To give an increase of 3 in the average of all those students of humanities section who have Maths as their optional subject.

iv. To display a name list of all those students who have average more than 75.

(d) On the basis of the Table Student, write the output(s) produced by executing the following queries: (2)

i. Select max(average), min(average) from students group by stream having stream like ‘Science’;

ii. Select name from students where optional IN (‘CS’,’IP’);

6 (a) Write SQL query to create a table “Registration” with the following structure: (2)

Table: Registration

Field name	Datatype	Size	Constraint
Reg_Id	Integer	2	Primary Key
Name	Varchar	20
Course	Varchar	10
Joint_Dt	Date

(b) Consider the tables given below while attempting the following questions:

Train

TrainID	TName	Source	Destination
3402	Century Express	New Delhi	Mumbai
4023	Superfast Express	Kanyakumari	Chandigrah
3424	Lucknow Mail	Lucknow	New Delhi
6542	Capital Express	Chennai	Kolkata
9876	Punjabi Mail	Patna	Ludhiana
5400	Century Express	New Delhi	Kanpur

Reservation

REfNo.	TrainID	Passenger	JourneyDate
S001	4023	Shubham Singh	2017-07-02
C002	6542	Jishan Mittal	2017-06-25
S002	4023	Jessica Raj	2017-07-02
P001	9876	Paramjeet Singh	2017-07-22
S003	4023	Gurjyot Singh	2017-07-03
C002	6542	Akash Mukharjee	2017-06-25
P002	9876	Meera Devi	2017-07-22
L001	3424	Ruby Lal	2017-06-29
C003	5400	Tapshree	2017-07-04

(i) Identify the primary key column of Train and Reservation. (1)
(ii) Help Mr. Sajal in identifying the wrong statement with reference to UNION clause: (1)

a. Each SELECT statement within UNION must have the same number of columns

b. The columns must also have similar data types

c. The columns in each SELECT statement must also be in the same order.

d. By default, the UNION operator selects all the values.

(c) With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: (6)

i. To display the Train name along with its passenger name.

ii. To display Train detail which has no reservation yet.

iii. SELECT T.* from Train T, Reservation R where T.TrainId=R.TrainId

AND Source LIKE “%Delhi” OR Destination LIKE “%Delhi”;

7 (a) Write down any two benefits of net banking. (1)

(b) Mr. Sanjay, a banking professional want to enroll himself in an e-Learning course. Mention him any two challenges of e-Learning. (2)

(c) Ms. Juhi, works as an IT Executive in a health insurance company named ‘Total Health’. She has been assigned a task to design a customer registration page. Help her in choosing the most appropriate controls for the specified task from (2)

Textfield, Label, RadioButton, CheckBox, ListBox, ComboBox, Button and write in the third column considering the following points:

• Customer can enter his/her name in the control.
• Customer can choose only one city out of given list of city.
• Customer can choose only one type out of given policy types.
• Customer can choose any number of INCLUSIONS out of given inclusions.

S.No.	Control Used to	Control
1.	CUSTOMER’S NAME
2.	CUSTOMER’S NAME
3.	POLICY TYPE(individual/Family)
4.	INCLUSIONS (Critical Illness/Accidental Coverage / Health Checkup/Others)

This is only initial part of the whole sample paper. Download Complete set of sample paper for class 12 Informatics Practices

Sample Paper for class 12

It is Sample paper for class 12 Informatics Practices. However, myCBSEguide provides the best sample papers for all the subjects. There are number of sample papers which you can download from myCBSEguide website. Sample paper for class 12 all subjects

• CBSE Sample Papers for Class 12 Physics
• CBSE Sample Papers for Class 12 Chemistry
• CBSE Sample Papers for Class 12 Mathematics
• CBSE Sample Papers for Class 12 Biology
• CBSE Sample Papers for Class 12 English Core
• CBSE Sample Papers for Class 12 Business Studies
• CBSE Sample Papers for Class 12 Economics
• CBSE Sample Papers for Class 12 Accountancy
• CBSE Sample Papers for Class 12 Computer Science
• CBSE Sample Papers for Class 12 Informatics Practices
• CBSE Sample Papers for Class 12 Hindi Core
• CBSE Sample Papers for Class 12 Hindi Elective
• CBSE Sample Papers for Class 12 History
• CBSE Sample Papers for Class 12 Political Science
• CBSE Sample Papers for Class 12 Geography
• CBSE Sample Papers for Class 12 Home Science
• CBSE Sample Papers for Class 12 Physical Education
• CBSE Sample Papers for Class 12 Other Subjects

These are also Sample Paper for class 12 Informatics Practices available for download through myCBSEguide app. These are the latest Sample Paper for class 12 Informatics Practices as per the new board exam pattern. Download the app today to get the latest and up-to-date study material.

Marking Scheme for Class 12 Board exam

Subject	Board Marks	Practical or internal Marks
English	100 Marks	ZERO Marks
Hindi	100 Marks	ZERO Marks
Mathematics	100 Marks	ZERO Marks
Chemistry	70 Marks	30 Marks
Physics	70 Marks	30 Marks
Biology	70 Marks	30 Marks
Computer Science	70 Marks	30 Marks
Informatics Practices	70 Marks	30 Marks
Accountancy	80 Marks	20 Marks
Business Studies	80 Marks	30 Marks
Economics	80 Marks	20 Marks
History	80 Marks	20 Marks
Political Science	100 Marks	ZERO Marks
Geography	70 Marks	30 Marks
Sociology	80 Marks	20 Marks
Physical Education	70 Marks	30 Marks
Home Science	70 Marks	30 Marks

Download CBSE Sample Papers

To download complete sample paper for class 12 Informatics Practices, Political Science, Economics, Physics, Geography, Computer Science, Business Studies, Accountancy, Chemistry and Biology; do check myCBSEguide app or website. myCBSEguide provides sample papers with solution, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Paper all are made available through the best app for CBSE students and myCBSEguide website.