What are different Session-State Modes

Which Session-State Modes require additional parameters, such as connection-string etc.

Which Session-State Modes makes session state available to multiple Web servers in a Web farm.

aspnet_regsql.exe -S SampleSqlServer -E -ssadd -sstype p
What database will be created with above parameter

aspnet_regsql.exe -S SampleSqlServer -E -ssadd -sstype t
What database will be created with above parameter

aspnet_regsql.exe -S SampleSqlServer -E -ssadd -sstype c
What database will be created with above parameter