Download SGBAU BSc 2019 Summer 4th Sem Computer Application Advanced VB n RDBMS Question Paper

FirstRanker.com

B.Sc. (Part-II) Semester—IV Examination

4S : COMPUTER APPLICATIONS (VOC) (OLD) (UPTO SUMMER - 2020)

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

(Advanced VB and RDBMS)

Time : Three Hours] [Maximum Marks : 80

Note :— (1) Question No. 1 is compulsory.

(2) Question No. 2 to 13 carry equal marks.

(3) Assume suitable data wherever necessary.

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

1. (A) Fill in the blanks :
   1. The __________ is a list of all the printers on your applications PC.
   2. The __________ property to connect the data control to the database.
   3. SQL security scheme is based on __________
   4. Manipulation can be made by the __________ commands into the database.
   (B) Choose the correct alternatives :
   1. __________ is used to begin printing the form immediately.
      1. Load Form

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

      2. Print Form
      3. Form Print
      4. All of the above
   2. The __________ statement tells VB to temporarily put on hold the running procedure.
      1. Goto

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

      2. Call
      3. While
      4. Jump
   3. mSQL __________ is a tool for giving the detail information of form.
      1. Report

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

      2. Form Report
      3. Form Run
      4. None of the above
   4. The attribute that always evaluates to false in case of implicit cursor is :
      1. %ROWCOUNT

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

      2. %FOUND
      3. % NOT FOUND
      4. %ZSOPG
   (C) Answer in one sentence :
   1. What is cursor ?

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

   2. What is ROLE ?
   3. What is global variable ?
   4. What is scaling output ?
2. (a) Explain passing data by reference and value.

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

3. (b) What is meant by design time and run time properties ? Explain.

OR

3. (a) Explain VB programme structure.
4. (b) What is General Procedure ? Explain procedure of calling General Procedure.
5. (a) Explain how Database and VB are related.

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

6. (b) Explain various methods of Data Control.

OR

6. (a) Explain advanced database control.
7. (b) Write a program in VB to connect employee database using Data Control.
8. (a) Explain printing on the printer object.

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

9. (b) Explain scaling output with their properties.

OR

8. (a) Explain the term printing the forms.
9. (b) Write a VB code to print “Visual Basic” on form using Print Method.
10. (a) Explain the Attributes of cursors with example.

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

11. (b) Explain COMMIT and ROLLBACK transaction commands in PL/SQL.

OR

10. (a) Explain control structure used in PL/SQL.
11. (b) Explain, how to create, open, fetch cursor using suitable example.
12. (a) How to create user ? Explain with example.

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

13. (b) What is meant by column passing privilege ? Explain.

OR

12. (a) What do you mean by privileges ? Explain system privilege.
13. (b) Explain uses of role in database.
14. (a) Explain Dynamic SQL with example.

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

15. (b) Explain editing and entering data using forms.

OR

14. (a) What are advantages of SQL * form ?
15. (b) Explain difference of Static SQL and Dynamic SQL.

FirstRanker.com

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