Question-Papers XII

CLASS –XII (H.P.)

INFORMATICS PRACTICES

PAPER -2013

Theory

Time allowed: 3 Hours                                                                         Maximum Marks: 60

Candidates are required to give their answers in their own words as far as practicable.

Marks allotted to each question are indicated against it.

Note:  All questions are compulsory.

1.  State whether the following statements are true or False:

      i.        OSS stands for open source software.

     ii.        A Data Dictionary is not an essential part of a DBMS.

    iii.        Visual Basic is an event driven language.

    iv.        There is no difference between Standard modules and Class modules.

     v.        The Do-loop while and Do-while are identical in all respects.

    vi.        Len function determines the length of a string.

   vii.        A NULL value is same as zero.

  viii.        Oracle does not support PL/SQL

    ix.        Two kind of cursors are sued in Oracle as Implicit and Explicit.

     x.        PL/SQL block can consist of upto six sections.

2.

a)     Differentiate between Proprietary software and Free software.

b)    What do you mean by Inventory Control System?

OR

a)     What do you mean by System Development Life Cycle?

b)    Differentiate between E.R. modeling and Object modeling.

3.

a)      What do you mean by If-then else structure? Explain with example.

b)      What do you mean by User defined functions? Explain.

OR

a)      What do you mean by Procedure? What are their uses?

b)      What do you mean by Data Control? How does Data Control work?

4.

a)      Explain the following functions in VB :

                                  i.            Lcase()

                                 ii.            Now()

                               iii.            Int()

                               iv.            Right()

b)      What do you mean by Single Document Interface (SDI)?

c)       What is the difference between Data Control and Data Bound Control? Explain

5.

a)      What is the significance of NULL values? Explain.

b)      What is the classification of SQL commands?

OR

a)      What do you mean by TCP/IP? Explain.

b)      What do you mean by Database transaction? Explain its properties also.

6.

a)      Explain different Data types used in PL/SQL?

b)      What is the difference between BEFORE and AFTER triggers?

c)       Explain the following Cursor attributes :

                                 i.            % Found

                               ii.            % is open.