Name of the Board : CBSE Academic
Class : XII STD
Document Type : Sample Question Paper
Subject : Informatics Practices
Year : 2017-18
Website : http://cbseacademic.nic.in/SQP_CLASSXII_2017_18_final.html
Download Sample Question Paper : https://www.pdfquestion.in/uploads/22377-Informatics-Practices-SQP.pdf
Informatics Practices Sample Question Paper :
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
Related : CBSE Academic XII STD Informatics Practices Sample Question Paper 2016 – 17 : www.pdfquestion.in/10099.html
(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 a 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 :
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. 4
(b) Rewrite the following code using switch case
int day=Integer.parseInt(jTextField1.getText());
if(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.
ii. How HTML is different from XML? Mention any two point of difference. 4
3 (a) Mention any two example of common Database Management System. 1
(b) Write the full forms of the following i. DDL ii. DML 1
(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.
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
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 :
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 :
int x=10;
while(x>1)
{
x=x/3;
++x;
}
1
(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
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 :
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 :
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.
(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.