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

FirstRanker.com
A Firstranker's choice

AW-1748

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

B.Sc. (Part—III) Semester—V Examination

COMPUTER SCIENCE

(RDBMS and Visual Basic)

Time : Three Hours) [Maximum Marks : 80

Note :— (1) All questions are compulsory.

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

(2) Question No. 1 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) ________ clause of select statement can be used to order the records in particular order.

(ii) In a relation the values for an attribute or a column are drawn from a set of values called as ________.

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

(iii) ________ property specifies whether a command button displays a text caption or a picture.

(iv) ________ statement is used to transfer control from one statement to another statement.

(B) Choose the correct alternatives : 2

(i) Which among the following is not a component of database system ?

(a) Data (b) Hardware

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

(c) Internal view (d) Software

(ii) Which is not DML command ?

(a) INSERT (b) UPDATE

(c) DELETE (d) ALTER

(iii) When the user clicks a button ________ is triggered.

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

(a) an event (b) a method

(c) a setting (d) a property

(iv) Which property determines whether a control is displayed to the user ?

(a) Hide (b) Show

(c) Visible (d) Enabled

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

(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 Inputbox () function ?

(iv) What is an accelerator key ?

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

2. (A) Explain Architecture of database system with different three levels. 6

(B) Explain Relational and Hierarchical model with example. 6

OR

3. (A) What is database ? Explain components of database system. 6

(B) Explain the following :—

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

(i) Data Independence

(ii) Data Dictionary. 6

4. (A) Explain reducing ER diagram to table with example. 6

(B) Explain following keys :

(i) Candidate Key

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

(ii) Primary Key

(iii) Foreign Key. 6

OR

5. (A) What is normalization ? Explain 3NF with example. 6

(B) Explain Relation, Domain and Attribute with suitable example. 6

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

6. (A) What is view ? How view can be created and dropped ? Explain with example. 6

(B) Explain following operators with example :

(i) IN

(ii) Like

(iii) Between. 6

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

OR

7. (A) Explain various components of SQL statement. 6

(B) Explain the following clauses with example :

(i) ORDER BY

(ii) GROUP BY

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

(iii) HAVING 6

8. (A) Explain the IDE components of Visual Basic. 6

(B) Explain the following controls with basic properties :

(i) Label

(ii) Picture box. 6

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

OR

9. (A) What is event ? Explain event procedure with suitable example. 6

(B) What is form ? Explain five properties associated with form. 6

10. (A) Explain Application Wizard for creating menus for your application. 6

(B) Explain “Select case” statement with syntax and suitable example. 6

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

OR

11. (A) Explain menu editor properties. Also explain creation of menu bar using menu editor. 6

(B) Explain the following with example :

(i) Nested If ... else

(ii) Do Loop. 6

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

12. (A) Explain Msg Box () function with syntax, framed constant and example. 6

(B) Write a program in VB using procedure to swap two Numbers. 6