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 listener is not listening on the default port 1521

B.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

C.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

D.The service DB01.abc.com is dynamically registered

E.The service DB01.abc.com is statically registered

A.It is available only when the database is open

B.It can be used to perform database recovery

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

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

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

A.undo

B.index

C.stored procedures

D.sequences

E.tables

F.clusters

A.To shrink a table it must have a PRIMARY KEY constraint

B.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

C.To shrink a table it must have a UNIQUE KEY constraint

D.It is not possible to shrink either indexes or Index Organized Tables (IOTs)

E.It always eliminates all migrated rows if any exist in the table

F.To shrink a table it must have row movement enabled