SQL Uncategorized Flashcards

1
Q

CALL

A

Calls astored procedure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

CALL (with Anonymous Procedure)

A

Creates and calls an anonymousprocedure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

EXECUTE IMMEDIATE

A

Executes a string that contains a SQL statement or aSnowflake Scripting statement.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

EXECUTE TASK

A

Manually triggers an asynchronous single run of a scheduled task (either a standalone task or the root task in aDAG (directed acyclic graph)of tasks) independent of the schedule defined for the task.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

EXPLAIN

A

Returns the logical execution plan for the specified SQL statement.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly