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.Each SELECT statement in the compound query must have its own ORDER BY clause

B.Column positions must be used in the ORDER BY clause

C.Each SELECT statement in the compound query can have its own ORDER BY clause

D.Only column names from the first SELECT statement in the compound query are recognized

E.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

A.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

B.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

C.The names and number of columns must be identical for all SELECT statements in the query.

D.The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.

E.The number, but not names, of columns must be identical for all SELECT statements in the query.

A.They can be written by server processes

B.Trace files are written to the Fast Recovery Area (FRA)

C.They can be written by background processes

D.All trace files contain error information that require contacting Oracle Support

E.Trace file names are based on the database name concatenated with a sequential number

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

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

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

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

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

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