CBSE Class 12 Informatics Practices Sample Paper 2017 (2)

Scroll down for PDF

CBSE Class 12 Informatics Practices Sample Paper 2017 (2). It’s always recommended to practice as many sample papers as possible before the examinations. Students can download the sample papers and also question papers of previous years to practice and score better marks in examinations. Refer to other links too for more sample papers.

Q1. a) Draw a network layout of star topology to connect one server and 4 client computers.(1)

 b) Satish is confused between the working of a firewall and antivirus. Write few lines to remove his confusion.

c) Who is considered as a owner of an Open Source Software? Why MS Office is not an open source software ? (1)

d) Name one Open Source Programming languages. (1)

e) Name two threats to security in a network. What is the role of Firewall in Network security? (1)

f) What is relationship between an IP address and a Domain Name? What is a Domain Name Server? (2)

g) Write one advantage and one disadvantage of Open Source software over Proprietary software. (2)

Q2. a) What is the difference between jTextField and jPasswordFiled components? (1)

b) What would be the value of variable a after execution of following code : (1)

for(int i = 2 , j = 5, a = 6 ; i<=j ; i++, j--) { a+=i+j; }

c) Consider two JListcomponents: jList1 and jList2 and then interpret the task done in following step : jList1.setSelectedIndex(jList2.getSelectedIndex() – 1); (1) d) Convert the following code into a switch case statement : (1) int i = Integer.parseInt( jtextF1.getText( ) ); if (i == 2)


else System.out.print(“No”);

e) Write code to produce the above HTML Table Output (Table is blank) (2)

f) Kamal wants to transfer data from his MySQL database into an excel file, using which of the following markup language he will perform the task and why? (2) i) HTML ii) XML iii) SGML

g) Write java code that take any number from user in jTextField1 and calculates the sum of all even digits and display it in separate textField names jTextField2. For example if the number entered is 7424 then the output would be 4+2+4 = 10 (2)

Q3. a) Keerti created a database name MOVIE using MySQL, when she wrote and executed SQL command to create a table in the database MOVIE , an error message : “No database selected” appeared before her. How can Keerti remove this error so that she can create the table? 

b) Can we remove Primary Key column of a Table in MySQL? What is problem with it? (1) c) Is NULL value the same as 0 (zero)? Write the reason for your answer. (1) d) Kabir works as a database administrator in a company , he wants to rollback his last three SQL commands and commit all other commands before it. Which MySQL he should suitably used? (1) e) What would be the output of the following SQL commands on the basis of VISIT table. (2)

i) Select Donation + Fee from VISIT ;

ii) Select Count(Fee), Avg(Donation) from VISIT;

f) Write output of the following MySQL queries : (2)


ii) SELECT ROUND(140.295,-2);

iii) SELECT INSTR(‘Corporation’, ‘or’);

iv) SELECT CONCAT(‘India’, NULL, ‘Australia’);

g) While using SQL pattern matching, what is the difference between ‘_’ (underscore) and ‘%’ wildcard symbols? (2)

Q4. a) Define Superclass and Subclass in Java in relation with Inheritance. (1) b) What would be the output of the following code : (1) String name = “Rishabh”; JOptionPane.showMessageDialog(null , name + name.length() );

c) What would be the output in jTextField1 of the code below : (1) jTextField1.setText(“ “ + Integer.parseInt(“101”) + 2 + 3); d) Find the output of the following code snippet : (2) String str = "Greatest", newStr = ""; for(int i = 0; i<str.length() - 4 ; i++) { newStr = newStr + str.substring( i , i+2)+"\n"; }

JOptionPane.showMessageDialog(null, newStr); e) Rewrite the following code using while loop : (2) for(int x = 1 , y = 2, z = 5 ; x<= z ; x++ , y - -)

{ z += x+y;

} JoptionPane.showMessageDialog(null , “Stop”);

f) The following code has error(s) . Rewrite the correct code underlining all the corrections made : String x = 1230; (2) int x = 2; String str ; for(int b = 0 ; b <x.length() ; b++); { str += b; }

g) Veermani works in a company and wants to make a Depreciation Calculator as per following GUI 

Please click the link below to download CBSE Class 12 Informatics Practices Sample Paper 2017 (2).


Click on the text For more study material for Informatics Practices please click here - Informatics Practices

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

CBSE Board Introduces Experiential Learning for Student

CBSE Academic Session 2019-20: Board Introduces Experiential Learning for Student: The education sector has grown for some new changes. As per the latest updates the Central Board of Secondary Education has been good in making all the possible efforts to improve...

Requirements for admissions in CBSE affiliated Schools

CBSE gives an advanced form of education. They try to indulge students in interactions and teach application based subjects along with some others. Due to this preponderance of parents, they tend to admit their children in CBSE affiliated schools. General conditions...

Extension of dates by CBSE for Single Girl Child Merit (SGC) scholarship

CBSE has announced to extend dates for SGC scholarship. Previously the dates to submit the SGC scholarship form were 18 October 2019. Now dates have shifted. For online submission, the last date is 31st October. Whereas date for submission of hard copies of renewal...

Error in the evaluation of answer sheets in CBSE

The education board has witnessed many events where invigilators are being suspended for allotting wrong marks to the students.  This has affected students mainly of classes X and XII in the 2019 CBSE Board Exams. The central board of secondary education has taken...

Seven Motivational tips for every student

If you’re are a student or a learner and you doesn’t feel like study then this article is going to be very important for you, Reading constantly and Staying motivated as a student is one of the most challenging tasks and barriers to educational success. Education is...

CBSE Board Secretary says Class 10 and 12 CBSE Exam Pattern to be modified

The Central Board of Secondary Education is expected to introduce a few changes to the exam pattern for class 10 and board exams by 2023. Anurag Tripathi, secretary of CBSE speaking at an Assoham School Education Summit said that although this year class 10 students...

Studies Today