5432

27017

3306

22

Row

Index

Table

Column

Shard

Index

ObjectId

Replica Set

Cassandra

All of the above

MongoDB

DynamoDB

CREATE PROC proc_name() AS && SELECT * FROM table_name;$$

CREATE FUNCTION func_name() RETURNS VOID AS  LANGUAGE plpgsql;

CREATE PROCEDURE proc_name AS SELECT * FROM table_name; 

CREATE FUNCTION func_name() RETURNS VOID AS  LANGUAGE plpgsql;

Stored procedures run and used for managing administrative activities of SQL Server 

Stored procedures that can return a single value or a set of rows

Stored procedures that can be written in any language supported by the .NET Framework 

Stored procedures that allow you to loop through a SQL statement's result

The stored procedure source code is compiled and optimized

The server processes the execution plan sequentially, dispatching each step to an appropriate internal manager process

The server saves the execution plan to disk for future use

The server resolves object references and creates a query tree

The process of resolving object references the first time the procedure is executed 

The process of recording the procedure's name and other information in the system catalog

The step where the procedure's source code is stored in syscomments for later use

The step where the query tree is constructed and passed to the query optimizer for compilation and optimization