JNV Agra JNV Agra

CBSE Affiliation Number:2140019

(Ministry of HRD, Government of India)

Current Time :

Today Date : 22-04-2019

Hindi Version

 PRE-ANNUAL EXAMINATI ON

 

 

INFORM AT ICS PRACTI CES

 

C L A S S X I

 

Time allowed: 3 hours                                                                      Maximum Marks: 70

 

 

Note: (i) This question paper is divided into 3 sections

 

(ii)      Section A consists of 30 Marks.

 

(iii)     Section B consists of 20 marks.

 

(iv)     Section C consists of 20 Marks.

 

(iv) Answer the questions after carefully reading the text.

 

 

SECTION- A

 

1.                       Answer the following questions :

 

a.              Define each of the following:

 

 

 

(a) Nibble (b) Byte

(c) Kilo Byte (d) Giga Byte

2

 

b.

State the basic units of the computer. Name the subunits that make up the CPU, and give the function of each of the

2

 

 

units.

 

 

 

 

c.

Differentiate between the compiler and interpreter.

2.

 

d

What is a computer virus? How can it affect your computer?

2.

 

e

Expand the following terms :

2

 

 

a) PDAs

b) MICR

c) DVD d) TFT

 

2.

a.

Which Graphical controls of JAVA can used to display multiple choices out of which more than one can be selected?

1

 

b.

Suppose you want to scan your storage devices attached with your computer for virus infection . Suggest the type and

1

 

 

name of the software.

 

 

 

c.

What is Write Once Run Anywhere characteristics of Java?

2

 

d.

How can you declare the variable in JAVA for the following:-

2

 

 

(i)

If you want to store the employee no. of an employee.

 

 

 

(ii)

If you want to store the name of an employee.

 

 

e.

What is meant by E-learning. Suggest any two websites which can be used for E-learning.

2

 

f.

What benefits (mention at least 2) does an e-business offer to an organization?

2

3.

a.

Define the following terms in respect of Relational database management System:

2

 

 

(i)

Primary Key.

 

 

 

(ii)

Foreign Key.

 

 

b.

Differentiate between DEFAULT and CHECK constraint of table with example.

2

 

c.

What will be the output of following code?

2

 

 

(i)

SELECT LOWER(CONCAT('Informatics', 'Practices'));

 

 

 

(ii)

SELECT INSTR('INFORMATICS PRACTICES','OR');

 

 

d.

Difference between DDL and DML commands of SQL with example.

2

 

e.

Rahul wants to create a table STUDENT which can store Roll number, name, address and percentage in SQL. Write the

2

 

 

 

 

4.      a.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

b.

 

 

 

 

 

 

 

 

 

 

 

 

c.

 

 

 

 

 

d.

 

 

 

 

 

 

 

 

 

 

 

 

 

5.      a.

 

command to create the table STUDENT (Decide the type and size of column on your own).

 

 

SECTION-B

 

Give the value of x after executing following Java code.

 

2

int a=10;

 

 

 

int b=12;

 

 

 

int x=5; int y=6;

 

 

 

while (a<=b)

 

 

 

{ if (a%2= =0)

 

 

 

x=x + y;

 

 

 

else

 

 

 

x=x-y;

 

 

 

a=a+1;

 

 

 

}

 

 

 

Find the errors from the following code segment and rewrite the corrected code underlining the correction made.

2

int a ,b;

 

 

 

c = a + b;

 

 

 

for(;i<=5;i++)

 

 

 

{

 

 

 

Display c;

 

 

 

c=c+1

 

 

 

]

 

 

 

Rewrite the following code using do-while loop.

 

2

For(int x=0;x<10;x++)

 

 

 

{

 

 

 

System.out.Println(x);

 

 

 

}

 

 

 

Write a JAVA Program to print the following Pattern:

 

2+2

(i)

(ii)

 

 

6

A

 

 

55

AAA

 

 

444

AAAAA

 

 

3333

AAAAAAA

 

 

22222

AAAAAAAAA

 

 

111111

 

 

 

Design an application that obtains three values in three text fields from user: Principal, Rate of Interest, Time. It should

4

then compute and display Simple Interest when Calculate button is clicked. Controls names and Interface are given below

 

-

 

 

 

Control

Purpose

Name

 

Text box

To accept Principal

jTextField1

 

 

To accept Rate of Interest

jTextField2

 

 

To accept Time

jTextField3

 

 

To display Simple Interest

jTextField4

 

 

Command Button         To Click for computation & display of Simple Interest

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

b.          Write a java code to calculate and print the factorial of an integer stored in variable num.                                 4

 

 

 

 

c.

Rajni Raghav works for a Computer Institute. He wishes to create controls on application form for the following

2

 

functions. Choose appropriate controls from Text Box, Label, Option Button, Check Box, List Box, Combo Box,

 

 

command Button and write in the third column :

 

 

 

S.No.

Function / Purpose of Control

Control

 

         

 

1                       Enter Applicant Name

 

2                       Enter Gender

 

3                       Enter Course from a List of choices

 

4                       Submit Form

 

SECTION-C

 

6.                       Answer the question based on the table given below:

 

 

 

 

TABLE : Student

 

 

 

Column Name

Data Type

Siz

Constraint

 

 

Roll_No

NUMBER

e

PRIMARY KEY

 

 

Name

VARCHAR

4

Not Null

 

 

Stipend

NUMBER

20

Stipend is greater than 0

 

 

Stream

VARCHAR

7

Not Null

 

 

Grade

VARCHAR

15

 

 

 

 

 

1

 

 

(i)

Write the SQL command to create the above table with constraints.

2

(ii)

Insert 2 records with relevant information, in the table student

 

1

(iii)

Display all the records of the table Student.

 

1

(iv)

Delete the Student Whose Roll no is 100.

 

1

(v)

Change the Stream of Student to 'Computer' Whose Roll no. is 536.

1

(vi)

Add one column email of data type VARCHAR and size 30 to the table Student.

1

(vii)

View structure of the table created by you.

 

1

(viii)

Drop the table Student.

 

 

1

(ix)

Make the all changes permanently.

 

 

1

 

7.                       Answer the question based on the table given below:

 

 

 

 

 

TABLE : HOSPITAL

 

 

 

No.

Name

Age

Department

DatoFadm

Charges

Sex

1

Arpit

62

Surgery

21/01/98

300

M

2

Zareena

22

ENT

12/12/97

250

F

3

Kareem

32

Orthopedic

19/02/98

200

M

4

Arun

12

Surgery

11/01/98

300

M

5

Zubin

30

ENT

12/01/98

250

M

6

Ketaki

16

ENT

24/02/98

250

F

7

Ankita

29

Cardiology

20/02/98

800

F

8

Zareen

45

Gynecology

22/02/98

300

F

9

Kush

19

Cardiology

13/01/98

800

M

10

Shilpa

23

Nuclear Medicine

21/02/98

400

F

 

(a) To list the names all the patients admitted after 15/01/98.

2

(b)   To list the names of female patients who are in ENT department.

2

(c)   To list names of all patients with their date of admission in ascending order.

2

(d)   To display Patient's Name, Charges, Age for only female patients.

2

Find Out the Output of Following SQL Command:-

 

(i)

Select COUNT(DISTINCT charges) from HOSPITAL;

1

(ii)

Select MIN(Age) from HOSPITAL where Sex="F";

1

 

Navodaya Vidyalaya Samiti

 

PRE-ANNUAL EXAMINATION

 

Class - XI

 

Sub : Informatics Practices

MM : 70

Time : 3Hours

 

 

Instructions:

 

 

i) All questions are compulsory.

 

ii) Answer the questions after carefully reading the text.

 

iii) Please check that this question paper contains 7 questions.

 

iv) Do all the parts of same questions together.

 

Q1

 

(a) Out of the following devices , classify them as input & output  devices.

 

(i) Light pen

1

(ii) flatbed plotter

1

(iii) drum printer

1

(iv) OMR

1

(b) Differentiate between the  application software  & system software

2

(c) What measure would you take to avoid:

2

(i) virus attack (ii) PC intrusion

 

(d) Write the function of the following : (i) address bus  (ii) control bus

2

Q2

 

(a) What is the name of event listener interface for action events ?

1

(b) What  is the significance of break in a switch.

2

(c) Differentiate between the following:

2

(i) for and while

1

(ii) break and continue

1

(d) Why is program maintenance considered very important.

2

 

(e) Marks of a student is stored in a string variable strMarks. Write a java statements

1

to convert marks in double variable dblMarks.

 

Q3

 

(a) What is a database? Also explain the relational database.

2

(b) What is Primary Key? How it is different from candidate key ,explain with eg.

2

(c)  Differentiate between the following:

2

( i) DDL & DML commands.  (ii) in / between operator

 

(d) Describe the order by clause with syntax & example.

2

(e) A table ‘Customers’ in a database has 5 columns and no rows in it. What is its

2

cardinality? What will be its cardinality if 4 rows are added in the table?

 

Q4

 

(a) The following code has some errors. Rewrite the correct code :

 

int i,j=5;

2

i==j+5;

 

if(i=j)

 

{

 

jTextField1.setText(“i and j are unequal”);

 

jTextField2.setText(“they are not equal”); break;

 

}

 

else jTextField1.setText(“i and j are equal”);

 

(b) Write code to add an element (“New Course”) to a list (SubList) at the beginning

1

of the list.

 

(c) What will be the output produced by following code fragment?

2

flaot x=9;

 

 

float y=5;

 

int z=(int)(x/y); switch(z)

 

{

 

case1:        x=x+2;

 

case2:        x=x+3;

 

default:       x =x+1;

 

}

 

System.out.println(“value of x:”+x);

 

 

 

(d) Rewrite the following code using while loop:

2

 

int i,j; for(i=1,j=2;i<=6;i++,j+=2)

 

System.out.println(i++);

 

System.out.println(“Finished!!!”);

 

(e) Write a program in Java that takes a number and check if the number is prime or not. 2

 

(f) Write the expression to print the value of a variable "x" of type int in a label.

1

(g).

6( 2+2+1+1)

 

     

 

PRE-ANNUAL EXAMINATION

 

 

Informatics Practice ( CLASS XI)

 

 

 

SECTION A

 

Q1.

 

a) What does a bus mean? Why is data bus bi-directional?

2

b)What is a port? Name some port types.

2

c) define

2

 

 

(i) phishing

 

(ii)IDE

 

(iii)Software

 

(iv) firmware

 

d)What measures you would take to avoid

2

(i)  Spyware

 

(ii) PC Intrusion

 

e) Distinguish  between RAM and ROM?

2

Q2.

 

a) What benefits an e-business offers to a customer? What issues are till to be

care of?

2

 

b)Define

2

(i) e-learning

 

(ii) e-governance

 

c)Name any two e-business sites.

 

1

 

d) Name event listeners for the following actions:-

2

(i) a component receives capability to receive input i.e focus

 

(ii)key is pressed on the keyboard

 

e) Define

2

(i) Algorithm

 

(ii) Robustness

 

 

 

 

 

f) Method call in which data in actual parameter remains intact is known as ________? 1

 

Q3.

 

a) What is data redundancy? What are the problems associated with it?

2

b) Differentiate between DDL and DML commands.

2

c) How is round( ) function different from truncate( ) function? Explain giving

2

suitable example.

 

d) Write a query to create a string from  the ASCII values 70,65,67,69.

1

e) What is the following command doing?

1

ALTER TABLE persons ADD CONSTRAINT chk_Person

 

CHECK(P_ID>0 AND City=’Simla’);

 

f) Write command to display current date and time.

1

g) Differentiate between CHAR and VARCHAR.

1

 

SECTION B

 

Q4.

 

a) HSBC is a bank. The Bank provides three types of loans- Car loan, House Loan, Education Loan.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Read the following case study and answer the questions that follow:

 

Make a java swing frame as shown above and accept values through jTextFields. Perform

 

according  to following questions:

 

a.   Write the commands to show the interest rate according to the following criteria.:

2

Car loan – 10%

 

House Loan – 8.5%

 

Education Loan – 5%.

 

b.  Calculate the discount on the amount according to following criteria.

4

·  If amount > 10,000,00 and < 20,000,00 then 20% discount.

 

·  If amount > 20,000,00 then 25 % discount.

 

 

b) Write a for loop to find sum and average of n natural numbers, odd numbers, and even

 

numbers.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

 

c) Identify errors :

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(i) for(a=1,a>10,a=a+1)

 

 

 

 

 

 

 

 

 

(ii)while(i<j);

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

{

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

System.out.println(i*j);

 

 

 

 

 

 

 

 

 

 

 

 

 

i++;

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

}

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Q5.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

a) Find out output of the following code:

 

 

2

 

 

 

 

(i)

 

 

int i,j,n;

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

n=0;i=1;

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

do{

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

n++; i++;

 

 

 

 

 

 

 

 

 

 

 

 

 

 

}while(i<=5);

 

 

 

 

 

 

 

 

 

 

 

 

 

System.out.println(n);

 

 

 

 

b) Write a program using while loop to compute the sum of following series:

2

 

1+

1

+

1

+

1

+

1

+

 

1

+

 

1

+

1

+

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4

 

7

 

10

13

 

16

 

19

 

22

 

25

 

 

 

c) What will be the output of the following code:

2

 

 

 

 

int val, res, n=1000;

 

 

 

 

 

 

 

 

 

 

 

 

res = n+val>1750?400:200;

 

 

 

 

 

 

 

 

System.out.print(res);

 

 

 

 

 

 

 

 

 

(i) if the input given for val is

1000

 

 

 

 

(ii) if the input given for val is 500

 

d) Design GUI application that obtains Login ID and password and displays welcome  screen

 

if password is correct. (Note: write down steps to create GUI)                                    4

 

SECTION C

 

Q6.

a) Define:

 

 

 

4

 

(i) Cardinality

 

 

(ii) View

 

 

(iii) Primary Key

 

 

(iv) Degree

 

b) How would you calculate 13*7/2 in MYSQL?

1

c) Write a query to create database with name MYDB. Write a query to open the same

 

databse.

1

 

d) What are the commands to undo the changes and make the changes permanent?  2

 

e)  Write a command to increase the size of empname column to 50 characters in an emp table.

 

 

 

 

 

 

 

 

 

2

 

Q. 7. Answer questions based on the table Schoolbus given below :

 

 

 

 

 

 

Schoolbus

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Rtno

Area_Covered

Capacity

No_of

Distance

 

Transporter

 

Charges

 

 

 

 

students

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

VasantKunj

100

100

10

 

Shivam Tra

 

100000

 

 

 

 

 

 

 

 

 

 

 

2

Rohini

80

80

10

 

Anand Tr

 

55000

 

 

 

 

 

 

 

 

 

 

 

3

Saket

50

50

30

 

Bhalla Co.

 

95000

 

 

 

 

 

 

 

 

 

 

 

4

Yamuna Vihar

120

120

35

 

Speed Tr

 

10000

 

 

 

 

 

 

 

 

 

 

 

5

Saket

100

100

20

 

Raj Tr.

 

80000

 

 

 

 

 

 

 

 

 

 

 

6

Janak Puri

40

40

10

 

Yadav Co.

 

60000

 

 

 

 

 

 

 

 

 

 

 

a)

 

 

 

 

 

 

 

 

 

(i)Write a query to create above table with proper Integrity constraints.

 

2

 

 

(ii) Display RtNo, Area_Covered and charges for all the school buses.

 

1

 

 

(iii)Display all the details from above table in ascending order of Area_Covered

1

 

 

(iv) Remove column Area_Covered.

 

 

 

 

2

 

 

f) Increase the charges of Yadav Co. by 1000.

1

b) Write outputs of the following queries:

 

(i) Select Capacity, No_of_students from Schoolbus where charges>60000;

1

(ii) Select RtNo charges/4 “Quaterly Charges” from Schoolbus;

1

(iii) Select Transporter from Schoolbus where Area_Covered like ‘S%’;

1