Showing posts with label BCA questions. Show all posts
Showing posts with label BCA questions. Show all posts
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.
Questions : BCA 3rd Year (magadh University)
BCA Paper 5 (2011)
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) In visual Basic, the storage size
of data type currency is
(i) 1 byte
(ii) 2 byte
(iii) 8 byte
(iv) 4 byte
(b) The range of data type in visual
Basic is visual Basic is
(i) January 1, 100 to December 31,
9999
(ii) January 1, 1000 to December 31,
9000
(iii) January 2, 1900 to December 31,
9999
(iv) None of these
(c) MDI stands for
(i) Multiple Data Intraction
(ii) Multiple Document Interface
(iii) Maximum Document Interface
(iv) None of these
(d) Menus can be created quickly by
using the
(i) Menu editor utility
(ii) Common dialog control
(iii)Text box
(iv) None of these
(e) For a maximized windows, the
window State Property is set to be
(i) 1
(ii) 2
(iii) 0
(iv) 3
(f) The type of data file that can be
created in VB is
(i) Sequential
(ii) Random
(iii)Binary
(iv)All (i),(ii) and (iii)
(g) ODBC stands for
(i) Oracle Database Connectivity
(ii) Open Database Connectivity
(iii) Optional Database Connectivity
(iv) None of these
(h) Data about data is normally termed
as
(i) Directory
(ii) Meta data
(iii) Data bank
(iv) None of these
(i) The relational data model is
concerned with
(i) Data structure and data integrity
(ii) Data manipulation
(iii) Both (i) and (ii)
(iv) None of these
(j) In E-R diagram, a weak entity set
is represented by
(i) Double outlined rectangle
(ii) Rectangle
(iii)Oval
(iv)None of these
2. (a) What do you mean by event
driven programming? Explain some of the events
supported by visual Basic
Objects.
(b) What are the different data types supported by Visual
Basic? How can they be
declared? Discuss the scope and lifetime of variables.
3. differentiate between following
and also list basic properties;
(a) Picture Box and Image control
(b) check box and option button
(c) Directory list box and file list
box
(d) Label and Command button.
4. (a) what is module ? Discuss form
module, standard module and class module with
example.
(b) what is procedure? Discuss general procedure and event
procedure.
(c) Discuss select case structure with example
(d) Explain FOR…NEXT and FOR EACH… NEXT loop structure.
5. (a) What is the difference between
array and dynamic array?
(b) write a program using dynamic array to record the high
temperature of last seven
days and display all of them with the average of high
temperature. Use three buttons,
one to enter temperature, second to display the
result and third to exit from the
program.
6. (a) Explain the various types of error that may occur in VB,
Discuss how to avoid them
(b) What are the advantages of OLE? Explain the various
methods that can be applied
to OLE container control.
7. (a) Discuss the menu Editor. How to create menu? Explain
menu naming conventions.
(b) Discuss briefly the graphics controls.
(c) Write a program to print a given string 4 times each
time with increased font size and
color.
8. (a) What do you mean by DBMS? What is its advantage?
(b) Discuss hierarchical and relational data model.
(c) what are schema and subschema?
(d) Discuss the role of DBA.
9. (a) What do you mean by entity, entity set attributes and
relationship?
(b) Discuss the different symbols used in E-R model.
(c) Explain the terms generalization and specialization.
(d) Discuss DDL, DML and DCL
10. Discuss the following SQL commands with suitable examples:
(a) Create table
(b) Insert
(c) Select
(d) Delete
(e) grant
Click Here for View answer
Subscribe to:
Posts
(
Atom
)
