Tag: technology

Strong Query Language

Standard Query Language

Strict Query Language

Structured Query Language

The name of the table we are selecting from

list of columns to be selected

Definition of the condition to be met for the rows to be returned

None of above

The primary key column is a column or combination of columns whose values can be non-unique

The primary key is a column or combination of columns whose values uniquely identify each row in the table

The primary key is a column that can have NULL values

all of above

An index is the same as alias

An index is a database table attribute, which speeds-up data search within a table

An index is a special way to join 2 or more tables

None of above

A view is a special stored procedure executed when certain event occurs

A view is a database diagram

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are

All of above

They are components.

A container manages them.

More than one of them can be combined in a single program (not application).

They live on the server side of an application.

They can be part of a transaction.

Acknowledge receipt of the request to the client

Start a transaction

Check security for the client

Discard the request.

Directly and immediately pass the request to the bean's methods.

There is a many-to-one relationship between the client and the session bean instance.

Session bean instances live forever.

The container may discard the bean instance arbitrarily, when and if it needs to, for performance reasons.

Stateful session beans may have initial state information passed to them from the client when they are created.

Stateful session bean intances are created when the bean is deployed in the container.

Clients of entity beans have a one-to-one relationship with entity bean instances.

Entity bean instances may not be discarded by the container if it needs to free up resources.

Each entity bean instance has a unique identity.

Entity beans map to one or more pieces of data, each one of which has a unique primary key.

None of above

True

False