Download SGBAU BSc 2019 Summer 5th Sem Computer Science RDBMS n Visual Basic Question Paper

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

AVV?l748
B.Sc. (Part?lll) Scmestcr??V Examination
COMPUTER SCIENCE
(RDBMS and Visual Basic)
Time : Three Hours] [Maximum Marks : 80
Note :? (,1) All questions are compulsory.
(2) Question No. l carries 8 marks and all other questions carry 12 marks each.
(3) Assume suitable data wherever necessary.
1. (A) Fill in the blanks : 2
(i) ___7 clause of select statement can be used to order the records in particular m?dcr.
(ii) In a relation the values for an attribute or a column are drawn from a set ot?values called
as '77
(iii) A _ 7?. property speci?es whether a command button displays a text caption or
a picture.
(iv) *_?__ w statement is used to transfer control from one statement to another statement.
(B) (Thoose the correct altematives : 2
(1) Which among the following is not a component of database system ?.?
(a) Data (b) Hardware
(c) Intemal view (d) Sn?warc
(ii) Which is not DML command ?
(a) INSERT (b) UPDA?I'E
(c) DELETE (d) ALTER
(iii) When the user clicks a button _ ___ is triggered
(a) an event (b) , a method
(c) a setting (d) a property
(iv) Which property dctcmiines whether a control is displayed to the user ??
(:1) Hide (b) Show
(c) Visible (d) Enabled
(C) Answer in ONE sentence each : 4
(i) What is the use of drop table command ?
(ii) What is relation ?
(iii) What is the use of lnputbox ( ) function 1?
(iv) What is an accelerator key '?
2. (A) Explain Architecture ofdatabasc system with di?'ercnt three levels.
(B) Explain Relational and IIirerchical model with example.
OR
3. (A) What is database 7 Explain components of database system. 6
(B) Explain the following :?
(i) Datalndcpendence
(ii) Data Dictionary. 6
YBL? l53|6 I (Contd.)

10.
11.
YBC?ISS 16
(A)
(A)
(B)
(A)
(B)
(A)
(B)
(A)
(13')
(A)
(B)
(A)
(B)
(A)
(B)
(A)
(B)
Explain reducing ER diagram to table with example.
Explain following keys :
(i) Candidate Key
(ii) Primary Key
(iii) Foriegn Key.
OR
What is nomialization " Fx'pfain 3N}: with example.
Explain Relation. Domain and Attribute with suitable example.
What is view '7 How view c m be created and droppcd '9 lixplain with cxumplc.
Explai'i following operator: with example :
(i) [N
(ii) I. kc
(iii) B:twecn.
()R
Explain various Components IWSQI? statcmcnt.
Explain the following cliuscs \\'IIh example :
(i) ORDER BY
(ii) UROL'P BY
(iii) HAVING.
Explain the IDE components or?Visual Basic.
Explain the following comm]; with basic properties :
(i) Label
(ii) Picture box.
OR
What is; event ?7 Explain cwnt procedure with suitahlc example.
What is fomi ?? Explain t'n r i?vroperties associated with form.
Explain Application Wiz ard for creating menus for your application.
Explain ?Select case" slaitcmmt with syntax and suitable example.
OR
Explair. menu editor properiivs. Also explain creation of menu bur using menu editor.
Explain the following ui"h cwmplc :
(i) Nested If ...clsc
(ii) [)0 Loop.
Explain Msg Box ( ) t?unctiiin with syntax, framed constant and example.
Write a program in VB .ismg procedure to wap two Numbers.
Id
6
6
6
(i
6
(i
(i
(i
()
6
0
( J