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

What are the two main advantages of using bitmap indexes?

What does the RMAN CATALOG command do?

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?

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

ASM disk groups provide: