SQL Table View Sequence DDL Flashcards

1
Q

ALTER EXTERNAL TABLE

A

Modifies the properties, columns, or constraints for an existing external table.

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

ALTER MASKING POLICY

A

Replaces the existing masking policy rules with new rules or a new comment and allows the renaming of a masking policy.

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

ALTER MATERIALIZED VIEW

A

Alters a materialized view in the current/specified schema.

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

ALTER ROW ACCESS POLICY

A

Modifies the properties for an existing row access policy, including renaming the policy or replacing the policy rules.

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

ALTER SEQUENCE

A

Modifies the properties for an existing sequence.

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

ALTER TABLE

A

Modifies the properties, columns, or constraints for an existing table.

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

ALTER TABLE … ALTER COLUMN

A

This topic describes how to modify one or more column properties for a table using anALTERCOLUMNclause in aALTER TABLEstatement.

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

ALTER VIEW

A

Modifies the properties for an existing view.

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

CREATE EXTERNAL TABLE

A

Creates a new external table in the current/specified schema or replaces an existing external table.

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

CREATE MASKING POLICY

A

Creates a new masking policy in the current/specified schema or replaces an existing masking policy.

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

CREATE MATERIALIZED VIEW

A

Creates a new materialized view in the current/specified schema, based on a query of an existing table, and populates the view with data.

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

CREATE ROW ACCESS POLICY

A

Creates a new row access policy in the current/specified schema or replaces an existing row access policy.

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

CREATE SEQUENCE

A

Creates a new sequence, which can be used for generating sequential, unique numbers.

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

CREATE TABLE

A

Creates a new table in the current/specified schema or replaces an existing table.

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

CREATE | ALTER TABLE … CONSTRAINT

A

This topic describes how to create constraints by specifying aCONSTRAINTclause in aCREATE TABLEorALTER TABLEstatement.

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

CREATE VIEW

A

Creates a new view in the current/specified schema, based on a query of one or more existing tables (or any other valid query expression).

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

DESCRIBE EXTERNAL TABLE

A

Describes the VALUE column and virtual columns in an external table.

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

DESCRIBE MASKING POLICY

A

Describes the details about a masking policy, including the creation date, name, data type, and SQL expression.

19
Q

DESCRIBE MATERIALIZED VIEW

A

Describes the columns in a materialized view.

20
Q

DESCRIBE ROW ACCESS POLICY

A

Describes a row access policy, including the creation date, name, data type, and SQL expression.

21
Q

DESCRIBE SEARCH OPTIMIZATION

A

Describes thesearch optimization configurationfor a specified table and its columns.

22
Q

DESCRIBE SEQUENCE

A

Describes a sequence, including the sequence’s interval.

23
Q

DESCRIBE TABLE

A

Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table.

24
Q

DESCRIBE VIEW

A

Describes the columns in a view (or table).

25
Q

DROP EXTERNAL TABLE

A

Removes an external table from the current/specified schema.

26
Q

DROP MASKING POLICY

A

Removes a masking policy from the system.

27
Q

DROP ROW ACCESS POLICY

A

Removes a row access policy from the system.

28
Q

DROP SEQUENCE

A

Removes a sequence from the current/specified schema.

29
Q

DROP TABLE

A

Removes a table from the current/specified schema, but retains a version of the table so that it can be recovered usingUNDROP TABLE.

30
Q

DROP VIEW

A

Removes the specified view from the current/specified schema.

31
Q

SELECT

A

SELECT can be used as either a statement or as a clause within other statements.

32
Q

SHOW COLUMNS

A

Lists the columns in the tables or views for which you have access privileges.

33
Q

SHOW EXTERNAL TABLES

A

Lists the external tables for which you have access privileges.

34
Q

SHOW MASKING POLICIES

A

Lists masking policy information, including the creation date, database and schema names, owner, and any available comments.

35
Q

SHOW MATERIALIZED VIEWS

A

Lists the materialized views that you have privileges to access.

36
Q

SHOW OBJECTS

A

Lists the tables and views for which you have access privileges.

37
Q

SHOW PRIMARY KEYS

A

Lists primary keys for the specified table, or for all tables in the current or specified schema, or for all tables in the current or specified database, or for all tables in the current account.

38
Q

SHOW ROW ACCESS POLICIES

A

Lists the row access policies for which you have access privileges.

39
Q

SHOW SEQUENCES

A

Lists all the sequences for which you have access privileges.

40
Q

SHOW TABLES

A

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

41
Q

SHOW VIEWS

A

Lists the views, including secure views, for which you have access privileges.

42
Q

TRUNCATE MATERIALIZED VIEW

A

Removes all rows from a materialized view, but leaves the view intact (including all privileges and constraints on the materialized view).

43
Q

UNDROP TABLE

A

Restores the most recent version of a dropped table.