A.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

B.A column that is set to UNUSED still counts towards the limit of 1000 columns per table

C.Partition key columns cannot be dropped.

D.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.

E.A DROP COLUMN command can be rolled back

F.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

A.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

B.It generates a sql script that it uses to load data from EMP.DAT to EMP

C.It overwrites data in EMP with data in EMP.DAT

D.It appends data from EMP.DAT to EMP

E.It uses the database buffer cache to load data

A.It must be smaller than the smallest BIGFILE tablespace

B.Free space is managed using freelists

C.Any data files added to the tablespace must have a size of 5 gigabytes

D.It uses the database default blocksize

E.It is a locally managed tablespace

A.They can be used only in the WHERE clause of a SELECT statement

B.The argument can be a column name, variable, literal or an expression

C.The data type returned can be different from the data type of the argument

D.They can be nested to any level

E.They can accept only one argument

F.They return a single result row per table

A.It Is the default behavior for tables and indexes.

B.Sessions may dynamically switch back and forth from deferred to immediate segment creation.

C.It is supported for SYS-owned tables contained in locally managed tablespaces.

D.It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

E.Indexes inherit the deferred or immediate segment creation attribute from their parent table