A ____ backup creates both DDL commands and DML commands,to re-create a database object (it uses the database SQL engine).
A) tablespace
B) logical
C) physical
D) consistent

Question

Quizplus · Accepted Answer

A logical backup creates commands to re-create the database object using SQL statements, making it independent of the specific hardware and operating system. This type of backup is useful for migrating to a different platform or for creating a test database with the same schema as the production database. A physical backup copies the database files, while a consistent backup ensures that the backup data reflects a consistent state of the database at a point in time. A tablespace backup copies all datafiles in a particular tablespace.

A ____ Backup Creates Both DDL Commands and DML Commands,to