Q
Which statement creates the directory object needed by Data Pump?
-
A
CREATE DIRECTORY dp_dir AS '/u01/dump';
-
B
CREATE FOLDER dp_dir AT '/u01/dump';
-
C
MKDIR dp_dir '/u01/dump';
-
D
ALTER SYSTEM ADD DIRECTORY '/u01/dump';
Correct Answer:
A. CREATE DIRECTORY dp_dir AS '/u01/dump';
Explanation:
Data Pump reads and writes dump files only through database DIRECTORY objects.
