exec DBMS_STATS.UNLOCK_SCHEMA_STATS('TABLE_NAME','OWNER');

exec DBMS_STATS.UNLOCK_SCHEMA_STATS('OWNER','TABLE_NAME');

exec DBMS_STATS.UNLOCK_DB_STATS('DB_NAME','OWNER','TABLE_NAME');

exec DBMS_STATS.UNLOCK_TABLE_STATS('TABLE_NAME','OWNER');

exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');

True

False

colons

parentheses

commas

semi-colons

True

False

True

False

Indexes

Hints

Tables

Bitmaps

left join

right join

outer join

equil join

simple join

left outer join

inner join

equil join

right outer join

This is hard to determine

One or more scalar typed object attributes of a cluster

One or more columns of a table

A nested table storage table

outer join

equil join

simple join

right join

left join

when two tables in a join query have only a single join condition

when two tables in a join query have too many join conditions

This is hard to determine.

when two tables in a join query have no join condition

True

False

True

False

True

False

BLOB

CLOB

BFILE

NCLOB

CLOB

BLOB

NCLOB

ALL

A is correct

B is correct

A & B Both correct

A & B both Incorrect

BINARY_FLOAT

BINARY_DOUBLE

ROWID

NCHAR

BLOB

CLOB

NCLOB

BFILE

ALL

MicroStrategies

Actuate

Siebel Analytics

Cognos DecisionStream