Maharshi Dayanand Saraswati University (MDSU) 2009 B.C.A Computer Application Mis - Question Paper

7136

B.C.A. (Part III) EXAMINATION, 2009 COMPUTER NETWORKS AND MOBILE COMPUTING

Twentieth Paper Time allowed : Three Hours Maximum Marks : 50

Attempt five questions in all.

All questions carry equal marks.

1.    What do you understand by protocols and protocol stack ? How are protocols combined in a stack ? Explain.    2+2+6

2.    What do you mean by inter-networking devices ? Explain the working of two inter-networking devices. 2+4+4

3. Write short notes on the following

(a) Signal regenerating devices;

(ft) Active Hub;

T

(c) Passive Hub.

4. How does an Ethernet LAN work ? Describe various implementations of Ethernet LAN.    4+6

5.    Define DECT. Explain its working with cordless telephones.    3+7

6.    What is orbit ? Describe the types of satellite orbits. Also write the application where satellites are used.

1+4+5

7.    What is wireless LAN ? Define the services and standards of IEEE 802.11 family.    2+4+4

r

This question paper contains 3 printed pages]

3356

B.C.A. (Part III) EXAMINATION, 2007

RELATIONAL DATABASE MANAGEMENT SYSTEM

Paper XXIV

Time allowed : Three Hours

Maximum Marks : 50

Attempt any five questions. All questions carry equal marks.    _

1. Create the following relations :

(a) Customer (custid, custname)

Order (custid, custname, orderid, orderdate)

Item (custid, orderid, itemid, itemname, qty, rate amt,)

Assumption can be handle (made), place suitable referential integrity constraints and other constraints such as not null, unique.

Use coding standard and dont write wrong keyword, if so then there will be deduction of marks.

(>) Write syntax for insert update and delete query with an example.

2.    (a) Write a PL/SQL block to illustrate the working

of IF-THEN-ELSE. If a number is greater than the other number then it swap the two numbers otherwise it doubles them.

(6) Write a PL/SQL code. Insert a new record in table emp after abstaining values from the user.

(c) Write a PL/SQL block that obtain an empno from user if his/her salary less than 900/- then delete that record home table.

3.    What is the package and how package can be created ? Explain it with the help of an example (Package should contain of last function and one procedure).

4.    (a) What is the trigger ? Write the types of trigger

and give examples of BEFORE and AFTER trigger.

(6) Write a trigger that will execute when the duplicate value is entered in emp table and dietary on ever message Duplicate value is not allowed. 3356    2

5.    How do we handle error in PIVSQL block ?

6.    Explain the architecture of DDBMS and its advantages and disadvantages ?

7.    Why do we use procedure and function in PL/SQL ? Demonstrate with example.

3. Write short notes on ;

()    Set operation;

()    Join operation;

(c)    Query optimization;

(d)    Recovery technique.

B.C.A. (Part III) EXAMINATION, 2008 RELATIONAL DATABASE MANAGEMENT SYSTEM Paper XXIV Time allowed : Three Hours Maximum Marks : 50

Attempt any five questions. All questions carry equal marks.

1.    Explain the difference between internal, external and conceptual schemas. How are these different schema layers related to the concept of logical and physical data independence ?

2.    (a) What is transaction ? Explain Transaction

Management in DBMS in detail.

(6) What is the difference between explicit and implicit

transaction control ?

1,000    P.T.O.

3.    (a) What is trigger ? What is the difference between

a trigger and procedure ?

(6) What is ODBC ? Explain its architecture,

4.    Create a database for the following tables and mention the domain constraints, integrity constraints for the same

Branch (Office-code, Office-desc, City)

Employee (Emnlovee-code. Employee-name, Type-code) Type (Tvoe-code. Type-details)

Account (Account-no. Branch-code, Employee-code, Balance)

Transaction (Account no. Dr.-code, amount)

Code (Dr-code. Dr-details)

Underlined one are the primary key in each table are establish a relation with foreign key, which can be seen with same name in other tables. Perform the following :

() Write a SQL for consolidate the amount from transaction file on account-no and Dr-code and update the same with amount. In case Dr-code = 1 reduce the amount from Balance and incase the Dr-code = 2, add the amount in balance.

(ii) Write a SQL for finding maximum account of an employee among all the branches in a city. This list should be citywise.

Why do we use procedure and function in PL/SQL ? Demonstrate with example.

What are views ? How are they different from actual tables ? Whenever changes are made in a table, are they automatically reflected in view and vice versa ? What is the special utility of views for which they are created ? Explain with example.

(a) Create a procedure to display the employee Name from Emp table (Database). Make the suitable assumptions.

(6) Write a function to receive a date and number of years to be added and return the value.

8. Write short notes on :

(a)    Data Mining;

(b)    Join Operations;

(c)    Data warehousing;

(d)    Dead-locks.

This question paper contains 3 printed pages]

7140

B.C.A. (Part III) EXAMINATION, 2009

RELATIONAL DATABASE MANAGEMENT SYSTEM

   Paper XXIV

Time allowed : Three Hours

Maximum Marks : 50    .

Attempt any five questions. All questions carry equal marks.

1.    (a) Explain the architecture of distributed processing

system.

(6) Describe how to incrementally maintain the results of the following operations, on both insertions and deletions :

(i)    Union and set difference;

(ii)    Left outer join.

2.    (a) Consider a file system such as the one on your

favourite operating system.

ii) What are the steps involved in creation and deletion files, and in writing data to a file ?

(ii) Explain how the issues of atomicity and durability are relevant to the creation and deletion of files, and to writing data to files ?

(b) Explain the distinction between the terms serial schedule and serializable schedule ?

3.    What is a recoverable schedule ? Why is recoverability of schedule desirable ? Are there any circumstances under which it would be desirable to allow non-recoverable schedules ? Explain your answer,

4.    (a) When a transaction is rolled back under timestamp

ordering, it is assigned a new timestamp. Why can it not simply keep its old timestamp ?

(6) Under what conditions is it less expensive to avoid deadlock than to allow deadlocks to occur and then to detect them ?

5.    (a) Discuss the relative advantages of centralized and

distributed databases.

(6) When is it useful to have replication or fragmentation of data ? Explain your answer.

6.    (a) What is the difference between WHERE and HAVING

clause ?

(6) What is the difference between SELECT INTO and CREATE VIEW commands ?

(c) What is the difference between column constraints and table constraints ?

7.    Write a SQL statement to list all the employees in the following format :

employee (name, department, dept no.)

(i)    List the information which is sorted on emp. name.

(ii)    Find all those employees whose job does not start with *M.

(Ui) Display all employees who were hires during 1995.

8.    Give a network data structure diagram for the following relational database :

()    lives (person-name, street, city)

works (person-name, company-name, salary) location-in (company-name, city) manages (person-name, manager-name)

()    course (course-name, room, instructor) enrolment (course-name, student-name-grade).

7140    3

3353

This question paper contains 2 printed pages]

Bachelor in Computer Application (Part III) EXAMINATION, 2007 VISUAL BASIC PROGRAMMING

Twenty First (BCA XXI) Paper

Time allowed : Three Hours

Maximum Marks : 50

Attempt five questions in all. All questions carry equal marks.

1.    Why the Visual Basic is treated as GUI programming language ? Explain the features and importance of Visual Basic.

2.    Define the term Project in Visual Basic. Explain all possible components of VB Project.

3.    What do you understand by Event Driven Programming ? Write an event driven program to accept only names of students in a Text Box.

4.    Differentiate between :

(/) Text Box and Label;

(ii) List Box and Combo Box;

500    P.T.O.

(Hi) Check Box and Radio Button;

(iv)    Scroll Bar and Slider;

(v)    Picture control and Image control.

()    How do you access Win 32 API from VB ? Explain with example. .

()    What is MDI ? Explain the utility of Parent and Child form.

What is an Array ? Explain different types of Arrays and Collection used in Visual Basic with example. Also explain subroutines and functions.

(a) Write a program to display the content of text file in a multi line text box.

(ib) What are frames ? Explain their uses with examples.

How are external database accessed through Visual Basic ? Write the complete steps of accessing the database.

Bachelor in Computer Application (Part III) EXAMINATION, 2008

VISUAL BASIC PROGRAMMING

Twenty First (BCA XXI) Paper

Time allowed : Three Hours

Maximum Marks : 50

Attempt five questions in all. All questions carry equal marks.

1.    Discuss the advantages and disadvantages of Visual Basic. What is an IDE, explain in detail. How the debugger helps in rectifying syntactical and logical errors ?

2.    Visual Basic offers different type of projects. What are the usage of each of the type of projects ? Explain with the help of suitable example.

3.    Discuss the usage of the following :

(t) Timer Control

(ii)    Slider

(iii)    Scroll bar

(if) Drive and File List Box (u) Shape.

Discuss the concept of Dynamic Forms. Write a VB dynamic program to initialise all the control available on the form.

(c) Discuss the usage of SDI and MDI forms. How the menus are effected on reacted to the different types of forms,

ib) Explain declaring and calling DLL procedure with the help of example.

()    How is DLL different from an API ? Write a procedure to access Win32 API from VB.

()    Differentiate between :

(i) Design Time and Run Time {) Menus and Toolbars

(iii)    Intput/Output Statements and Control Flow Statements

(iv)    Frame and Tab Strip

U>) Graphics Controls and Text Controls.

7.    Write a program to update a table in database with the help of VB Form. The Form contains the name of Student, Year of admission, Date of Birth, percentage in 12th, Last school passed etc.

8.    (a) Why is the Visual Basic known as

Windows programming language ? What are the usage of Common Dialog Control ? Explain with example.

(6) Write a VB program to accept Student ID on the form, the control should not allow user to enter any other character except the numerals using event driven concept.

(i) Customizing the toolbars;

(ii) Generating timed events.    2x5=10

10. Write short notes on any two of the following :

(i) Drawing methods in VB using graphics control;

(ii) Coordinate systems and graphic methods;

(iti) Colors and Pixels.    2x5=10 7137

Bachelor in Computer Application (Part III) EXAMINATION, 2009 VISUAL BASIC PROGRAMMING Twenty First (BCA XXI) Paper Time allowed : Three Hours Maximum Marks : 50

Attempt five questions in all, AM questions carry equal marks.

1.    (a) What are the various parts of the design state

of the VB IDE ? Explain.

(b) Write down the various features of VB.

r . k -t OTU=iV

2.    (a) What is object oriented programming ? What are

its characteristics ? Explain.

(b) What is meant by event driven programming ? How does it differ from traditional programming ?

5+5=10

3.    (a) Namp and givp the purpose of five types of data

available in VB. What effect does the location of a DIM statement have on the variable it declares ?

(i>) Describe how you attach code to an object.

5+5=10

4.    (a) What does the term Common dialog box mean ?

Name at least three types of common dialog boxes.

(6) Explain the difference between a procedure and '' a function procedure.    5+5=10

5.    (a) Name and describe three styles of combo

(6) When and how is information placed inside a list box or a combo box ?    5

()    What are different control statements available in VB ? Explain them by taking an example of each.    6

()    What do you understand by the scopaof a variable ? Illustrate with example.    4

()    What are Dynamic forms ? How can you build a dynamic form ? Illustrate with example. 5

()    Explain various drag and drop operations. 5

Write a program to update database with the help of VB form. The form contains the name of employee, his date of birth total pay, total deduction and his home address.    10

7137    3    P.T.O.