Tag: technology

A WHERE clause can be used to restrict rows only.

A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.

WHERE clause can be used to restrict both rows and groups.

WHere clause filters the columns from the output

It is faster than the Delete operation.

You can roll back the deletion of rows after the statement executes.

You must be the owner of the table or have DELETE ANY TABLE system privileges

It releases the storage space used by the table.

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

The UNIQUE constraint does not permit a null value for the column

The NOT NULL constraint ensures that null values are not permitted for the column

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index

It is automatically used in all INSERT and UPDATE

It is linked to a specific table.

It belongs to a specific schema.

It is automatically available to all users.

ERROR RECOVERY

ROLLBACK

Any one of the above

Both of the above

ERROR RECOVERY

ROLLBACK

None of the above

Both of the above

2

4

1

No Compulsion

DD-MMM-YY

DD-MMM-YYYY

MMM-DD-YY

MMM-DD-YYYY

EXTERNAL

INTERNAL

BOTH

NONE OF THESE

PRODUCTION

CCL

YYY

ANY OF THESE