To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) Temporary space is spool space currently not used - This option is incorrect because temporary space is not the same as spool space. Temporary space refers to disk space that is allocated for temporary storage during query execution, while spool space is a specific type of temporary space used for intermediate query processing.
Option B) Temporary space is permanent space currently not used - This option is correct because temporary space refers to disk space that is allocated for temporary storage during query execution. It is called temporary because it is not permanent storage and is only used temporarily while the query is being executed. This option accurately describes the nature of temporary space.
Option C) Temporary space is subtracted from SysAdmin - This option is incorrect because temporary space is not subtracted from SysAdmin. SysAdmin refers to the system administrator, who is responsible for managing the database system, including allocating resources such as disk space. Temporary space is allocated separately and is not subtracted from the resources allocated to SysAdmin.
Option D) Temporary space is assigned at the table level - This option is incorrect because temporary space is not assigned at the table level. Temporary space is allocated at the system level and is used for temporary storage during query execution. It is not specific to any particular table.
The correct answer is B) Temporary space is permanent space currently not used. This option is correct because it accurately describes temporary space as disk space that is allocated for temporary storage during query execution, but is not permanent and is only used temporarily.