If ownership of an external table is transferred to a different role, what happens to AUTO_REFRESH by default?

• A. TRUE
• B. FALSE
• C. It remains unchanged
• D. RESET to TRUE

Answer: (A)

Ownership changes do not reset or modify the table’s settings. AUTO_REFRESH is a property of the external table and stays as it was configured. For external tables, AUTO_REFRESH defaults to TRUE when the table is created, so if it hasn’t been changed previously, transferring ownership leaves it as TRUE. If it had been set to FALSE before the transfer, it would remain FALSE. In short, the default behavior is that AUTO_REFRESH remains TRUE after ownership is transferred.