When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

Question

Options

• AThe data in the table is deleted and the table persists.
• BThe data in the table is deleted and the table is implicitly dropped.
• CThe temporary table is converted to a base table and the data is deleted.
• DThe temporary table is converted to a base table and the data is persistent.

• A
  14% (5)
• B
  78% (28)
• C
  3% (1)
• D
  6% (2)

No community discussion yet for this question.