SnowPro Core Certification — Question 1008

Which commands are restricted in owner's rights stored procedures? (Choose two.)

Answer options

• A. SHOW
• B. MERGE
• C. INSERT
• D. DELETE
• E. DESCRIBE

Correct answer: A, E

Explanation

The commands SHOW and DESCRIBE are restricted in owner's rights stored procedures because they provide information about the database schema and structure, which is typically not allowed for security reasons. In contrast, MERGE, INSERT, and DELETE commands are part of data manipulation and are not restricted in the same way.