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?

Which ones are considered types of segments?

Examine the following SQL statement: CREATE TABLESPACE userdata DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

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?

In Oracle 10g, what is the default value for the initialization parameter 'RESUMABLE_TIMEOUT'?

Where is the trace file generated when a deadlock shutdown is detected by Oracle?