1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
B.C.A.DEGREE EXAMINATION -COMPUTER APPLICATIONS
FOURTH SEMESTER APRIL 2018
CA 4504- VISUAL PROGRAMMING AND ORACLE
Date: 09-05-2018 Dept. No. Max. 100 Marks
Time: 09:00-12:00
PART-A
ANSWER ALL THE QUESTIONS: 10 x 2 20 marks
1. What are the advantages of visual basic?
2. What is explicit and implicit declaration? 3. List the various controls used in VB. 4. Define the Flex grid control with an example.
5. Define foreign key. What is this concept used for?
6. What is a domain?
7. Define cardinality.
8. What are the benefits of candidate key?
9. What is a data control?
10. What is OLEDB?
PART-B
ANSWER ALL THE QUESTIONS: 5 x 8=40 marks
11. Explain the scope of variables in Visual Basic.

Explain any two intrinsic functions with an example.
12. Differentiate Option Button and Check Box.

Write a short note on windows common dialogs.
2
13. Explain in detail about the different notation used in Entity relationship model.

Describe in detail about three level architecture.
14. Explain briefly about Integrity constraints withan example

Describe the types of relationships used in E.R Model.
15. Explain the ways of validating data that is entered in VB.

Explain briefly about data bound control in VB.
PART-C
ANSWER ANY TWO QUESTIONS: 2*20=40 marks)
16.a) Explain the difference between the Form window and Form Layout window.
Explain about sub proceduresand functions with example.
17.a) Explain in detail about the following normalization.
First normal form
ii) Boyce Codd Normal Form
Discuss in detail about the client server architecture.
18. a)Explain the following main types of languages.
Data definition language
Data manipulation language
Explain how to access fields and record sets using SQL statements.