Which conditions among the following must be met, if the tablespace is to be made read only?

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?

What is the priority level for a job in a job class?

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?