Download SGBAU BSc 2019 Summer 6th Sem Computer Science PL SQL n Advanced Visual Basic Question Paper

FirstRanker.com
Firstranker's choice

Time : Three Hours] [Maximum Marks : 80

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

B.Sc. (Part-II) Semester-VI Examination
6S : COMPUTER SCIENCE
(PL/SQL and Advanced Visual Basic)

Note :— (1) All questions are compulsory.
(2) All questions from 2 to 13 carry equal marks.

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

(3) Assume suitable data wherever necessary.
(4) Support your answers with neat sketches and diagrams for due credit.
(5) Question 1 carries 8 marks.

1. (a) Fill in the blanks and rewrite the following :
(i) ______ provide a way for your program to select multiple rows of data from the database and then process each row individually.

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

(ii) ______ join is used to join a table to itself.
(iii) ______ property of timer control sets time in milliseconds.
(iv) ______ method of Listbox control is used to add items in the Listbox. 2

(b) Select the correct alternative :
(i) ______ cursors are declared and used by the users to process multiple rows, returned by SELECT statement :

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

(a) Implicit (b) Explicit
(c) Internal (d) External
(ii) ______ command marks and saves the current point in the processing of transaction.
(a) Savepoint (b) Rollback
(c) Select (d) None of these

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

(iii) Which is not a standard dialog box ?
(a) Color Dialog (b) Font Dialog
(c) Open Dialog (d) Zoom Dialog
(iv) The standard prefix for a dialog control is :
(a) dal (b) dia

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

(c) dil (d) dlg 2

(c) Answer the following in one sentence :
(i) What is a Transaction ?
(ii) What is meant by Join ?
(iii) What is the need of dialog box ?

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

(iv) What is an Array ? 4

2. Explain following functions with examples :
(i) LTRIM
(ii) RTRIM
(iii) DECODE. 6

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

3. Explain the outer join operation with an example. 6
OR

(a) Explain the following SQL functions :
(i) FLOOR
(ii) LPAD

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

(iii) SQRT. 6

(b) Explain the following with example :
(i) Intersection
(ii) Union. 6

4. (a) Explain PL/SQL control structures with example. 6

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

(b) Explain the following transaction processing commands with example :
(i) Rollback
(ii) COMMIT
(iii) Savepoint. 6
OR

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

5. (a) How to handle exception in PL/SQL ? Explain with example. 6

(b) What are cursors ? Explain the types of cursors with example. 6

6. (a) Explain GRANT and REVOKE with example. 6

(b) How to create and grant the roles ? Explain. 6
OR

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

7. (a) What are Privileges and Roles ? Explain. 6

(b) Explain data locks with suitable example. 6

8. (a) Explain open dialog boxes with example. 6

(b) What is an Array ? Explain initialization and declaration of array in V.B. with example. 6
OR

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

9. (a) Explain file save dialog box with example. 6

(b) How to add and remove elements in list box control ? Explain with example. 6

10. (a) Explain form collection using the subscripts. 6

(b) How to place buttons on toolbar control ? Explain with example. 6
OR

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

11. (a) What is the use of COUNT property ? Explain with example. 6

(b) Explain placing text on forms with example. 6

12. (a) Explain the following :
(i) PUT statement
(ii) GET statement. 6

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

(b) How to lock a file ? Explain. 6
OR

13. (a) Explain :
(i) Write # statement
(ii) Input # statement. 6

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

(b) Write a program in V.B. for reading and writing from sequential file. 6

FirstRanker.com