Java Fundamental-VIII

1. What is J2EE?

J2EE is an environment for developing and deploying enterprise applications. The J2EE platform consists of a set of services, application programming interfaces (APIs), and protocols that provide the functionality for developing multi tiered, and web-based applications.

2. What is the J2EE module?

A J2EE module consists of one or more J2EE components for the same container type and one component deployment descriptor of that type.

3. What are the components of J2EE application?

A J2EE component is a self-contained functional software unit that is assembled into a J2EE application with its related classes and files and communicates with other components. The J2EE specification defines the following J2EE components:

o Application clients and applets are client components.

o Java Servlets and Java Server Pages TM (JSPTM) technology components are web components.

o Enterprise JavaBeansTM (EJBTM) components (enterprise beans) are business components.

o Resource adapter components provided by EIS and tool vendors.

4. What are the four types of J2EE modules?

1. Application client module

2. Web module

3. Enterprise JavaBeans module

4. Resource adapter module

5. What does application client module contain?

The application client module contains:

o class files,

o an application client deployment descriptor.

Application client modules are packaged as JAR files with a .jar extension.

6. What does Enterprise JavaBeans module contain?

The Enterprise JavaBeans module contains:

o class files for enterprise beans

o An EJB deployment descriptor.

EJB modules are packaged as JAR files with a .jar extension.

7. What does resource adapt module contain?

The resource adapt module contains:

o all Java interfaces,

o classes,

o native libraries,

o other documentation,

o A resource adapter deployment descriptor.

Resource adapter modules are packages as JAR files with a .rar (Resource adapter Archive) extension.

8. Is J2EE application only a web-based?

NO. A J2EE application can be web-based or non-web-based. If an application client executes on the client machine, it is a non-web-based J2EE application. The J2EE application can provide a way for users to handle tasks such as J2EE system or application administration. It typically has a graphical user interface created from Swing or AWT APIs, or a command-line interface. When user request, it can open an HTTP connection to establish communication with a Servlet running in the web tier.

Database System-V

1. What is View?

A simple view can be thought of as a subset of a table. It can be used for retrieving data, as well as updating or deleting rows. Rows updated or deleted in the view are updated or deleted in the table the view was created with. It should also be noted that as data in the original table changes, so does data in the view, as views are the way to look at part of the original table. The results of using a view are not permanently stored in the database . The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.

2. What is Index?

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application.
A table scan happens when there is no index available to help a query. In a table scan SQL Server examines every row in the table to satisfy the query results. Table scans are sometimes unavoidable, but on large tables, scans have a terrific impact on performance. Clustered indexes define the physical sorting of a database table’s rows in the storage media. For this reason, ea ch database table may have only one clustered index. Non-clustered indexes are created outside of the database table and contain a sorted list of references

to the table itself.

3. What is the difference between clustered and a non-clustered index?

A clustered index is a special type of index that reorders the wa y records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

4. What are the different index configurations a table can have?

A table can have one of the following index configurations:

a. No indexes

b. A clustered index

c. A clustered index and many nonclustered indexes

d. A nonclustered index

e. Many nonclustered indexes

5 .What is cursors?

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. In order to work with a cursor we need to perform some steps in the following order:

a. Declare cursor

b. Open cursor

c. Fetch row from the cursor

d. Process fetched row

e. Close cursor

f. Deallocate cursor