Where can you find the non-default parameters when the instance is started?

ASM disk groups provide:

Which one helps you identify your statement in the DBA_TUNE_MVIEW view?

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

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

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?

What does the RMAN CATALOG command do?

What are the two main advantages of using bitmap indexes?

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 ones are considered types of segments?

Which three statements among the following are true about rebuilding indexes?