A.Execute DML statements in the HR schema

B.Log in to the database instance

C.Revoke the CREATE SESSION privilege from other users

D.Revoke the CREATE SESSION privilege from user HR

E.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

F.Execute DDL statements in the HR schema

A.It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

B.It can re-optimize execution plans after previous executions detect suboptimal plans.

C.It will only generate SQL Plan Directives specific to a given SQL statement.

D.It updates stale object statistics in the Data Dictionary.

E.It can optimize only SELECT statements.

F.It determines the optimal table join order and method.

A.Revoke the CREATE SESSION privilege from other users

B.Revoke the CREATE SESSION privilege from user HR

C.Log in to the database instance

D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.Execute DDL statements in the HR schema

F.Execute DML statements in the HR schema

A.enabling online redo log archiving

B.creating a database

C.renaming data files

D.re-creating control files

E.full database recovery

A.The ON clause must be used

B.The query must use two different aliases for the table

C.It must be an equijoin

D.It must be an inner join

E.The ON clause can be used

F.It can be an outer join