Final answer:
The scope of a derived table in SQL is limited to the statement in which it's defined. It is a temporary table that cannot be used outside of that specific SQL statement and ceases to exist after the statement's execution.
Step-by-step explanation:
The scope of a derived table is an important concept in SQL, which is a part of database management in the field of Computers and Technology. In SQL, a derived table (also known as a subquery) can be likened to a temporary table that is used only within the context of a larger query.
Regarding the options provided, the correct answer is that the scope of a derived table is limited to the statement in which it's defined. Once that SQL statement is executed, the derived table ceases to exist and cannot be referenced in any subsequent statements, even if they are part of the same batch, script, or database session.