Question-Papers XI

CLASS –XI (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.

Special Instructions:

1.     While answering your Questions, you must indicate on you Answer-book the same Question No. as appears in your Question Papers.

2.     Do not leave blank page/pages in your Answer-book.

3.     All the questions are compulsory.

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

      i.        Floppy disk is the Primary storage device.

     ii.        It is not necessary to delete all files of a directory to delete that directory.

    iii.        Menu bar contains a set of tools to provide controls in the form.

    iv.        Debug window is same as code window.

     v.        String is a data type that can be used to declare a text of maximum 10 million characters.

    vi.        VB requires parenthesis around a relational test.

   vii.        The load command places the form in memory and displays on screen.

  viii.        A Primary key is a candidate key.

    ix.        SQL is a procedural language.

     x.        SQL statements must be written in one line.

2. 

a)     Distinguish between Volatile and Non-volatile memory.

b)    Distinguish between Interpreter and Compiler.

OR

a)     What do you mean by Operating System? What are its various type?

b)    Define Window. Give some of its features.

3.

a)     What do you mean by High level language? What are its advantages and disadvantages?

b)    Define a variable, a literal and a constant. What is the need for variable in VB ?

OR

a)     What is Industry? Discuss various types of Industries.

b)    What is Programming? Name the steps that are required for developing Program.

4.

a)     Discuss different tools available in Visual Basic.

b)    Explain the various decision making statement in VB.

c)     What are the different options Menu Editors? Explain.

5.

a)     Explain the Pop-up and Short-cut menu.

b)    How we can create Window application in VB?

OR

a)     What is SQL? What are the different categories of commands available in SQL?

b)    Define DDL commands. What are the functions of DDL commands?

6.

a)     Define the basic data types in SQL.

b)    Explain the following SQL functions (Any four) :

                      i.        UPPER()

                     ii.        TRIM()

                    iii.        TRUN()

                    iv.        SUM()

                     v.        MIN()

                    vi.        MOD()

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.

Question-Papers X

CLASS –X (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.        FTP stands for File Transfer Protocol..

     ii.        We can chat on Internet.

    iii.        Spell check can be applied in MS-Access.

    iv.        <title> is a container element.

     v.        A validation rule defines structure of a table.

    vi.        Tag <BR> is used to start new lines.

   vii.        Forms are mainly used in filling up the data.

  viii.        Client computer is the base computer from where you can access the Internet.

    ix.        HTML allows both static and dynamic text to be displayed.

     x.        There can be multiple primary keys in a table.

2. 

a)     Write the difference between Uploading and Downloading.

b)    What is Telnet? What are its uses ?

OR

a)     What is video conferencing? Explain.

b)    What do you mean by chatting ?

3.

a)     What is the function of Table Wizards?

b)    What are Newsgroups?

OR

a)     Briefly explain the following :

                      i.        Reports

                     ii.        Queries.

b)    What do you mean by Data Validations ?

4.

a)     What are the uses of HTML ? How are HTML tags written ?

b)    What do you mean by Empty Elements ?

OR

a)     Write HTML code to display the following in exactly the same way as written here :

                      i.        Tomatoes

                     ii.        Pineapples

                    iii.        Lady finger

                    iv.        Lemons.

b)    How will you make text coloured ?

5.  Write the purpose of following tags (Any four)

                      i.        <TILE>

                     ii.        <CODE>

                    iii.        <STRONG>

                    iv.        <BR>

                     v.        <HEAD>

                    vi.        <VLINK>