nerdexam
Oracle

1Z0-931-20 · Question #32

What is the correct way to list all files in the default data pump directory?

The correct answer is A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'). Explanation/Reference:

Loading and Transforming Data

Question

What is the correct way to list all files in the default data pump directory?

Options

  • ABy executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
  • BYou cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
  • CLog onto ADW server and issue is -al on the command line.
  • DBy executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;

How the community answered

(24 responses)
  • A
    79% (19)
  • B
    4% (1)
  • C
    4% (1)
  • D
    13% (3)

Explanation

Explanation/Reference:

Topics

#DBMS_CLOUD#LIST_FILES#DATA_PUMP_DIR#Data Pump

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice