When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
A . The Pipe load history is reset to empty
B. The REFRESH parameter is set to TRUE
C. Previously loaded files will be ignored
D. All of the above

View Answer

Answer: D

Explanation:

When a pipe is recreated using the CREATE OR REPLACE PIPE command, the following will happen:

The pipe load history is reset to empty.

The REFRESH parameter is set to TRUE.

Previously loaded files will be ignored.

This command allows you to replace the existing pipe with a new one while maintaining its name and any associated metadata.