Sunday, 4 September 2016

Assignment July - 2016 & January - 2017 MCS-051

MCS-051


1.     (a)   A business organization has a telephone directory that records details of every employee working in the organization in form of empid, empfirstname, designation, age and email address. Every employee is attached to a particular department which is the main organizing unit of the organization. The telephone directory is typically displayed in department order hierarchy and shows for each department the contact phone, fax number and email address.

                Create an XML file containing some directory data. Also give reasons for using XML. In what ways are XML DTD and Schema are similar to or different from each other.

                [Note: Show at least two departments and five employees in each department in the XML file.] (7 Marks)

        (b)   What do you mean by XML parsing ? (3 Marks)

2.     (a)   Make a very simple online banking application that collects a customer ID and inputs the first name, last name and bank account balance of the customer with that ID. It should give an error page for an unknown ID. Data is stored in Oracle database. Write the programe using Servlet and JDBC. (7 Marks)

        (b)   Write in brief how do you use JDBC to query and modify a database. (3 Marks)

3.     (a)   Make a course registration form using JSP that collects a first name, last name, contact no. Email address, age and course name.

                (i)    Validate it if the user name, and e-mail address are not blank. Display error message to user, if either of them is blank.
                (ii)   Validate if the user name already exists and display an error message to the user.
                (iii)  Create text boxes for first name, last name, contact number, email address, age and course name.
                (iv)  Use 3 check boxes for multiple selection.
                (v)   Send the registration information to a Servlet that stores data in Oracle database and displays it. (use HTTP post method)

        (b)   What is a customer tag in JSP ? Explain. (3 Marks)

4.     Assume there is a course registration table with the following fields student_id, name, course name, email address. Add at least 10 records. Write and run a Java programe to make queries to the course registration table and modify it using JDBC APIs. (7 Marks)

5.     What are the advantages of using Java’s multiple layer security implementation ? Explain with the help of an example programe. (8 Marks)

6.     (a)   Describe the layer architecture of EJB and explain all its components briefly. (7 Marks)

        (b)   What is the advantage of using Entity bean over directly using JDBC API to do database operations. (5 Marks)
        7.     What do you mean by session tracking ? Also explain in brief different ways to handle session tracking ? (5 Marks)

        8.     Explain four basic mechanisms which a web client can authenticate a user to a web server during HTTP authentication.


*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question paper with Assignment solutions)
9825183881
 ****************************************************************

No comments:

Post a Comment