CBSE Class – 12th Sample Paper Informatics Pratices - 2008

General instructions

Read all the questions carefully

All questions are compulsory

Section A contains 30marks, section B and section C contains 20 marks each

Section A

Q1.

(i) Define the following terms 1x5

a. Scope of a variable

b. Lifetime of a variable

c. Parameter

d. Procedure

e. Module

(ii) Differenciate between the following: 2x3

a. SDI and MDI

b. Implicit and explicit declaration of a variable in VB

c. Picture box and image control

(iii) Define the following: 1x4

a. normalization

b. primary key

c. data modal

d. data dictionary

Q2.

(i) You have changed the back color property of OK button to Red but still default color is appearing on the button which property you need to set and what value. 2

(ii) A command button named cmdnext should change its caption to “FOCUS” and becomes enabled when receives the focus. It should again change its caption to “LOST” and become disabled when loses the focus. Design the events to the get the above requirements. 4

Q3.

(i) Write a PL/SQL block for finding out whether a given number is prime number or not. 3

(ii) Explain the limitations of numeric for loop using one example. 4

(iii) Write any two commands of DDL 2

Section B

Q4.

(i) Identify the implicit and explicit variable declarations in the following statements. 2

dim a as integer, b as integer

mesg= “work hard to get good marks”

a= inputbox (“enter no”)

print a, msk

(ii) Examine the code workout what the ‘result’ variable will hold? 2

Dim x as string, y as string, z as string

Dim result as string

X=”KUSH

Y= “Sandy

Z= “”

Result= x & “and” & y

(iii) write a program for displaying the following pattern 3

*

* *

* * *

* * * *

(iv) Write a program for reading values in a array whose size will be specified by the user. 3

Q5.

(i) write a function procedure which will read two parameters of integer type, if the first parameter is divisible by the 2nd parameter the return true else return false. 4

(ii) design a login window which will check for username as RAJ and password as PRACTICES and display the second form frm2 , when correct username and password is provided else display a message “ACCESS DENIED “ on a message box. 2

(iii) Write a procedure will take newvalue and position as parameter, which are of integer type, insert the new value in the specified position in an array. 4

Section C

Q6.

(i) Find out the errors in the following code:

(a) Declare 2

A as number;

B A%type;

Begin;

A=10;

Loop

Dbms.output.put_line(B);

A:= A+1;

End loop;

End;

(b) Declare 3

A number;

B emp%type;

C number;

Begin

A := &enter no;

Select job into c where empno= A;

For I in 4….5

Loop

I:=I+1

Dbms_output.put_line (I);

End loop;

C:=I;

End.

(ii) find out the output of the following code

(a) Declare 2

begin

for I in 1..5

loop

dbms_output.Put(I);

End loop;

(b) Declare 3

a number;

b number;

c varchar2(3);

begin

a:= &enter_no;

b:= &enter_no1;

c:= ’&enter_operator’;

if c= ‘+’ then

dbms_output.put_line(a+b);

elsif c=’-‘ then

dbms_output.put_line(a-b);

elsif c= ‘*’ then

dbms_output.put_line(a*b);

elsif c= ‘/’ then

dbms_output.put_line(a/b);

else

dbms_output.put_line(‘wrong math operator’);

end if;

end

find out the output for the above code when (i) a=5, b=8 and c= *, (ii) a=3 , b=4 and c= -

Q7.

(iv) write a sql command for creating a table student who structure is given below 2

Field name

Datatype

Size

constraint

Rno

Number

3

Part of primary key

Class

Varchar2

5

Part of primary key

Percentage

Number

5,2

>0 and <=100

(ii) Write a command for adding a field remarks to the above created table whose data
type is varchar2 and size is 40 with not null constraint. 2

(iii)Write a command for creating view student1 on the student table which contain those student records who got 75 and above percentage. 2

(iv) Write command for giving select and update privileges on the above table to the demo user with grant option. 2

(v) Write command for removing view student1 from the database. 2

***All The Best***

0 people have left comments

Commentors on this Post-