CBSE Class – 12th Sample Paper Informatics Pratices - 2008
- Posted: 12:49 AM
- |
- Author: Vikas Ahlawat(Hi)
- |
- Filed under: Class – XII Sample Papers, Sample Papers
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=”
Y= “
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;
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
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***
Search-
Recent Comments-
Categories-
- AIEEE (1)
- Bank Exam (2)
- BCA (1)
- BE (2)
- Btech (2)
- CBSE Result (1)
- Chemistry (1)
- Class – 10th Sample Papers (6)
- Class – XII Sample Papers (2)
- CSE (1)
- Entrance Exam (1)
- Exam (1)
- IES Exam (1)
- MBA (2)
- MDU (4)
- Previous years Question Papers (10)
- Punjab technical University (1)
- Result (1)
- Sample Papers (7)
- Schools (2)
- Sikkim Manipal University (1)
- Solved Paper (1)
- Tips and Tricks (1)
- Top in india (1)
- UP Board (1)
About Me-
Lemon Twist Blogger Template is an extremely beautiful blogger template created by JackBook.Com based on Lemon Twist Wordpress themes by farfromfearless.com. You can edit this words into your own.
- Blogger Templates | Distributed by Blogger Blog Templates and FarFromFearless
- Back To Top
- Home