Which task would the command accomplish?

User SCOTT wants to export his objects using Oracle Data Pump and executes the
following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp
include = table include = view:”like ‘%DEPARTMENTS%'” content = DATA_ONLY Which
task would the command accomplish?

User SCOTT wants to export his objects using Oracle Data Pump and executes the
following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp
include = table include = view:”like ‘%DEPARTMENTS%'” content = DATA_ONLY Which
task would the command accomplish?

A.
Oracle Data Pump would export all of the table structures along with data and all
the views.

B.
Oracle Data Pump would export all of the table structures and the view definitions
with data where view name contains a string named DEPARTMENTS.

C.
Oracle Data Pump would export only the data of all of the tables and views.

D.
Oracle Data Pump would export the table data and the view definitions with data
where view name contains a string named DEPARTMENTS.

E.
Oracle Data Pump would export the table data and the view definitions where the
view name contains a string named DEPARTMENTS.



Leave a Reply 1

Your email address will not be published. Required fields are marked *