You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.After a few days,

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.After a few days,

Post by answerhappygod »

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.After a few days, you want to alter the EMPLOYEES table by executing the command:SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);Which statement is true about the execution of the command?

A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
C. It executes successfully and continues to store metadata related to the EMPLOYEES table.
D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply