Which three are true about the Oracle Optimizer? (Choose three.)

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

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

C. It can optimize only SELECT statements.

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

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

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

Which two tasks can you perform by using DBCA for a new database?

A. Register it with an available Enterprise Manager Management server.

B. Configure a nonstandard block size.

C. Configure incremental backups.

D. Enable flashback.

E. Create user tablespaces.

Which three statements are true about an spfile? (Choose three)

A. It contains only static initialization parameters.

B. It is the first file processed at instance startup.

C. It can be edited by SYS when the database instance is shut down.

D. It must exist for a database instance to start.

E. It can be used to create a pfile.

F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

Which is true about revoking roles?

A. Only users who are granted the DBA role can revoke a role.

B. Only users who are granted SYSDBA can revoke a role.

C. Users who have the GRANT ANY ROLE privilege can revoke any role.

D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.

E. Users can revoke a role that is granted to them through other roles.

A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

A. in the SYSAUX tablespace

B. in the undo tablespace

C. in the redo logs

D. in rollback segments

E. in the temporary tablespace

In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA. Examine these parameters:

Which tablespace stores UNDO generated by USER1's DML on temporary tables?

A. DATA

B. SYSTEM

C. SYSAUX

D. TEMP

E. UNDOTBS1

Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

A. Third-party tools can be used with database instances in the cloud.

B. Oracle-supplied tools can be used with database instances in the cloud.

C. Database instances in the cloud can be accessed only by using SSH.

D. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.

E. Database instances in the cloud can be accessed only by using Oracle*Net.

Which two are prerequisites for shrinking a table online?

A. It must have a unique key constraint.

B. It must not have any referential integrity constraints.

C. It must not have any DML triggers.

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

E. It must have row movement enabled.

In your database, you create a user, HR, and then execute this command:

Which three actions can HR perform? (Choose three.)

A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.

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

C. Execute DML statements in the HR schema.

D. Log in to the database instance.

E. Revoke the CREATE SESSION privilege from other users.

F. Execute DDL statements in the HR schema.

Which two are true about roles? (Choose two.)

A. The ALTER USER statement must be used to set specific default roles for a user.

B. A role must be disabled before it can be revoked from a user.

C. The SET ROLE statement can be used once per session.

D. The SET ROLE statement enables as well as disables roles in a session.

E. All privileges and roles granted to a user are enabled by default when the user logs in.