Which of the below commands lists all the pipes for which you have access?

Which of the below commands lists all the pipes for which you have access?
A . Display Pipes()
B. SHOW PIPES()
C. LIST PIPES()
D. LIST @PIPES

View Answer

Answer: B

Explanation:

SHOW PIPES

Lists the pipes for which you have access privileges. This command can be used to list the pipes for a specified database or schema (or the current database/schema for the session), or your entire account.