A.A DROP COLUMN command can be rolled back

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

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

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

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

F.Partition key columns cannot be dropped.

A.Index block free space is always contiguous in the middle of the block

B.Multiple row pieces from the same row may be stored in different database blocks

C.Multiple row pieces from the same row may be stored in the same block

D.Data block headers contain their own Data Block Address (DBA)

E.A table row piece can be chained across several database blocks

F.Data block free space is always contiguous in the middle of the block

A.MOD : returns the quotient of a division operation

B.FLOOR : returns the smallest integer greater than or equal to a specified number

C.TRUNC : can be used with NUMBERand DATEvalues

D.CONCAT : can be used to combine any number of values

E.CEIL : can be used for positive and negative numbers

A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

B.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

C.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

D.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

F.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

A.Data block headers contain their own Data Block Address (DBA)

B.A table row piece can be chained across several database blocks

C.Multiple row pieces from the same row may be stored in different database blocks

D.Multiple row pieces from the same row may be stored in the same block

E.Data block free space is always contiguous in the middle of the block

F.Index block free space is always contiguous in the middle of the block