Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Commands, Statements and Functions > SQL Commands > Flashcards

SQL Commands Flashcards

1
Q

ABORT

A

abort the current transaction

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

ALTER AGGREGATE

A

change the definition of an aggregate function

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

ALTER COLLATION

A

change the definition of a collation

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

ALTER CONVERSION

A

change the definition of a conversion

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

ALTER DATABASE

A

change a database

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

ALTER DEFAULT PRIVILEGES

A

define default access privileges

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

ALTER DOMAIN

A

change the definition of an extension

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

ALTER EVENT TRIGGER

A

change the definition of an event trigger

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

ALTER EXTENSION

A

change the definition of an extension

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

ALTER FOREIGN DATA WRAPPER

A

change the definition of a foreign-data wrapper

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

ALTER FOREIGN TABLE

A

change the definition of a foreign table

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

ALTER FUNCTION

A

change the definition of a function

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

ALTER GROUP

A

change role name or membership

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

ALTER INDEX

A

change the definition of an index

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

ALTER LANGUAGE

A

change the definition of a procedural language

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

ALTER LARGE OBJECT

A

change the definition of a large object

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

ALTER MATERIALIZED VIEW

A

change the definition of a materialized view

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

ALTER OPERATOR

A

change the definition of an operator

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

ALTER OPERATOR CLASS

A

change the definition of an operator class

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

ALTER OPERATOR FAMILY

A

change the definition of an operator family

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

ALTER POLICY

A

change the definition of a row-level security policy

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

ALTER PROCEDURE

A

change the definition of a procedure

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

ALTER PUBLICATION

A

change the definition of a publication

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

ALTER ROLE

A

change a database role

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

ALTER ROUTINE

A

change the definition of a routine`

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

ALTER RULE

A

change the definition of a rule

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

ALTER SCHEMA

A

change the definition of a schema

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

ALTER SEQUENCE

A

change the definition of a sequence generator

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

ALTER SERVER

A

change the definition of a foreign server

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

ALTER STATISTICS

A

change the definition of an extended statistics object

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

ALTER SUBSCRIPTION

A

change the definition of a subscription

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

ALTER SYSTEM

A

change a server configuration parameter

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

ALTER TABLE

A

change the definition of a table

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

ALTER TABLESPACE

A

change the definition of a tablespace

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

ALTER TEXT SEARCH CONFIGURATION

A

change the definition of a text search configuration

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

ALTER TEXT SEARCH DICTIONARY

A

change the definition of a text search dictionary

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

ALTER TEXT SEARCH PARSER

A

change the definition of a text search parser

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

ALTER TEXT SEARCH TEMPLATE

A

change the definition of a text search template

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

ALTER TRIGGER

A

change the definition of a trigger

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

ALTER TYPE

A

change the definition of a type

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

ALTER USER

A

change a database role

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

ALTER USER MAPPING

A

change the definition of a user mapping

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

ALTER VIEW

A

change the definition of a view

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

ANALYZE

A

collect statistics about a database

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

BEGIN

A

start a transaction block

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

CALL

A

invoke a procedure

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

CHECKPOINT

A

force a write-ahead log checkpoint

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

CLOSE

A

close a cursor

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

CLUSTER

A

cluster a table according to an index

50
Q

COMMENT

A

define or change the comment of an object

51
Q

COMMIT

A

commit the current transaction

52
Q

COMMIT PREPARED

A

commit a transaction that was earlier prepared for two-phase commit

53
Q

COPY

A

copy data between a file and a table

54
Q

CREATE ACCESS METHOD

A

define a new access method

55
Q

CREATE AGGREGATE

A

define a new access method

56
Q

CREATE CAST

A

define a new cast

57
Q

CREATE COLLATION

A

define a new collation

58
Q

CREATE CONVERSION

A

define a new encoding conversion

59
Q

CREATE DATABASE

A

create a new database

60
Q

CREATE DOMAIN

A

define a new domain

61
Q

CREATE EVENT TRIGGER

A

define a new event trigger

62
Q

CREATE EXTENSION

A

intall an extension

63
Q

CREATE FOREIGN DATA WRAPPER

A

define a new foreigh-data wrapper

64
Q

CREATE FOREIGN TABLE

A

define a new foreighn table

65
Q

CREATE FUNCTION

A

define a new function

66
Q

CREATE GROUP

A

define a new database role

67
Q

CREATE INDEX

A

define a new index

68
Q

CREATE LANGUAGE

A

define a new procedural language

69
Q

CREATE MATERIALIZED VIEW

A

define a new materialized view

70
Q

CREATE OPERATOR

A

define a new operator

71
Q

CREATE OPERATOR CLASS

A

define a new operator class

72
Q

CREATE OPERATOR FAMILY

A

define a new operator family

73
Q

CREATE POLICY

A

define a new row-level security

74
Q

CREATE PROCEDURE

A

define a new procedure

75
Q

CREATE PUBLICATION

A

define a new publication

76
Q

CREATE ROLE

A

define a new database role

77
Q

CREATE RULE

A

define a new rewrite rule

78
Q

CREATE SCHEMA

A

define a new schema

79
Q

CREATE SEQUENCE

A

define a new sequence generator

80
Q

CREATE SERVER

A

define a new foreign server

81
Q

CREATE STATISTICS

A

define extended statistics

82
Q

CREATE SUBSCRIPTION

A

define a new subscription

83
Q

CREATE TABLE

A

define a new table

84
Q

CREATE TABLE AS

A
85
Q

CREATE TABLESPACE

A

define a new tablespace

86
Q

CREATE TEXT SEARCH CONFIGURATION

A

define a new text search configuration

87
Q

CREATE TEXT SEARCH DICTIONARY

A

define a new text search dictionary

88
Q

CREATE TEXT SEARCH PARSER

A

define a new text search parser

89
Q

CREATE TEXT SEARCH TEMPLATE

A

define a new text search template

90
Q

CREATE TRANSFORM

A

define a new transform

91
Q

CREATE TRIGGER

A

define a trigger

92
Q

CREATE TYPE

A

define a new data type

93
Q

CREATE USER

A

define a new database role

94
Q

CREATE USER MAPPING

A

define a new mapping of a user to a foreign server

95
Q

CREATE VIEW

A

define a new view

96
Q

DEALLOCATE

A

deallocate a prepared statement

97
Q

DECLARE

A

define a cursor

98
Q

DELETE

A

delete rows of a table

99
Q

DISCARD

A

discoard session state

100
Q

DO

A

execute an anonymous code block

101
Q

DROP ACCESS METHOD

A

remove an access method

102
Q

DROP AGGREGATE

A

remove an aggregate function

103
Q

DROP CAST

A

remove a cast

104
Q

DROP COLLATION

A

remove a collation

105
Q

DROP CONVERSION

A

remove a conversion

106
Q

DROP DATABASE

A
107
Q

DROP DOMAIN

A
108
Q

DROP EVENT TRIGGER

A
109
Q

DROP EXTENSION

A
110
Q

DROP FOREIGN DATA WRAPPER

A
111
Q

DROP FOREIGN TABLE

A
112
Q

DROP FUNCTION

A
113
Q

DROP GROUP

A
114
Q

DROP INDEX

A
115
Q

DROP LANGUAGE

A
116
Q

DROP MATERIALIZED VIEW

A
117
Q

DROP OPERATOR

A
118
Q

DROP OPERATOR CLASS

A
119
Q

DROP OPERATOR FAMILY

A
120
Q

DROP OWNED

A
121
Q

DROP POLICY

A
122
Q

DROP PROCEDURE

A

Commands, Statements and Functions (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions