Which of the following sets of tablespaces is mandatory for any Oracle 10g database?

For which two tasks would it be best not to use the utility SQL*Loader?

Which one is true if the alter tablespace statement is used and the TEMPORARY clause is specified?

What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?

Which conditions should be met before a RENAME DATAFILE with the alter tablespace command is used?

A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?

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

Which initialization parameters would belong to the basic group of parameters?

What are the functions of an ASM instance?

What is the default value for the OPTIMIZER_MODE initialization parameter?

Which command revokes the ROLE_DATA role from all the users?