A.Table aliases can improve performance

B.The BETWEEN condition always performs better than using the >= and <= conditions

C.The join syntax used makes no difference to performance

D.The BETWEEN condition always performs less well than using the >= and <= conditions

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

A.The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set

B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

C.It supports diagnostics for Automatic Storage Management (ASM)

D.It supports diagnostics for Oracle Clusterware

E.It is held inside an Oracle database schema

A.FLASHBACK TRANSACTION

B.FLASHBACK QUERY

C.FLASHBACK DATABASE

D.FLASHBACK TABLE TO SCN

E.FLASHBACK DROP

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

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

C.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

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

E.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

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

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

A.Partition key columns cannot be dropped.

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

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

D.An UNUSED column's space is reclaimed automatically when the row 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.A DROP COLUMN command can be rolled back