Tag: databases

Some DML,PL/SQL statements

All DML,PL/SQL statements

Only PL/SQL statements

None of the Above

Use ORDER BY clause

Use ROW clause

Use ROW BY clause

None of the Above

2 and 4 are true

1 , 3 and 4 are true

1 and 3 are true

Only 4 is true

Check

Unique

Primary key

not null

Union all used for combining multiples queries using single union all

There is no difference

the union will eliminate duplicate records in result set but, union all will print the duplicate records

Union all is used for select with multiple columns

1 and 2 are correct

All are true

1,2 and 3 are correct

2,3 and 4 are correct

FIRST_ROWS

ALL_ROWS

CHOOSE

COST

True

False

SUM

AVG

trim

median

True

False