Information Practices Model Question Paper www.jac.nic.in : Jharkhand Plus Two / 12th Std / +2

[mariammal]

Document Described : Information Practices Question Paper, Jharkhand Question Paper

INFORMATION PRACTICES
Full Marks - 70
Pass Marks - 23
Time - 3 Hours
All questions are compulsory.
Candidates are required to give their answers in their own words as far as practicable.
Figures in the margin indicate ful marks.

http://jac.nic.in/model_questions.htm
http://jac.nic.in/pdf/model_question...tices12_08.pdf

SECTION : A
1. Answer the folowing questions :
(a) Define ?Front-end? and ?Back-end? of an Information System. 2
(b) Expand the term SDLC. Name its essential components. 2
(c) Give any four application areas of database. 2
(d) Name any four application areas where business computing can be used. 2
(e) Define ?Information System?. What are Information System Building Blocks ? 2

2. Answer the folowing questions :
(a) Differentiate between Do While ? loop and Do?loop While. 2
(b) What are conditional or decision control statement ? Name the two conditional statement of VB. 2 Conditional `m Decision control statement
(c) What is Focus ? When do GotFocus and LostFocus event occur ?
(d) Differentiate between SDI Form and MDI Form. Explain the concept of Parent and Child forms. 2 SDI Form Ed§ MDI Form
(e) Explain the terms ODBC and OLE-DB.

3. Answer the folowing questions :
(a) What is Cursor in PL/SQL ? List any two commands that are associated with cursor control. 2
(b) Differentiate between Row Level and
Statement level triggers in PL/SQL. 2
(c) Define ?SQL?. Name the different SQL Subcategories (give ful form). 2
(d) Explain IN operator in Procedure of SQL.
(e) What is NULL value ? What is the result of an arithmetic operation containing NULL value ? 2

SECTION : B
4. Answer the folowing questions :
(a) A student wants to write the procedure to find if a given year is a leap year or not. He had written the following code
segment and he is unable to correct some of the errors in the code. Find the errors and rewrite the corrected code
underlining the correction made. 2

Note : a leap year is a year which is divisible by 4 and 400. Program code to check if a year is a leap year or not.
Private Sub cmdLeapyear_Clicking ()
Y = Val (txtYear)
IF Y Mod 100 =0 AND Y Mod 400 =0
MsgBox ?It is a leap Year?
ELSEIF Y Mod 4 = 0
MsgBox ?It is a Leap Year?
ELSE MsgBox ?It is not a leap Year?
Sub End
Private Sub cmdLeapyear_Clicking ()
Y = Val (txtYear)
IF Y Mod 100 =0 AND Y Mod 400=0
MsgBox ?It is a leap Year?
ELSEIF Y Mod 4 = 0
MsgBox ?It is a Leap Year?
ELSE MsgBox ?It is not a leap Year?
Sub End

(b) Find the output of the folowing code :
Private Sub cmdClick_Click ()
Dim N1, N2, Counter as Integer
Counter = 1
N1 = 0
N2 = 1
Do While Counter <= 4
Print N1
Print N2
N1 = N1 + N2
N2 = N2 + N1
Counter = Counter + 2
Loop
End Sub

Private Sub cmdClick_Click ()
Dim N1, N2, Counter as Integer
Counter = 1
N1 = 0
N2 = 1
Do While Counter <= 4
Print N1
Print N2
N1 = N1 + N2
N2 = N2 + N1
Counter = Counter + 2
Loop
End Sub

(c) Find output of the following code segment : 2
Private Sub cmdClick_Click ()
Dim Num as Integer, Dig as Integer,
Sum as Integer
Num=234567: Sum = 0
Do While Num > 0
Dig = Num Mod 10
Sum = Sum + Dig
Num = Num / 10
Loop
Print Sum
End Sub

Private Sub cmdClick_Click ()
Dim Num as Integer, Dig as Integer,
Sum as Integer
Num=234567: Sum = 0
Do While Num > 0
Dig = Num Mod 10
Sum = Sum + Dig
Num = Num / 10
Loop
Print Sum
End Sub

(d) Write a Visual Basic function that takes an integer argument N and returns the sum of al even and odd numbers less than the given number N. 4
5 ) (a) Write the code to disable the textboxes txtAmount in the form load event of frmInterestCalc. 2
(b) Write the code for cmdClear Command Button to clear al the textboxes and set default choice in the Option Button as 5 years. Also set the focus to txtPrinciple.
2
(c) Write the code for the Change event of the textboxes txtPrinciple and txtRate to
(d) Write the code for the Click event of the command button cmdCalculate to calculate the compound interest and amount depending on the principle, rate and time. The compound interest is calculated as
P* (1 + R / 1 0 0) ^ T and amount as
(Principle + Compound Interest). 4

SECTION : C
6. Answer the questions based on the table Employee given below :
Table : Employee
Column Name Data Type Size Constraint Description
Emp_ID NUMBER 8 PRIMARY KEY Employee?s Identification
Number
First_Name VARCHAR2 25 NOT NULL First Name of Employee
Last_Name VARCHAR2 25 Last Name of Employee
Date_Join DATE Date of Joining
Basic_sal NUMBER 8.2 Basic Salary
Dept_ID NUMBER 3 Depart Number
Emp_ID NUMBER 8 PRIMARY KEY
First_Name VARCHAR2 25 NOT NULL
Last_Name VARCHAR2 25
Date_Join DATE
Basic_sal NUMBER 8.2 _yb doVZ
Dept_ID NUMBER 3
(a) Write the SQL command to create the table Employee including its constraints.
2
(b) Write the SQL command to display first name, date of joining and department ID
of employees who are hired between March 20, 1991 and December 31, 1991.
Order of the query in descending order of the date of joining. 2
(c) Write the procedure that adds First name and Last name (both passed as parameter) in employee table along with
unique Emp_ID. The ID should be calculated as existing last ID (generaly maximum id) +1. 2
(d) Write a PL/SQL Block to determine whether the salary (field Basic_Sal) of
Emp_ID 2763 in Employee Table is less than 7500 or not. If it is, give an
increment of 15% otherwise display a message ?No increment given?. 4
7. Read the questions given below and answer accordingly :
(a) Write the output produced by the folowing part of code in PL/SQL. 2
DECLARE
COUNT NUMBER := 10;
SUM NUMBER:= 0;
BEGIN
LOOP
SUM:= SUM+COUNT;
DBMS_OUTPUT.PUT_LINE(TO_CHAR (SUM);
COUNT:=COUNT ? 2 ;
IF COUNT = 2 THEN
EXIT ;
END IF
END LOOP ;
END ;
output H$mo {bI| ?
DECLARE
COUNT NUMBER:= 10;
SUM NUMBER:= 0;
BEGIN
LOOP
SUM:= SUM+COUNT;
DBMS_OUTPUT.PUT_LINE(TO_CHAR (SUM);
COUNT:=COUNT ? 2 ;
IF COUNT = 2 THEN
EXIT ;
END IF
END LOOP ;
END ;
(b) Consider the Emp table given below and give the output produced by the folowing
PL/SQL code: 2
EMPNO ENAME DEPTNO SAL
7839 KING 10 5000
7782 CLARK 10 2450
7934 MILLER 10 1300
7788 SCOTT 20 3000
7902 FORD 20 3000
7566 JONES 20 2975
7876 ADAMS 20 1100
7369 SMITH 20 800
7698 BLAKE 30 2850
7499 ALLEN 30 1600
78444 TURNER 30 1500
DECLARE
Sum_Sal Emp.Sal%TYPE;
S_Sal Emp.Sal%TYPE:= 2000;
S_Dept Emp.deptno:= 20;
BEGIN
SELECT SUM (SAL) INTO Sum_Sal FROM
Emp WHERE Deptno = s_dept AND Sal>S_Sal ;
Dbms_output.put_line (To_CHAR (Sum_sal) ;
END ;
ZrMo
EMPNO ENAME DEPTNO SAL
7839 KING 10 5000
7782 CLARK 10 2450
7934 MILLER 10 1300
7788 SCOTT 20 3000
7902 FORD 20 3000
7566 JONES 20 2975
7876 ADAMS 20 1100
7369 SMITH 20 800
7698 BLAKE 30 2850
7499 ALLEN 30 1600
78444 TURNER 30 1500
DECLARE
Sum_Sal Emp.Sal%TYPE;
S_Sal Emp.Sal%TYPE:= 2000;
S_Dept Emp.deptno:= 20;
BEGIN
SELECT SUM (SAL) INTO Sum_Sal FROM
Emp WHERE Deptno = s_dept AND Sal>S_Sal ;
Dbms_output.put_line (To_CHAR (Sum_sal) ;
END ;
(c) Differentiate between the IN and OUT parameters of a PL/SQL Procedure. 2
(d) Write a PL/SQL Function Power that takes two numbers as arguments and returns the value of the first number raised to the power of the second. 4