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 0

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