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
--- 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