Group By

Where

Select

Having

OPEN

GET

SELECT

EXTRACT

True

False

ARCH

PMON

SMON

RECO

Group functions

Group by clause

Distinct keyword

All of above

Group functions

Group by clause

Distinct keyword

All of the above

respective table data is retained

data is deleted from table

depends on conditions

all of above

Group by clause

Distinct keyword

Pseudo column ROWNUM keyword

All of above

Successful

Results in error

Depends on condition

None

Class object

Schema object

Both

None of the above

It is query with alias name

It is subquery with alias name

Both

None of the above

Unique key

Primary key

Foreign key

All of the above

To get automatic values

For esay access

For fast access

All of the above

A column contains large no of values

A column contains large no of null values

Table is small

When table is not updated frequently

Deletes rows from table

Removes storage space

Removes table structure

All of the above

Candidate key

Member key

Both of above

None of the above

show user

get user

display user

display

set sqlprompt “Ravi Kishore > “

set prompt “Ravi Kishore > “

set sql “Ravi Kishore > “

set sqlpromt “Ravi Kishore > “

host

DOS

doshost

dos host

delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

delete duplicate_values_field_name dv from table_name ta where rowid

delete ename from emp a where rowid < ( select min(rowid) from emp b where a.ename = b.ename);

Delete all