Oracle
1Z0-052 · Question #212
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 '
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #212. The question stem and answer options stay visible for context.
Moving Data
Question
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?
Options
- AOracle Data Pump would export only the data of all of the tables and views.
- BOracle Data Pump would export all of the table structures along with data and all the views.
- COracle Data Pump would export the table data and the view definitions where the view name
- DOracle Data Pump would export the table data and the view definitions with data where view name
- EOracle Data Pump would export all of the table structures and the view definitions with data where
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Pump#expdp#include filter#content parameter