Download SGBAU BSc 2019 Summer 3rd Sem Computer Application Visual Basic n RDBMS Question Paper

FirstRanker.com

A Firstranker's choice

B.Sc. Part-II (Semester-III) Examination

--- Content provided by FirstRanker.com ---

COMPUTER APPLICATION (VOC.) (OLD)

(Visual Basic and RDBMS)

Time : Three Hours] [Maximum Marks : 80

Note :— ALL questions are compulsory.

1. 1. Fill in the blanks (% mark each) : 2
      1. An _______ is an activity performed by user towards application.

      --- Content provided by FirstRanker.com ---

      2. The _______ operators lets you combine two or more sets of conditional expressions.
      3. The number of tuples in relation called as _______
      4. _______ is used to add one or more columns in a table.
   2. Choose the correct alternative : 2
      1. _______ property determines how the command button responds to ESC key.
         1. Default

         --- Content provided by FirstRanker.com ---

         2. Name
         3. Caption
         4. Cancel
      2. The _______ helps you design menus for your application.
         1. Menu Bar

         --- Content provided by FirstRanker.com ---

         2. Tool Bar
         3. Code Editor
         4. Menu Editor
      3. The number of entity types that participate in a relationship is called as
         1. Tuple

         --- Content provided by FirstRanker.com ---

         2. Number
         3. Counter
         4. Degree
      4. The command is used to change the column width of an existing table :
         1. UPDATE

         --- Content provided by FirstRanker.com ---

         2. SELECT
         3. MODIFY
         4. ALTER

   --- Content provided by FirstRanker.com ---

   3. Answer in ONE sentence (1 mark each) : 4
      1. What is the use of pointer tool ?
      2. What do you mean by nesting of loops ?
      3. What is normalization ?
      4. What is data type ?

   --- Content provided by FirstRanker.com ---

2. 1. What is Visual Basic ? Explain its IDE in brief. 6
   2. Explain the following : 6
      1. Menu Bar
      2. Tool Bar.

   --- Content provided by FirstRanker.com ---

   OR

3. 1. 1. Project Window
      2. Property Window.

   --- Content provided by FirstRanker.com ---

   2. Explain form window with any six properties. 6
4. 1. Explain command button controls with its basic properties. 6
   2. Explain the following control with example : 6
      1. Line object
      2. Data control.

      --- Content provided by FirstRanker.com ---

   OR

5. 1. Explain the difference between Text Box Control and Label Control. 4
   2. Explain the difference between the following : 8
      1. Check Box and Option Button

      --- Content provided by FirstRanker.com ---

      2. Picture Box and Image Control.
6. Explain the following with suitable examples : 12
   1. Variable declarations in VB
   2. Logical operators

   --- Content provided by FirstRanker.com ---

   3. Conditional operators.

   OR

7. 1. Explain the following with suitable example : 6
      1. Nested If....Else statement
      2. Nested For....Loop

      --- Content provided by FirstRanker.com ---

      3. GoTo statement
   2. Explain the select case statement with syntax and suitable example. 6
8. 1. Describe architecture of database system. 6

   --- Content provided by FirstRanker.com ---

   2. Explain the following terms with example : 6
      1. Entity
      2. Domain
      3. Attributes.

   OR

   --- Content provided by FirstRanker.com ---

9. 1. What are the advantages and disadvantages of Database Management System ? 6
   2. Explain 3NF with suitable example. 6
10. Explain the following commands with syntax and example : 6
    1. UPDATE

    --- Content provided by FirstRanker.com ---

    2. DELETE
    3. DROP

    OR

11. Explain the following clause with syntax and suitable example :
    1. GROUP BY

    --- Content provided by FirstRanker.com ---

    2. ORDER BY
12. 1. Explain Commit and Rollback commands with their syntax and example.
    2. Explain the following functions with syntax and suitable example :
       1. FLOOR ()
       2. SOUNDEX ()

       --- Content provided by FirstRanker.com ---

       3. TO_CHAR ()
13. What is Join ? Explain equi-join and self-join with suitable example.

    OR

--- Content provided by FirstRanker.com ---

14. Explain the following group functions with syntax and example :
    1. COUNT ()
    2. SUM ()
    3. AVG ()
15. What is data integrity ? Explain any two constraint with example.

--- Content provided by FirstRanker.com ---