MCS-051 Advanced Internet Technologies Jan – June 2012

Question 1: Write an application to create a XML document from a university employee database .The XML document should contain the following:

i) Employee code
ii) Employee Name
iii) Designation
iv) Address
v) Department
vi) The last twelve month performance summary

Question 2: Assume there is a student database in Oracle with the following fields:
Student enrollment No.
Student Name
Program
Address
School of Study
Write a code for Servelet which will display all the fields of the student database in the tabular manner.

Question 3: Write a web based student registration application where students can register online with their enrolment number. The registered students should be able to log on to the site after getting registered. You are required to use JSP, Servlet and JDBC.

Question 4: For a shopping website you have to select Entity beans over stateful session beans. Justify your selection criteria.

Question 5: Why is XML more suitable than HTML for use in the web? With the help of an example briefly explain the structure of XML documents and its components

Question 6: Explain SSL and TLS with their working and security measures.

Question 7: What are the advantages of using an Entity Bean for database operations over directly using JDBC API to do the same? When would I need to use one over the other?

Question 8: Explain database handling in JSP using type 2 and type 4 drivers.