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 ? 42. 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
--- Content provided by FirstRanker.com ---
This download link is referred from the post: SGBAU BSc Last 10 Years 2010-2020 Question Papers || Sant Gadge Baba Amravati university