Under what conditions the use of entity beans is done? Describe the entity beans methods to update and destroy a database.
See Answer →Differentiate between HTML and XML with the help of an example.
See Answer →Describe External Entity, Internal Entity and Parameter Entity in XML with suitable Example of each
See Answer →Retrieve login records from database using JSP
See Answer →Create a login page using JSP and JDBC. Database is to be created in Oracle
See Answer →Explain how an Applet is included in a JSP program with the help of a small code
See Answer →Explain different types of JDBC drivers and their advantages.
See Answer →Create a simple JSP page which includes declaration, scriplets, expressions and comments tag in it.
See Answer →What is a cookie? Differentiate cookie with a session.
See Answer →Write appropriate triggers, exceptions and functions for the above employee database schema.
See Answer →Create the procedures for the above queries.
See Answer →Perform following queries using SQL:
(i) Find details of dependents for employee having name AJAY.
(ii) Find the name of the manager of the department in which employee with ESSN Code 5078 works.
(iii) Find the name of all employees whose age is less than 18 years.
(iv) Find the DOB of the son of the employee having employee code ESSN 5078.
(v) Find the details of the departments in which the employee having employee code ESSN 5078 has worked
See Answer →Create the appropriate database.
See Answer →Consider the following employee database schema:
EMPLOYEE (ESSN, ENAME, DEPT_NO, SALARY) DEPENDENT (ESSN, DEPEND_NAME, RELATION, DOB) DEPARTMENT (DEPT_NO, DEPT_NAME, MANAGER)
See Answer →Write a shell script to display the largest element in a given 4X4 matrix.
See Answer →Write a shell script to find the day of the week when a date is given.
See Answer →Write a shell program to count no. of lines, no. of blank spaces and no. of characters and number of words in a given file by the user.
See Answer →Write the UNIX commands for the following: (a) To display the first 10 lines in a given file.
(b) To kill a particular process with a PID.
(c) To append the contents of xyz after the contents of the abc and redirect them to a new mnp.
(d) To print the first difference between any two given files.
(e) To change the command prompt from $ to *.
(f) To grant the permissions of read, write and execute to the user and read and write only to the group and others for all the files in a current directory.
(g) To direct a standard output to any of the line printer.
(h) To list all the files in the current directory whose file names starts with c.
(i) To execute some command even after logout
(j) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.
See Answer →Design various unit test cases for different testing techniques/strategies.
See Answer →Create the system flow chart or detailed process design and state transition diagrams. Also design the user input screens and output report formats.
See Answer →