SQL User Defined Functions External Functions Stored Procedures DDL

Question 1

ALTER FUNCTION

Answer 1

Modifies the properties of an existing user-defined or external function.

Question 2

ALTER PROCEDURE

Answer 2

Modifies the properties for an existing stored procedure.

Question 3

CREATE EXTERNAL FUNCTION

Answer 3

Creates a newexternal function.

Question 4

CREATE FUNCTION

Answer 4

Creates a newUDF (user-defined function).

Question 5

CREATE PROCEDURE

Answer 5

Creates a newstored procedure.

Question 6

DESCRIBE FUNCTION

Answer 6

Describes the specified user-defined function (UDF) or external function, including the signature (i.e. arguments), return value, language, and body (i.e. definition).

Question 7

DESCRIBE PROCEDURE

Answer 7

Describes the specified stored procedure, including the stored procedure’s signature (i.e. arguments), return value, language, and body (i.e. definition).

Question 8

DROP FUNCTION

Answer 8

Removes the specified user-defined function (UDF) or external function from the current/specified schema.

Question 9

DROP MATERIALIZED VIEW

Answer 9

Removes the specified materialized view from the current/specified schema.

Question 10

DROP PROCEDURE

Answer 10

Removes the specified stored procedure from the current/specified schema.

Question 11

SHOW EXTERNAL FUNCTIONS

Answer 11

Lists all the external functions created for your account.

Question 12

SHOW PROCEDURES

Answer 12

Lists the stored procedures that you have privileges to access.

Question 13

SHOW USER FUNCTIONS

Answer 13

Lists all user-defined functions (UDFs) for which you have access privileges.