What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?

Which conditions should be met before a RENAME DATAFILE with the alter tablespace command is used?

A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?

How can the SQL Access Advisor be managed?

If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?

Which command would revoke the ROLE_DATA role from all users?

What is the default value for the OPTIMIZER_MODE initialization parameter?

Which command revokes the ROLE_DATA role from all the users?

You want to find the following information about a user: - The expiry date of the user's account - The user's default tablespace name - The user's profile name Which data dictionary view should be queried for the purpose?

Consider the following SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?

Which initialization parameter specifies the location of the alert log file?