Question

________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.

(a) Archival

(b) Fuzzy

(c) SQL

(d) All of the mentioned

I have been asked this question by my college director while I was bunking the class.

This intriguing question originated from Failure with Nonvolatile Storage in chapter Recovery System of Database Management

Answer 1

Right answer is (c) SQL

To explain: Such dumps are useful when migrating data to a different instance of the database, or to a different version of the database software, since the physical locations and layout may be different in the other database instance or database software version.