CBSE Guess paper class XII Informatics Practices 2008 2



GUESS PAPER - 2008

Class - XII

SUBJECT – INFORMATICS PRACTICES

Time: - 3.15 hrs M.M. - 70

Additional time of 15 minutes is given for reading and understanding the question paper not writing the answers.

General instruction:

1. The question paper consists of three parts. A,B and C.

2. All question are compulsory.

3. Use of calculator is not permitted.

1.

  1. Answer the following questions:

(a) Explain the terms S/W,H/W and firmware using suitable example.

(b) Explain the role of DBA.

(c) Explain the term client & server in client/server computing?

(d) What is an Information System?Name the building blocks of an Infor.system .

(d) What is the Entity Relationship model? Explain the concept of ER Model

using the case study of a school that has three entities STUDENT, TEACHER

and SUBJECT. Assume that each student can study more thanone subject while

each teacher can teach only one subject.

2

2

2

2

2

2.

(a) “VB is an object based event driven programming language”-explain. (b) Difference between MsgBox () & InputBox () functions in VB.

(c) How do we specify comments in VB? How do we break long line of code to a new line?

(d) What is parent form & child from?

(e) Difference between checkbox & option button.

(f) What is ADO data control? To whom you can connect this?

2

2

2

1

1

2

3.

Teach Well institute offers two postgraduate courses, one in computers and the other in Management. The students can avail certain optional facilities. The Basic Interface for accepting the details of facilities availed by a student is as follows:


Write the code and event procedures for incorporating the following functionality:

(a) The LIBRARY facility should be selected by default

(b) The default course choice should be Computers course.

(c) Whenever user selects the HOSTEL facility, the MESS facility should get selected automatically, which the user can deselect later if desired.

(d) Give that the charges for library, mess and hostel are Rs. 500, Rs.1500and Rs. 2000 respectively per month. Write a function that calculates The charges per semester, for the facilities availed.

(e)The function should be called when user clicks the calculate button and the results should be displayed in message box.

1

1

2

4

2

4

(a) Rewrite the following code segment using Select...Case instead of if...else...end if.

if marks >= 85

msgbox "Excellent"

elseif marks >= 60

msgbox "Above Average"

elseif marks >= 50

msgbox "Average"

Else

msgbox "Need to work harder"

End if




(b) Write an application to enter your name (string) and reverse it.

(c) Write a program to finds the sum of ‘n’ natural numbers using recursion function.


5

a. Differentiate between COMMIT and ROLLBACK command of SQL.

b. Find the output of the command given below:

i. SELECT NEXT_DAY(’01-JUN-2006’,’FRIDAY’) FROM DUAL;

ii. SELECT ROUND(1023.432,1) FROM DUAL;

c. Write SQL commands for the queries (i) to (vi) and write the output of the SQL commands given in part(vii) based on a relation SHOP shown below:

No

Shop_Name

Sale

Area

Cust_percent

Rating

City

1

S. M. Sons

250000

West

68.6

C

Delhi

2

Dharohar

500000

South

81.8

A

Mumbai

3

Kriti Art

300000

North

79.8

B

Kolkata

4

Ripple

380000

North

88.0

B

Mumbai

5

Biswas Stores

456000

East

92.0

A

Delhi

6

Crystal

290000

South

66.7

A

Kolkata

i. To display the names of all shops which are in the south.

ii. To display name and customer percentage of all the shops having cust_percent>80.

iii. To display list of all the shops with sale>300000 in ascending order of shop_name.

iv. To display a report with shop_name, area and rating for each shop in the table, for only those shops whose sale is between 350000 and 400000 (including both 350000 and 400000).

v. To display the city and the number of shops in each city in the table SHOP.

vi. To insert details of a new shop in the table SHOP with the following data:

7, “The Shop”,550000,”South”,90.8,’A’,”Ahmedabad”.

vii. Write the output of the following:

a. Select Min(Cust_percent) from SHOP;

b. Select Sum(Sale) from SHOP where Rating=’A’;

c. Select Avg(Sale) from SHOP where City=”Delhi”;

d. Select Count(Distinct City) from SHOP;

d. What is the purpose of GRANT and REVOKE statement?

e. Explain the usage of the %TYPE attribute in variable declaration in a PL/SQL block with the help of an example.

f. What is the variable scope of block object?

1

2

4

1

1

1

6

a. Find the output of the following PL/SQL block:

DECLARE

NUM1 NUMBER:=0;

NUM2 NUMBER:=1;

NUM3 NUMBER:=1;

ANUM3 NUMBER;

AVG_COST NUMBER:=1;

AVG_BUY_COST NUMBER;

SENT NUMBER;

STR1 VARCHAR230);

CHR1 CHAR(10);

MALE VARCHAR2(30);

BEGIN

NUM1 :=NUM1+NUM2+(NUM3*3);

ANUM3 :=AVG_COST*7+NVL(AVG_BUY_COST, 0);

SENT :=1;

STR1 :=’No rest until one=’||TO_CHAR(SENT);

CHR1:=’ABCDEFG’;

MALE :=UPPER(SENT);

DBMS_OUTPUT.PUT_LINE(NUM1||’ ‘||ANUM3 || ‘ ‘||MALE);

END;

b. What are the guidelines to declare the variables?

c. How does a PL/SQL block executed?

d. Differentiate between char and varchar2.

e. Consider the structure of employee table and write PL/SQL code to increase the salary of all the employees by some percentage amount accepted from the user.

Column Name

Data Type

Size

Constraint

EmpID

NUMBER

6

PRIMARY KEY

EmpName

VARCHAR2

20

NOT NULL

EmpAddress

VARCHAR2

30

EmpPhone

VARCHAR2

10

EmpSal

Number

9.2

2

2

1

1

4

7

a. Write a PL/SQL for loop to print the numbers from 1 to 10 with single space in one line.

b. A table TEMP of the company stores the data of the employee habving the following fields:

Code, Name, Salary, DA, HRA and Perk. The Company has decided to give a fixed perk Rs.1000 to each employee. The DA and HRA will be given as following:

Salary

DA

HRA

(i)

Less than 2500

(ii)

Greater than equal to 2500 nut less than 4000

45%

15%

(iii)

Greater than equal to 4000 nut less than 8000

48%

20%

(iv)

Greater than 8000

50%

30%

Calculate the gross salary of an employee as salary, DA, HRA and Perk.

c. Which cursor attribute tells you that a cursor is opened or not?

d. List parts of Triggers.

e. Consider the Sales table with following specification:

JOB VARCHAR2(9) primary key

MINSAL NUMBER(7,2)

MAXSAL NUMBER(7,2)

And the EMPLOYEE table as shown:

Table: EMPLOYEE

FieldName

FieldType

Constraint

EMPNO

VARCHAR2(4)

Not null primary key

ENAME

Varchar2(20)

JOB

Varchar2(9)

MGR

Number(4)

HIREDATE

Date

SAL

Number(7,2)

COMM

Number(7,2)

DEPTNO

Number(2)

Foreign Key

Write an after insert or update trigger check_salary_EMP which check the salry in EMPLOYEE table as follows:

  • if the entered salary less than or greater than the range of SAL table, then raise an application error ‘Salary range Exceeded’.
  • If new salary less than the old salary then ‘Salary has been decreased’.
  • If new salary more than the old salary then ‘More than 10% salary increase’.

What happen when you insert the row:

Insert into emp values(1,’ssss’,’Clerk’,2341,’10-Apr-2005’,1800,12,10);

2

2

1

1

4

**********

*****

**********

 

iCBSE India