Saturday 22 November 2014

SMU BCA SEM 4 (OLD) FALL 2014 ASSIGNMENTS

SMU BCA SEM 4 (OLD) FALL 2014 ASSIGNMENTS

BC0047, JAVA PROGRAMMING

1 Describe about the primitives and derived data types in java.

2 What are exception classes? Explain the common exceptions in Java.

3 Explain the methods of InputStream class and OutputStream class.

4 Explain servlets and servlet life cycle.

Practical Assignments
5 Write a Java program to find the sum of 1+3+5+…. ,for 10 terms in the series.

6 Write a program in Java to check whether a given year is leap year or not.


BC0048-COMPUTER NETWORKS

1 Explain
i. Broadcast links
ii. Point-to-point links

2 Write short notes on: (i) Simplex (ii) Half Duplex (iii) Full Duplex with examples and necessary figures.

3 What is transmission medium? List the factors used to determine Data rate and distance.

4 Explain different types of routing algorithms depending upon the communication subnet.

5 Define CSMA and write notes on (i) Non-Persistent CSMA (ii) 1-Persistent CSMA

6 Explain the T.C.P Header format.


BC0049 – SOFTWARE ENGINEERING

1 Explain RAD model?
What are the drawbacks of Rapid Application Development (RAD)?

2 What do you mean by software reuse? Describe software development with use.

3 Explain in brief all the types of object models.

4 Explain White-Box testing?

5 What is Verification and Validation? Explain the Validation Test Criteria.

6 What is Top-down integration and Bottom-up integration?

BC0050– Oracle & Distributed Databases

1 What are the different methods used to recognize user defined exceptions in PL/SQL?

2 Write short notes on the following:
1. Background Processes of oracle instance
2. The Program Global Area (PGA)

3 Explain the following Logical Storage Structures.
(a) Table space
(b) Segment

4 List the characteristics of Query processor and explain them all.

Practical
5 Write a PL/SQL block:
A. That includes declarations for the following variables:
1. A varchar2 datatype that can contain the string “ introduction to oracle PL/SQL”
2. A number that can be assigned 987654.55, but not 987654.567 or 9876543.55
3. A constant that is auto-initialized to the value 603D
4. A Boolean
5. A DATE data type auto initialized to one week from today.
B. In the body of PL/SQL block, put a DBMS_OUTPUT.PUT_LINE message for each of the variables that received an auto initialized value.
C. In a comment at the bottom of PL/SQL block, state the value of your number datatype.

6 Write a cursor to open an employee database and fetch the employee record whose age is greater than 45.

BC0051 – SYSTEM SOFTWARE

1 Write short notes on lexical analysis, syntax analysis, and semantic analysis

2 Write short notes on: Declaration statements and Assembler Directives.

3 Write any 5 difference between Compiler and Interpreter.

4 How does C program works with linker?

5 (a) Define loader
(b) What is relocation? Explain how relocation is done.

6 What is the role of compilers in Error Detection and Recovery?