Questions : BCA 3rd Year (magadh University)
BCA Paper 5 (2010)
Time : 3 hours
Full Marks : 100
The Questions are of equal value.
Answer any five questions, including question no.1 which is compulsory.
1. Choose the correct answer:
(a) While using
msgbox(string, integer, title) function, if the integer argument value is 3,
the resulting Msgbox command buttons are:
the resulting Msgbox command buttons are:
(i)
Abort, Retry, Ignore
(ii)
Yes, No, Cancel
(iii)
Ok, Cancel, Retry
(iv)
None of the above
(b) A form’s
coordinates and dimensions on screen are always measured in :
(i)
Point
(ii)
Twips
(iii)
Pixel
(iv)
Inch
(c) The following
functions converts the numeric values of an indicated date to a visual
basic date type:
basic date type:
(i)
Date value
(ii)
Date serial
(iii)
Date format time
(iv)
None of the above
(d) How do you
create a method for a class
(i)
Creating a public procedure in a class module
(ii)
Creating a private procedure in a class module
(iii)
Creating a properties of class
(iv)
none of the above
(e) One advantage
of the object browser over the properties window is that:
(i) The browser can show both
function and subroutine of the registered
classes
classes
(ii)
The browser can set the properties of registered classes
(iii)
The browser can show both properties and methods of the registered
classes
classes
(iv)
all of the above
(f) All the
following statements are true about variable scope except:
(i)
Local
(ii)
Module
(iii)
Global
(iv)
Static
(g) A new property
in a class module has been created; but its scope is not specified.
What scope is it?
What scope is it?
(i)
Private
(ii)
Friend
(iii)
public
(iv)
Global
(h) A schema
describes:
(i)
Record Relationship
(ii)
Data Elements
(iii)
Record and files
(iv)
All of the above
(i) One of the flowing is valid record-based data
models:
(i)
Object-Oriented model
(ii)
Relational Model
(iii)
Entity relationship Model
(iv)
none of the above
2. (a) Differentiate between implicit variable
declaration and explicit variable declaration by
running a VB program.
running a VB program.
(b) Differentiate
between ListBox and ComboBox control. List basic properties of these.
(c) Write
the source for drawing methods of VB such as Circle and line.
(d) Explain
the key objects of ADO model that enable programmers to retrieve set of
records from a given data source.
records from a given data source.
3. (a) Explain: Error trapping and handling in VB.
(b) Explain the difference between Resume and
Resume Next in an error handler in the
call list.
call list.
(c) Explain what happens when an error is raised
in a procedure that does not contain an error handler.
(d) Explain
with description the properties and methods of err object.
4. (a) Give the
difference between check box control and option button control.
(b) How can
we established the connection of a data bound control to a database using
the Data Environment?
the Data Environment?
(c)
List five properties of the ADO data control Recordset and explain
them.
(d) Write
down the steps in sequence for adding and deleting records with ADODC.
5. (a) Variables
are used by Visual Basic to hold information needed by your application.
What are Visual basic data types? Briefly explain each type.
What are Visual basic data types? Briefly explain each type.
(b) Arrays
and collections provide a mean of organizing a group of objects. What are
the differences between control Array and Controls Collection?
the differences between control Array and Controls Collection?
(c) What
are the uses of Text Boxes in Windows Programs?
(d) Modules
are files that contain program code. List the different types of modules in VB.
6. (a) MDI
applications are useful when it requires working with multiple documents. Write
a program to create MDI application.
a program to create MDI application.
(b) Data
validation is checking the input of a program against the conditions
specified.
Write a program to check validating data at Field Level.
Write a program to check validating data at Field Level.
(c) Write
short notes on : Visual Basic standard controls.
(d) Forms
are used to develop the user interface. Write a program to create and remove
forms at runtime.
7. (a) Write a
short notes on Arrays.
(b)
Differentiate between the class modules and the standard module.
(c) Define shadowing.
(d) how to
change the position of the form during design time. And how to position it
during run time?
during run time?
8. (a) Write
short note Timer Control.
(b) What is
use of Popup Menu? Explain, how to create the popup menu in Visual Basic.
(c) How to
manipulate menu at run-time?
(d)
Distinguish among RUN, Design and Debug modes I Visual Basic.
9. (a) Explain
the purpose and scope of database security and explain the following in
terms of providing security for a database: authorization, views, backup and recovery,
integrity, encryption and RAID technology.
terms of providing security for a database: authorization, views, backup and recovery,
integrity, encryption and RAID technology.
(b) What is
the difference between logical data independence and physical data
independence?
independence?
(c) Explain
the procedure to perform E-R Relational mapping with the help of a suitable
example.
example.
(d) what is
referential integrity? Explain with suitable examples.
10.(a) State any five advantages of DBMS.
(b) Mention
any three advantages of views.
(c) Explain
the purpose of triggers in SQL with the help of an example.
(d) Explain
the functions of Database Administrator.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment