SQL Account & Session DDK Flashcards

1
Q

ALTER ACCOUNT

A

Modifies an account.

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

ALTER CONNECTION

A

Modifies the properties for an existing connection.

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

ALTER FAILOVER GROUP

A

Modifies the properties for an existingfailover group.

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

ALTER REPLICATION GROUP

A

Modifies the properties for an existingreplication group.

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

ALTER SESSION

A

Sets parameters that change the behavior for the current session.

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

CREATE ACCOUNT

A

Creates a new account in your organization.

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

CREATE CONNECTION

A

Creates a new connection in the account.

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

CREATE FAILOVER GROUP

A

Creates a new failover group of specified objects in the system.

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

CREATE MANAGED ACCOUNT

A

Creates a new managed account.

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

CREATE REPLICATION GROUP

A

Creates a new replication group of specified objects in the system.

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

DESCRIBE RESULT

A

Describes the columns in the result of a query.

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

DESCRIBE TRANSACTION

A

Describes thetransaction, including the start time and the state (running, committed, rolled back).

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

DROP CONNECTION

A

Removes a connection from the account.

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

DROP FAILOVER GROUP

A

Removes a failover group from the account.

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

DROP MANAGED ACCOUNT

A

Removes a managed account, including all objects created in the account, and immediately restricts access to the account.

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

DROP REPLICATION GROUP

A

Removes areplication groupfrom the account.

17
Q

SET

A

Initializes the value of asession variableto the result of a SQL expression.

18
Q

SHOW CONNECTIONS

A

Lists the connections for which you have access privileges.

19
Q

SHOW DATABASES IN FAILOVER GROUP

A

Lists databases in a failover group.

20
Q

SHOW DATABASES IN REPLICATION GROUP

A

Lists databases in a replication group.

21
Q

SHOW FAILOVER GROUPS

A

Lists each primary or secondary failover group in this account.

22
Q

SHOW FUNCTIONS

A

Lists all the native (i.e. system-defined/built-in) scalar functions provided by Snowflake, as well as any user-defined functions (UDFs) or external functions that have been created for your account.

23
Q

SHOW GLOBAL ACCOUNTS

A

Lists all the accounts in your organization that are enabled for replication and indicates the Snowflake Region in which each account is located.

24
Q

SHOW MANAGED ACCOUNTS

A

Lists the managed accounts created for your account.

25
Q

SHOW ORGANIZATION ACCOUNTS

A

Lists all the accounts in your organization, excludingmanaged accounts.

26
Q

SHOW PARAMETERS

A

Lists all the account, session, and object parameters that can be set, as well as the current and default values for each parameter.

27
Q

SHOW REGIONS

A

Lists all theregionsin which accounts can be created.

28
Q

SHOW REPLICATION ACCOUNTS

A

Lists all the accounts in your organization that are enabled for replication and indicates theregionin which each account is located.

29
Q

SHOW REPLICATION DATABASES

A

Lists all the primary and secondary databases (i.e. all databases for which replication has been enabled) in your organization and indicates theregionin which each account is located.

30
Q

SHOW REPLICATION GROUPS

A

Lists each primary or secondary replication or failover group in this account.

31
Q

SHOW SHARES IN FAILOVER GROUP

A

Lists shares in a failover group.

32
Q

SHOW SHARES IN REPLICATION GROUP

A

Lists shares in a replication group.

33
Q

SHOW VARIABLES

A

Lists allvariablesdefined in the current session.

34
Q

UNSET

A

Drops asession variable.