Tag: databases

All rows of the Employee table

Rows of the Employee table where the set grade is ‘Y’

Delete 1 row

Nothing will be deleted

CHECK keyword

WITH CHECK keyword

WITH CHECK OPTION keyword

None of the Above

INSERT statement

UPDATE statement

Both of the Above

None of the Above

Avoids separate updates

ncreases performance and ease of use

Is useful in data warehousing applications

All of the above

COMMIT or ROLLBACK

A DDL or DCL statement executing

USER exiting iSQL*Plus or System crash

Any one of the above

True

False

Count

Avg

Total

Max

True

False

No. of rows in a table

No. of rows with non-null values of the expr

No. of distinct non-null values of the expr

None of the above

Group By

NVL

Order By

Having