SQL Database Schema Share DDL Flashcards

1
Q

ALTER DATABASE

A

Modifies the properties for an existing database.

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

ALTER SCHEMA

A

Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).

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

ALTER SHARE

A

Modifies the properties for an existingshare.

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

CREATE DATABASE

A

Creates a new database in the system.

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

CREATE SCHEMA

A

Creates a new schema in the current database.

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

CREATE SHARE

A

Creates a new,emptyshare.

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

DESCRIBE DATABASE

A

Describes the database.

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

DESCRIBE SCHEMA

A

Describes the schema.

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

DESCRIBE SHARE

A

Describes the data objects that are included in ashare.

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

DROP DATABASE

A

Removes a database from the system.

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

DROP SCHEMA

A

Removes a schema from the current/specified database.

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

DROP SHARE

A

Removes the specifiedsharefrom the system and immediately revokes access for all consumers (i.e. accounts who have created a database from the share).

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

SHOW DATABASES

A

Lists the databases for which you have access privileges across your entire account, including dropped databases that are still within the Time Travel retention period and, therefore, can be undropped.

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

SHOW SCHEMAS

A

Lists the schemas for which you have access privileges, including dropped schemas that are still within the Time Travel retention period and, therefore, can be undropped.

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

SHOW SHARES

A

Lists allsharesavailable in the system.

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

UNDROP DATABASE

A

Restores the most recent version of a dropped database.

17
Q

UNDROP SCHEMA

A

Restore the most recent version of a dropped schema.

18
Q

USE DATABASE

A

Specifies the active/current database for the session.

19
Q

USE SCHEMA

A

Specifies the active/current schema for the session.

20
Q

CREATE<object> … CLONE</object>

A

Creates a copy of an existing object in the system.