Previous Year Question Paper with Answer of “Information Technology Code – 802” for Class 11 NSQF Vocational, CBSE Session 2021-2022.

CBSE Vocational Education
Information Technology (Subject Code – 802)

Class-11 (Session 2021-2022)

Sample Question Paper (Ms) For Term – II

Max. Time Allowed: 1 ½ Hours (90 Min) Max. Marks: 30

SECTION A

Answer any 03 questions out of the given 04 questions 1 x 3 = 3

Q.1 National Action Plan on Climate Change is an action plan which includes different missions or plans within it for sustainable development. Name any two plans. 1

Q.2 An entrepreneur may face many problems while running a business. Name any two problems. 1

Q.3 Who are the major stakeholders of green economy? 1

Q.4 What is the type of business that uses raw materials, parts and components to assemble finish goods. 1

Answer any 01 question out of the given 02 questions 1 x 2 = 2

Q.5 There are many sectors of the green economy that affect your daily life. Explain any one of them and what you can do to help a green economy. 2

Q.6 What are two major differences between qualities and values of an entrepreneur and employee? 2

SECTION B 

Answer any 05 questions out of the given 07 questions 1 x 5 = 5

Q.7 What is the difference between getters and setters in JAVA? 1

Q.8 Sheba is entering marks in a table but she is not able to leave the Name field in table as blank. What could be the probable reason(s)? 1

Q.9 SQL supports a set of logical operators. Name any one of them. 1

Q.10 Define Cardinality. 1

Q.11 Hira wants to store values in a table but the command below is giving errors. Write correct MYSQL command for creating table.

CREATE employee (name VARCHAR, id INTEGER) 1

Q.12 Ms. Reeta is designing an admission form for the college. She wants the user to select his stream from science, commerce and humanities. Help her select the most appropriate Swing Control in Netbeans IDE. 1

Q.13 Give one limitation of switch case. 1

Answer any 03 questions out of the given 05 questions 2 x 3 = 6

Q.14 double c, x=5,y=10;
int z=51;
c= x*y+z/2.5; 2

Q.15 Give any two methods of JOptionPane 2

Q.16 Define Primary key and Foreign Key with examples.

1 mark for definition and 1 mark for example 2

Q.17 What is the difference between jComboBox and jListBox. Give one method of each of them? 2

Q.18
a) Which keyword is used to eliminate redundant data in MYSQL?

b) Which MYSQL command is used to modify data in a table? 1+1=2

Answer any 02 questions out of the given 04 questions 3 x 2 = 6

Q.19 Which of the following is an invalid variable name and why?

3names, Integer, name.india, work_plan, jTextRavi, Kapil:Cricket 3

Q.20

a. Give the output if user selected second radio button
if (jRadioButton1.isSelected())
jTextField1.setText(“hello”);
else if (jRadioButton2.isSelected())
jTextField1.setText(“hi”);
else if (jRadioButton3.isSelected())
jTextField1.setText(“namaste”);
else
jTextField1.setText(“Not Selected”);

b. Name the property that sets action to be performed when the user attempts to close the form 2+1

Q.21

A) The clause which is used to arrange the records in ascending or descending order.
B) In MYSQL ………. keyword is used to assign meaningful columns names to the results of queries.
C) Wild card characters …….and ……..are used in MySQL 1+1+1

Q.22
a) Differentiate between Delete and Drop command.
b. What is the MYSQL command to view the structure of the table 2+1

SECTION C

(COMPETENCY-BASED QUESTIONS)

Answer any 02 questions out of the given 03 questions.

Q.23
Reema wants to check whether the number is even or not but the code below is giving errors, underline the errors and help her write the correct code.

If(int num%2=0);
{jTextField1.setText(“even”)
Else
jTextField1.setText(“odd”) 4

Q.24 Consider the table EXAM given below. Write commands in MySql for (i) to (IV)

A) To list the names of those students, who have obtained Division as FIRST.
B) To display records listing NAME, SUBJECT for stipend between 400 to 800.
C) Remove the column division
D) To create a database by the name SCHOOL.

Q.25 Design a GUI application to accept the side of a square in a text field and calculate the area and perimeter of the square. Add Refresh button to clear all text fields and a Stop button to end the application.
Hint [ Area of a square = side * side and perimeter = 2(side +side)] 

ANSWERS

SECTION A

Answer any 03 questions out of the given 04 questions 1 x 3 = 3

Q.1
Answer
National Mission for a Greener India/ National Mission on Sustainable Agriculture/
National Solar Mission/ National/Mission on Sustainable Habitats
(Mention any 2 of them)

Q.2
Answer
Pricing/selling/accounting/growing business/manufacturing
(mention any 2 of them)

Q.3

Answer
Government, Private agencies, People

Q.4

Answer: manufacturing business
Answer any 01 question out of the given 02 questions 1 x 2 = 2

Q.5
Answer
Agriculture/ forestry/ energy resources/ construction /fishery / tourism / transport
(Mention any one of them giving suitable steps that we can take in that sector.)

Q.6
Answer
Belief in Self/Customer Focus/Decision Making and Responsibility/Belief that
Environment can Change
(Explain any 2 points with reference to an entrepreneur and employee)

SECTION B

Answer any 05 questions out of the given 07 questions 1 x 5 = 5

Q.7
Answer
Getters are the methods which extract some information from the object and return it to the program.
Setters are the methods which set some properties of the object so that the object’s appearance changes.

Q.8
Answer
The column Name has NOT NULL constraint

Q.9
Answer
AND, OR, NOT
(mention any 1 of them)

Q.10
ANSWER: NUMBER OF ROWS IN A TABLE 1

Q.11
Answer
CREATE TABLE employee (name VARCHAR, id INTEGER);
(2 errors to be corrected )

Q.12
Answer
Radio button

Q.13
Answer
1.It doesn’t allow ranges.

2. It requires either integers or characters and doesn’t allow String.
(Any 1 limitation)

Answer any 03 questions out of the given 05 questions 2 x 3 = 6

Q.14
ANS: 70.4

Q.15
ANSWERS
showMessageDialog()
showConfirmDialog()
showInputDialog()
(give any 2 methods)

Q.16
Define Primary key and Foreign Key with examples.
(1mark for definition and 1 mark for example)

Q.17
Answer
jComboBox is like a drop down box – you can click a drop-down arrow and select an option from a list whereas jList provides a scrollable set of items from which one or more may be selected.
getSelectedItem() for combobox
getSelectedValue() for list

Q.18
ANSWER: A) DISTINCT
ANSWER: B) UPDATE
Answer any 02 questions out of the given 04 questions 3 x 2 = 6

Q.19
ANSWER:
3 NAMES: INVALID STARTING WITH A NUMBER
INTEGER AND JTEXTRAVI: KEYWORD
NAME.INDIA KAPIL :CRICKET: INVALID AS HAVE SPECIAL CHARACTER
WORK_PLAN : VALID

Q.20
answer
a.hi
b. defaultCloseOperation

Q.21
ANSWER:
A) Order by
B) AS
C) _ *

Q.22
answer
describe <table name>;

SECTION C (2 x 4 = 8 marks)
(COMPETENCY-BASED QUESTIONS)

Answer any 02 questions out of the given 03 questions

Q.23
Answer

If(int num%2=0);
{jTextField1.settext(“even”)
Else
jTextField1.setText(“odd”)
ANSWER:
Correct code
if(int num%2==0)
jTextField1.setText(“even”);
else
jTextField1.setText(“odd”);
(8 errors to be marked and corrected )

Q.24
Answers
A) Select Name from EXAM where division =” FIRST”;
B) Select Name, Subject from Exam where Stipend between 400 and 800;
C) Alter table Exam drop Division;
D) Create Database SCHOOL;
No. Name Stipend Subject Average Division
1 Babita 400 English 15 FIRST
2 Silky 680 Maths 24 FIRST
3 Jyoti 500 Accounts 35 FIRST
4 Archana 200 IP 20 SECOND
5 Sugandha 400 History 10 THIRD
6 Suparna 550 Geo 5 THIRD
7 Ankit 400 History 10 THIRD

Q.25
ANSWER:

//Coding for jButton1 (“Calculate the area” button)
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
double a,b;
a=Double.parseDouble(jTextField1.getText());
b=a*a; jTextField2.setText(Double.toString(b));
}
//Coding for jButton2 (“Calculate the perimeter” button)
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt)
{
doublea,c;
a=Double.parseDouble(jTextField1.getText());
c=4*a;
jTextField3.setText(Double.toString(c));
}
//Coding for jButton4 (“Refresh” button)
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt)
{
jTextField1.setText(” “);jTextField2.setText(” “);jTextField3.setText(” “);
}
//Coding for jButton5 (“stop” button)
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt)
{
System.exit(0);}
(1 mark for coding of each button)