Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?

Which two statements are true about rebuilding an index?

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

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

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

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 set of tablespaces is mandatory for any Oracle 10g database?

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

Which statement is valid regarding index clusters?

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

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