A.It ignores NULLs

B.It processes NULLs in the selected columns

C.Multiple INTERSECT operators are not possible in the same SQL statement

D.INTERSECT is of lower precedence than UNION or UNION ALL

A.It can be used to switch a database into ARCHIVELOGMODE

B.It can be used to perform database recovery

C.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

D.It is available only when the database is open

E.The same port number can be used for Database Express configurations for databases on different hosts

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

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

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

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

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

A.The Oracle join syntax supports creation of a Cartesian product of two tables

B.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

C.The SQL:1999 compliant ANSI join syntax supports natural joins

D.The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

E.The Oracle join syntax only supports right outer joins

F.The Oracle join syntax supports natural joins

G.The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

A.ROW STORE COMPRESS ADVANCED

B.COLUMN STORE COMPRESS FOR QUERY LOW

C.COLUMN STORE COMPRESS FOR ARCHIVE LOW

D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E.ROW STORE COMPRESS BASIC