Which of the following 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?

Which one is a new initialization parameter for Oracle Database 10g?

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?

What happens when the DBA disables the flash recovery area?