A.A role can be granted to other roles.

B.All roles belong to the SYSTEM schema.

C.Roles can be created only by SYS or SYSTEM.

D.A role can be password-protected only if it has been granted system privileges.

E.Roles containing object privileges can be created only by the object owner.

A.It registers database services with all local and remote listeners known to the database instance

B.It frees resources held by abnormally terminated processes

C.It records checkpoint information in the control file

D.It frees unused temporary segments

E.It kills sessions that exceed idle time

A.user process failure

B.transaction failure

C.media failure

D.statement failure

E.network interface card (NIC) failure

A.Alter user KING to be IDENTIFIED EXTERNALLY

B.Grant DBA to KING

C.Set OS_AUTHEN_PREFIX to OPS$

D.Unset REMOTE_LOGIN_PASSWORDFILE

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

A.The WITH CHECK clause prevents certain rows from being displayed when querying the view

B.Data Manipulation Language (DML) can always be used on views

C.The WITH CHECK clause prevents certain rows from being updated or inserted

D.Tables in the defining query of a view must always exist in order to create the view

E.Views can be updated without the need to re-grant privileges on the view

F.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

G.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error