A.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

B.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

C.A table can have only one primary key and one foreign key

D.Primary key and foreign key constraints can be defined at both the column and table level

E.Only the primary key can be defined at the column and table level

F.The foreign key columns and parent table primary key columns must have the same names

G.A table can have only one primary key but multiple foreign keys

A.The number of columns in each SELECT in the compound query can be different

B.INTERSECT ignores NULLs

C.Reversing the order of the intersected tables can sometimes affect the output

D.Column names in each SELECT in the compound query can be different

E.INTERSECT returns rows common to both sides of the compound query

A.A single transaction may use multiple undo segments simultaneously

B.Undo segments have a minimum of three extents

C.Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

D.An undo segment may be used by multiple transactions simultaneously

E.Undo segments can extend when a transaction fills the last extent of the undo segment

F.Undo segments must be stored in a BIGFILE tablespace

G.Undo segments must be stored in a SMALLFILE tablespace

A.MOD : returns the quotient of a division operation

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

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

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

E.TRUNC : can be used to combine any number of values

A.COLUMN STORE COMPRESS FOR QUERY LOW

B.ROW STORE COMPRESS BASIC

C.COLUMN STORE COMPRESS FOR ARCHIVE LOW

D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E.ROW STORE COMPRESS ADVANCED