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 three statements among the following are true about rebuilding indexes?

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?

What will happen if you set the value of the SGA_TARGET parameter higher than the value of the SGA_MAX_ SIZE parameter at instance startup?