CBSE Question Paper 2013 class 12 Informatics Practices

myCBSEguide App

myCBSEguide App

Complete Guide for CBSE Students

NCERT Solutions, NCERT Exemplars, Revison Notes, Free Videos, CBSE Papers, MCQ Tests & more.

Download Now

 

CBSE Question Paper 2013 class 12 Informatics Practices conducted by Central Board of Secondary Education, New Delhi in the month of March 2013. CBSE previous year question papers with solution are available in myCBSEguide mobile app and cbse guide website. The Best CBSE App for students and teachers is myCBSEguide which provides complete study material and practice papers to cbse schools in India and abroad.

CBSE Question Paper 2013 class 12 Informatics Practices

Download as PDF

CBSE Question Paper 2013 class 12 Informatics Practices

General Instructions:        

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

1. (a) Which wireless communication channel is most appropriate in each of the following situations?
(i) Communication in a hilly area.
(ii) Very fast communication between two offices in two different countries.
(b) With what aim UNICODE was developed?
(c) Expand the following file extensions:
(i) ODF
(ii) XML
(d) Give one example of URL and one example of domain name.
(e) What is the use of repeater in a Network? How is it different from Hub?
(f) Give two characteristics of Star Topology. Also, show it using a diagram with interconnection of 5 computers. (2)
(g) What is Snooping? (2)

2. (a) Name method is used to extract value of Index while using ListBox in Java. (1)
(b) What is the difference between the use of is selected and set selected methods used with JCheck8ox in Java?
(c) Name any two commonly used methods of JComboBox control.
(d) Name any two attributes used in <img> tag of HTML.
(e) How many times the following loops will execute the statements inside it? Which one of them is Entry Control and which one is Exit Control? (2)

(f) What will be displayed in jTextFieldl and jlcxtField2 after the execution of the following loop? (2)
int Total=0, End=10;
for(int Turn=1,Turn<=End;Turn+=2)

Tota1++,
jTextField1.setText(Integer.toString(Total)),
jTextField2.setText(Integer.toString(Turn)),
(g) Differentiate between the <BR> and <HR> tags of HTML with suitable example. (2)

3. (a) Write a command to add a NOT NULL constraint on FEES column of a student table. (1)
(b) Write SQL command to create a SAVEPOINT called Al.
(c) Define Foreign Key with reference to RDBMS. (1)
(d) Table BANK has 2 rows and 3 columns. Table CUSTOMER has 4 rows and 3 columns. What will be the cardinality and degree of the Cartesian product of them?
(e) There is a column HOBBY in a Table CONTACTS. The following two statements are giving different outputs. What may be the possible reason? (2)

SELECT COUNT(*) FROM CONTACTS;
SELECT COUNT(HOBBY)FROM CONTACTS,

(f) Name the methods used to convert one type of data to another in the following statements of Java. (2)
int Num-lnteger.paraeInt(jTextFieldl.getText()),
jTextField2.setText(Integer.toString(Num));

(g) Mr. Tondon is using table EMP with the following columns. (2)
ECODE, DEPT, EMAME, SALARY
He wants to display all information of employees (from EMP table) in ascending order of ENAME and within it in .ascending  older of DEPT. He wrote the following command, which did not show the desired output.

SELECT * FROM EMP ORDER BY NAME DESC, DEPT;
Rewrite the above query to get the desired output.

4. (a) What will be the content of Textarea and ToxtField1 after the execution of the following statements? (2)
(i)  Textarea. setText (’Go\tGreen\nINDIA”) ;
(ii) String Message=’All The Best”;

jTextFieldl.setText((Message.length()-6)+’ ’);

(b) Rewrite the following pmgianime code using a while loop statement: (2)
int Last=Integer.parseInt(jTextFieldl.getText()),
for (int C=l,C<=Last,C++)
jTextAreal.setText(Integer.toString(C));

(c) Observe the following code carefully and find which statement will never get executed in the code.
int Count=1,                                       //Statement 1
Do                                                         //Statement 2
{                                                           //Statement 3
if (Count<15)                                     //Statement 4
jTextPieldl.setText(’Jump’),                //Statement 5
else                                                          //Statement 6
jTextFieldl.setText(’Stop’);                   //Statement 7
Count+=4;                                            //Statement 8
}                                                           //Statement 9
while(t<=15);                                       //Statement 10

(d) Write Java statement to make jButton1 disabled. (1)

(e) What will be displayed in jTextField1 after the execution of the following code? (2)

int Sum,One=3,Two=5;
Sum = One * Two++
jTextField1.setText(Integer.toString(Sum));
jTextField2.setText(Integer.toString(Two)),

(f) What will the contents of Text1 and Text2 after the following executed ? (2)
String Text2, Text1,
Text1= ’Good Morning’,
Text2= ’India’,
Text1=Text2.concat(Text1),

(g) Shekher is a junior programmer at ducom Enterprises. He created the following GUI in Netbeans.

Help him to write code for the following.

(i) To calculate Income Tax to be paid and display in jTextField4 on the click of Command Button  “Calculate  Income  Tax”  as  per  the  following condition : (2)
If the Basic is less than 5O00 then IncomeTax =Basic*0.2
And if is greater or equal to 50000 then lncomeTax=Basic*0.3

(ii) To calculate Salary and display in jTextField5 on the click of Command Button “Calculate_Salary”. (2)
Hint:
Salary =
(Basic+ DearnessAllowance+ House Rent Allowance)-income tax.

(iii) To Clear all Text Fields on the click of Command Button “Clear”.

5. (a) What is the use of UPDATE statement in SQL? How is it different from ALTER statement? (2)

(b) Mr. Shankar created a table VEHICLE with 3 rows and 4 columns. He added 1 more rows to it and deleted one column. What is the Cardinality and Degree of the Table VEHICLE?

(c) Consider the following table named “GYM” with details about fitness items being sold in the store. Write command of SQL for (i) to (iv) and output for (v) to (vii).

Table GYM:

(i) To display the names of all the items whose name starts with “A”.

(ii) To display ICODEs and INAMEs of all items, whose Brand name is Reliable or Coscore.

(iii) To change the Brand name to “Fit Trend India” of the item, whose

(iv) Add a new row for a new item in GYM with the details: “Gl07″, “Vibro exerciser”,21000,”GTCFitness”

(v) SELECT COUNT (DISTINCT (BRAND NAME) ) FROM GYM;

(vi) SELECT MAX (PRICE) FROM GYM,

(vii) SELECT NAME FROM GYM WHERE NAME LIKE “%t’,

6. (a) Write SQL command to create the table Vehic1e with given constraint.
Table:   CRALLAN
CBSE Question Paper 2013 class 12 Informatics Practices

(b) In a Database Kamataka_Sangain there are two tables with the instances given below:

Table: STUDENTS

Table: SPORTS

Write SQL queries for the following:

(i) To count how many addresses are not having NULL values in the address column of students table. (2)

(ii) To display Name, Class from STUDENT table and the corresponding Grade from SPORTS table. (2)

(iii) To display Name of the student and their corresponding Coach names from STUDENTS and SPORTS tables. (2)
(c) Answer the questions (i) and (ii) based on the following table:

Table: FACULTY

(i) Identify the Primary Key in the Table Faculty. (1)

(ii) Write SQL Command to change the Grade of Nishant to “A”. (1)

7. (a) How popularity of e-Commerce has benefitted a common man? Give the common man domain name of one popular e-Commerce site. (2)

(b) Give two addresses of most commonly used e-Learning sites.

(c) Shobliit is creating a form for his company. Help her to choose most appropriate controls from  ListBox,  ComboBox, TextField, Textor a, RadioButton, CheckBox, Label and Command Button for the following entries.        (2)

S.NoFunction
1.To select citizenship from a list of countries
2.To allow to input grade out of ‘A’ to ‘D’
3.To allow selecting one or many food items
4.To allow entering Feedback in the form of a paragraph

These are questions only. To view and download complete question paper with solution install myCBSEguide App from google play store or log in to our student dashboard.

Download myCBSEguide App

CBSE Question Paper 2017 class 12 Informatics Practices

Download class 12 Informatics Practices question paper with solution from best CBSE App the myCBSEguide. CBSE class 12 Informatics Practices question paper 2017 in PDF format with solution will help you to understand the latest question paper pattern and marking scheme of the CBSE board examination. You will get to know the difficulty level of the question paper.

Previous Year Question Paper for class 12 in PDF

CBSE question papers 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005 and so on for all the subjects are available under this download link. Practicing real question paper certainly helps students to get confidence and improve performance in weak areas.

To download CBSE Question Paper class 12 Accountancy, Chemistry, Physics, History, Political Science, Economics, Geography, Computer Science, Home Science, Accountancy, Business Studies and Home Science; 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.




Test Generator

Test Generator

Create Papers with your Name & Logo

Try it Now (Free)

Leave a Comment