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

Download SGBAU (Sant Gadge Baba Amravati university) BSc 2019 Summer (Bachelor of Science) 6th Sem Computer Science PL SQL n Advanced Visual Basic Previous Question Paper

AW-1774~
B.Sc. (Part?III) Semester?VI Examination
68 : COMPUTER SCIENCE
(PL/SQL and Advanced Visual Basic)
Time?: Three Hours] ' [Maximum Marks : 80
Note :?(I) All questions are compulsory. I
l (a)
(b)
(C)
2. (a)
(b)
(2) All questions from 2 to 13 carry equal marks.
(3) Assume suitable data wherever necessary.
(4) Support your answers with neat sketches and diagrams for due credit.
(5) Question 1 carries 8 marks. ?
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.
(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
Select the correct alternative :
(i) _ cursors are declared and used by the users to process multiple rows, returned
by SELECT statement :
(a) Implicit (b) Explicit
(c) Internal (d) External
(ii) __ command marks and saves the current point in the processing of transaction.
(21) Savepoint (M Rallback
(c) Sclect (d) None of these
(iii) Which is not a standard dialog box ?
(a) Color Dialog (b) Font Dialog
(c) Open Dialog (d) Zoom Dialog
(iv) The standard pre?x for a dialog control is :
(a) dal (b) dia
(c) dil (d) dlg 2
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 ?
(iv) What is an Array ? 4
Explain following functions with examples :
(i) LTRIM
(ii) RTRIM
(iii) DECODE. 6
Explain the outer join operation with an example. 6
0R
YBC?1534l l (Contd.)

3. (3) Explain the following SQI, functions with example :
(i) FLOOR
(ii) LI?AD
(iii) SQRT. 6
(b) Explain the following with example :
(i) Intersection
(ii) Union. 6
4. (a) Explain PL/SQL control structures with example, 6
(b) Explain the following :ransttction processing commands with example :
(i) Rollback
(ii) COMMIT
(iii) Savcpoint. 6
OR
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 1? Explain. 6
0R
7. (a) What are Privileges and Roles ? Explain. 6
(b) Explair data locks with suitable example. 6
8. (a) Explain open dialog boxes with example. 6
(b) What is an Array 1? Explain initialization and declaration of army in VB. with example.
6
()R
9. (a) Explain ?le save dialog: hm with example. 6
(b) How to add and remove clcments in list box control '.? Explairi with example. 6
10. (3) Explain form collectior using the subscripts. 6
(b) How to place buttons cn tonlbar control '? Explain with example. 6
OR
11. (a) What is the use of CO1 .N 1? property '? Explain with example. 6
(b) [Explain placing tcxt on forms with example. 6
12. (3) Explain the following :
(i) PUT statement
(ii) Gb'l? statement. 6
(b) How to lock 21 ?le ? Explain. 6
OR
l3. (a) Explain :
(i) Write # statement
(ii) Input # statement. 6
(b) Write a program in MB for reading and writing from sequential ?le. 6
YBC?1534l 2 525