A.undo

B.index

C.stored procedures

D.sequences

E.tables

F.clusters

A.Undo segments must be stored in a BIGFILE tablespace

B.Undo segments must be stored in a SMALLFILE tablespace

C.Undo segments have a minimum of three extents

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

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

F.A single transaction may use multiple undo segments simultaneously

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

A.Grant DBA to KING

B.Set OS_AUTHEN_PREFIX to OPS$

C.Alter user KING to be IDENTIFIED EXTERNALLY

D.Unset REMOTE_LOGIN_PASSWORDFILE

E.Have the OS administrator add KING to the OSDBA group

A.Set OS_AUTHENT_PREFIX to OPS$

B.Have the OS administrator add KING to the OSDBA group

C.Grant DBA to KING

D.Unset REMOTE_LOGIN_PASSWORDFILE

E.Alter user KING to be IDENTIFIED EXTERNALLY

A.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

B.SYSDATE can be queried only from the DUAL table

C.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

D.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

E.SYSDATE can be used in expressions only if the default date format is DD-MON-RR

F.CURRENT_DATE returns the current date and time as per the session time zone