Tag: technology

Both USING and ON clauses can be used for equijoins and nonequijoins.

A maximum of one pair of columns can be joined between two tables using the ON clause.

The ON clause can be used to join tables on columns that have different names but compatible data

The WHERE clause can be used to apply additional conditions in SELECT statements containing the

It ignores NULL values.

Reversing the order of the intersected tables alters the result.

The names of columns in all SELECT statements must be identical.

The number of columns and data types must be identical for all SELECT statements in the query.

The process instance name

The process template name

The object ID of the new process instance

A refernce to the BusinessProcess session bean

Client UI Identifier

Process Template Name

Task Instance Object Identifier(TKID)

Staff activity Identifier

Only one LONG column can be used per table.

A TIMESTAMP data type column stores only time values with fractional seconds

The BLOB data type column is used to store binary data in an operating system file.

The minimum column width that can be specified for a VARCHAR2 data type column is one.

The value for a CHAR data type column is blank-padded to the maximum defined column width.

All the above

CREATE TABLE emp*123 (emp_no NUMBER(4));

A table name can be of any length.

A table can have any number of columns.

A table and a synonym can have the same name in the same schema

The same table name can be used in different schemas in the same database

A foreign key cannot contain NULL values.

A column with the UNIQUE constraint can contain NULL values.

A constraint is enforced only for the INSERT operation on a table.

A constraint can be disabled even if the constraint column contains data.

A subquery that defines a view cannot include the GROUP BY clause.

A view that is created with the subquery having the DISTINCT keyword can be updated.

.A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be

A data manipulation language (DML) operation can be performed on a view that is created with the