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. |
(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 | 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:
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( c. Select Avg( 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.
| 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:
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
Write an after insert or update trigger check_salary_EMP which check the salry in EMPLOYEE table as follows:
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 |
**********
*****
**********
