When is SGA created in an Oracle database environment?

What do ASM disk groups provide?

When a deadlock shutdown is detected by Oracle, where is the trace file generated?

Where is the free space managed, for a tablespace created with automatic segment-space management?

Which statement is valid regarding index clusters?

Where can a SQL Tuning Set(STS) be created from?

Which statement about the LOG_BUFFER initialization parameter is true?

Examine the SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_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 1MB?

Which data dictionary view shows the available free space in a certain tablespace?

For which two constraints are indexes created when the constraint is added?

Which memory structure contains the information used by the server process to validate user privileges?