READ Free Dumps For Oracle- 1z0-067
Question ID 22093 | Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval. |
Option A | Minimal supplemental logging must be enabled. |
Option B | The database must be running in archivelog mode. |
Option C | Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user. |
Option D | The flashback any table privilege must be granted to the user. |
Option E | The select any transaction privilege must be granted to the user. |
Option F | The recycle bin parameter must be set to on. |
Correct Answer | C,D,E |
Question ID 22094 | Examine these Data Pump commands to export and import objects from and to the same database. |
Option A | expdp will fail because no path has been defined for the dumpfile. |
Option B | expdp will succeed but impdp will fail because the users do not exist. |
Option C | inpdp will create two users called hr1 and oe1 and import all objects to the new schemas. |
Option D | impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively. |
Correct Answer | C |