PrepAway - Latest Free Exam Questions & Answers

what happens to the temporary table and any data stored in it?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
The data in the table is deleted and the table persists.

B.
The data in the table is deleted and the table is implicitly dropped.

C.
The temporary table is converted to a base table and the data is deleted.

D.
The temporary table is converted to a base table and the data is persistent.

Explanation:


Leave a Reply