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 the table data and the view definitions where the 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 all of the table structures and the view definitions with data where view name contains a string named DEPARTMENTS.