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>

Start Your Practice

From the beginning to the end, the complete session of practice should be divided into five parts.

Part(i):  Take your first test with previous paper without taking time into consideration. Try to solve all questions. Note down the total time and score in your performance diary. Also note down the questions which took more than one minute. Now you have to find out the reason of your low performance, if it is so. Naturally, you would find the following reasons:

• ·         Some questions were difficult and time-consuming
• ·         Some questions were unsolvable for you.
• ·         You lost your concentration.
• ·         You lost your patience.
• ·         You did more writing job.
• ·         You could not use Quicker Methods.

Try to find out the solutions to all the above problems. If any of the questions was difficult for you, it means your initial preparation was not good. But don’t worry. Go through that chapter again and clear your basic concept. Because the standard of question is always within your reach. If you have passes your 10^th exam with maths, you can solve all the questions. You should take at least 10-12 tests in this part.

Part(II): This time the paper may be either previous or model (sample). Fix your allotted periods (say 50 minutes for PO). And solve as many questions as possible within that period. Once you have completed your test, count the number of correct questions. Note down the number of questions solved by you and the no. of correct solution in your performance diary. Now you can find the reasons for your low scoring. If the reasons are the same as in 

Part (i), you try to resolve the problem again. Take at least 5-6 tests in this part. After analyzing your performance and problems you should be ready for your third part of test.

Part(III): This time you try to solve all the questions within a time period fixed by you in advance. This period should be less than that for the test in 

part (II). If you couldn’t do it, try it again on another test paper. 

Part(III) should not be considered completed unless you have achieved your goal.

Part(IV): After completion of part(III), you need to increase your speed. This part is penultimate stage of your final achievement. You should try to solve the complete paper of maths within a minimum possible time (say, 30-35 minutes for PO paper). This part may take 3 to 4 months. Keep patience and go on practicing.

Part(V): This is the last  part of your practice. After part(IV), you should take your test with complete full-length paper(225 questions for PO).