[go: up one dir, main page]
Scribd
Upload
52 views9 pages

12 Informatics Practices Sample Papers 2010 1 Ms

This document contains a sample question paper for the subject Informatics Practices (Theory Code : 065) with a total of 100 marks. It is divided into 3 sections - Section A carries 30 marks, Section B and Section C carry 20 marks each. Section A contains 5 multiple choice questions. Section B contains 5 questions related to programming concepts like events, control structures, functions etc. Section C contains 3 questions on PL/SQL concepts like creating tables, views, functions, procedures etc.

Uploaded by

Vr Magesh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
52 views9 pages

12 Informatics Practices Sample Papers 2010 1 Ms

This document contains a sample question paper for the subject Informatics Practices (Theory Code : 065) with a total of 100 marks. It is divided into 3 sections - Section A carries 30 marks, Section B and Section C carry 20 marks each. Section A contains 5 multiple choice questions. Section B contains 5 questions related to programming concepts like events, control structures, functions etc. Section C contains 3 questions on PL/SQL concepts like creating tables, views, functions, procedures etc.

Uploaded by

Vr Magesh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

Informatics Practices (Theory Code : 065)

Marking Scheme
Sample Question Paper - I
TIME : 3 Hrs

MM : 100

Note
1.

This question paper is divided into 3 sections.

2.

Section - A consists of 30 marks.

3.

Section - B and Section - C are of 20 marks each.

4.

Answer the questions after carefully reading the text.

No.

Answers

Marks

SECTION - A
Q 1.
(a)

i)

Open Source Software

ii)

GNU's Not Unix

iii)

World Wide Web Consortium

iv)

Free Open Source Solutions

( Mark each for full form of each term)


(b)

The front-end is the part of a software system that interacts directly with the user, and
the back-end comprises the components that process the output from the front-end.

( 2 Marks for correct comparison)


(c)

Data mining can be used by financial companies to rank customers on the basis of
past payment behavior. This helps the companies to decide whether or not to
approve further loans , credit cards etc.

( 2 Marks for correct answer)


(d)

The purpose of feasibility study is to assess the viability of the proposed system.
During the feasibility study, projects are typically evaluated in areas of economical,
operational, and technical feasibility. The outcome of the feasibility study indicates
whether or not to proceed with the proposed system.

( 2 Marks for correct answer)


(e)

One to one and many to one relationship

10

No.

Answers

Marks

(1 Mark for identifying the type of relationship)


(1 Mark for ER diagram)
Q2
(a)

ORACLE

Microsoft SQL or MySQL


Microsoft Access
Firebird
DB2
Sybase
(1mark each for naming any two correct RDBMS)
(b)

SQL is the Structured Query Language used to interact with the RDBMS.
The SQL Subcategories are:
DML (INSERT, UPDATE, DELETE)
DDL (CREATE TABLE, DROP TABLE, ALTER TABLE)
DCL (GRANT, REVOKE)
TCL (COMMIT, ROLLBACK)
(1mark for the correct definition of SQL)
( mark each for correctly naming any 3 subcategories)
( mark each for the correct command in each category (Only one command in
each category))

(c)

Decision Control

Looping Control

1. Decision control structures are used


to implement decisions based on
conditions. We check the condition
and allow to execute code if the
condition is found true else some
other set of code is executed. This
can be achieved using If then Else

1. Looping means iterations or


repetition of some set of code. The
same set of code can be executed
more than once on entering into
the Looping Construct.

11

No.

Answers

Marks

End if command in PL/SQL.


2. Decision Control Structure in PL/SQL
are

2. Looping Control in PL/SQL are

IF .. THEN..ENDIF statement

Basic LOOP

IF .. THEN ..ELSE..ENDIF statement

FOR Loop

IF .. THEN .. ELSIF..ENDIF statement

WHILE Loop

If <Condition> Then
<Executable Statements>
Else
<Executable Statements>
End If
3. In decision control, statement(s) is/are executed maximum one time only
whereas in loops statement(s) is/are executed more than one time
(2 marks for correct difference)
(1 mark each for command of control structure)
Q.3
(a)

An event represents the state of the keyboard keys, the location of the mouse, and
the state of the mouse buttons, which occurs as the result of user interaction with an
element.

For example, when a user clicks a button, an event is generated.


Visual Basic is one example of an event driven programming language.
(1 mark for the correct definition)
(1 mark for naming the language)
(b)

MsgBox ()

InputBox ()

1. As the name explains it's a


mechanism to show a small dialog
box, which pops up over the existing
application for displaying custom
messages.

1. The InputBox is for displaying a


message along with collecting
User Inputs.

2. Message Box can also be used to


gather user responses but they are
limited to the user actions such as
whether the user has Clicked OK

The Input Box gathers user data on


string form.

12

No.

Answers

Marks

button, or Cancel Button or Yes button


or No button etc.
Example

Example

MsgBox "Hello User"

Dim Age
Age=InputBox ("Enter Age")

(2 marks for any two correct differences)


(1 mark for each example)
(c)

ADODB

ADO DC

It is an object library available in visual


basic and a reference can be added by
going to the menu Project > References.

It is a data control like other controls


available in the toolbox. This control
can be added by going to the Menu
Project > Components.

ADODC is class library.

ADODC is just a data control,

Ex: Programmer Controlled Navigation


of Data from table

Ex:This control does pre-defined


navigations Move First, Move Last,
Move Next, Move Previous

(2 marks for any two correct differences)


(1 mark for each example)
Section - B
Q4.
(a)

&Check Status

( mark for '&' symbol)


( mark for the text 'Check Status')
(b)

On Click event of the cmdCloseMe button write the following:

END
( mark for mentioning the event or writing the equivalent code for it)
( mark for the code)
(c)

On KeyPress Event write the following code fragment:


If Not(IsNumeric(txtDD.Text)) Then

13

No.

Answers

Marks

Msgbox ("Please enter numbers only")


End If
(2 marks for the correct validation using the IF statement)
(1 mark for displaying a message using the MsgBox)
( mark for End If)
(d)

Procedure Coding:
Dim strDate as String

strDate = trim(txtDD.Text) & "-" & trim (txtMM.text) &"-"& trim(txtYYYY.text)


If Not IsDate(strDate) Then
MsgBox "Please Enter a Valid Date"
txtDD.Text = ""
txtMM.Text=""
txtYYYY.text=""
txtDD.SetFocus
End If
(1 mark for extracting the value from the textbox)
(1 mark for the correct validation using the IF statement)
(1 mark for displaying a message using the MsgBox)
(1 mark for clearing the textboxes)

Q5.
(a)

Hello

10
450
Bye
( mark for each correct line of output)
(b)

SELECT CASE Total

CASE IS>=75
Grade = "A"

14

No.

Answers

Marks

CASE 50 TO 74
Grade = "B"
CASE 33 TO 49
Grade = "C"
CASE ELSE
Grade = "D"
END SELECT
( mark for SELECT statement)
( mark for case value)
( mark for CASE ELSE statement)
( mark for END SELECT statement)
(c)

Corrected code:

DIM Total AS INTEGER


Total=30.0
DO WHILE Total>=20
Total=Total-5
LOOP
PRINT Total
( Mark each for identifying and correcting each of four errors)
(d)

FOR Num = 1 TO 5
PRINT Num
NEXT Num
( mark for using correct control variable)
( mark for using correct initial value)
( mark for using correct final value)
( mark for NEXT statement)

(e)

Output:

Tech and Kids


False

15

No.

Answers

Marks

110
7
( mark for each correct line of output)
Section - C
Q6.
(a)

Code:

CREATE TABLE Employee (


EmpID

NUMBER (6)

PRIMARY KEY,

EmpName

VARCHAR2 (20)

NOT NULL,

EmpAddress

VARCHAR2 (30),

EmpPhone

VARCHAR2 (10),

EmpSal

NUMBER (9,2))

( mark for CREATE TABLE )


( mark for fields with data types)
( ma rk for PRIMARY KEY constraint)
( mark for NOT NULL constraint)
(b)

Code:

BEGIN
UPDATE EMPLOYEE;
SET EmpSal = EmpSal+EmpSal * &SAL_PER/100;
END;
(1mark for UPDATE Employee statement)
(1 mark for correct SET statement)
(2 marks for using the correct expression to increase salary)
(c)

Code:

DECLARE
V_Sal EMP.SAL%TYPE;
CURSOR C_Emp IS SELECT SAL FROM EMP;

16

No.

Answers

Marks

BEGIN
OPEN C_Emp;
LOOP
FETCH C_Emp INTO V_Sal;
V_Sal := V_Sal * 1.1;
EXIT WHEN C_Emp%NOTFOUND;
DBMS_OUTPUT.PUT_LINE (' Raised Salary is: ' || V_Sal);
END LOOP;
CLOSE C_Emp;
END;
(1 mark for creating the Cursor)
(1 mark for the loop)
(1 mark for using DBMS_OUTPUT.PUT_LINE)
(1 mark for correct expression for increase of Salary)

Q7.
(a)

Code:
CREATE VIEW VU_EMP AS

2
SELECT EName, Dname, Job , Sal
FROM Emp, Dept
WHERE Emp.DeptNo = Dept.DeptNo
AND Emp.DeptNo IN (10,20);

( Mark for CREATE VIEW command)


( Mark for SELECT statement)
(1 Mark for WHERE clause)
(b)

Code:

CREATE OR REPLACE FUNCTION FindBonus (V_Amount IN NUMBER)


RETURN NUMBER AS
V_Bonus NUMBER;
BEGIN

17

No.

Answers

Marks

V_Bonus := V_Amount * 1.2;


RETURN V_Bonus;
END;
Example of use:
SQL> SELECT Ename, FindBonus(Sal) FROM Emp;
(1 mark for correct function header)
( mark for correct positions of BEGIN and END)
(1 mark for correct calculation expression)
( mark for RETURN)
(1 mark for Example)
(c)

Code:

CREATE OR REPLACE PROCEDURE RAISE_SALARY


(V_EmpNo EMP.EMPNO%TYPE, SAL_PERCENTAGE NUMBER)
AS
V_SAL NUMBER (10,2);
BEGIN
UPDATE EMP
SET SAL= SAL+(SAL*(SAL_PER/100))
WHERE EMPNO = V_EMPNO;
SELECT SAL INTO V_SAL
FROM EMP
WHERE EMPNO = V_EMPNO;
DBMS_OUTPUT.PUT_LINE ('The New Salary is : ' || V_SAL);
END;
(1 mark for correct Procedure header with required parameters)
(1 mark for correct UPDATE statement)
(1 mark for correct SELECT statement)
(1 mark for displaying the changed value of salary)

18

You might also like