Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
ALTER ROUTINE
change the definition of a routine`
26
ALTER RULE
change the definition of a rule
27
ALTER SCHEMA
change the definition of a schema
28
ALTER SEQUENCE
change the definition of a sequence generator
29
ALTER SERVER
change the definition of a foreign server
30
ALTER STATISTICS
change the definition of an extended statistics object
31
ALTER SUBSCRIPTION
change the definition of a subscription
32
ALTER SYSTEM
change a server configuration parameter
33
ALTER TABLE
change the definition of a table
34
ALTER TABLESPACE
change the definition of a tablespace
35
ALTER TEXT SEARCH CONFIGURATION
change the definition of a text search configuration
36
ALTER TEXT SEARCH DICTIONARY
change the definition of a text search dictionary
37
ALTER TEXT SEARCH PARSER
change the definition of a text search parser
38
ALTER TEXT SEARCH TEMPLATE
change the definition of a text search template
39
ALTER TRIGGER
change the definition of a trigger
40
ALTER TYPE
change the definition of a type
41
ALTER USER
change a database role
42
ALTER USER MAPPING
change the definition of a user mapping
43
ALTER VIEW
change the definition of a view
44
ANALYZE
collect statistics about a database
45
BEGIN
start a transaction block
46
CALL
invoke a procedure
47
CHECKPOINT
force a write-ahead log checkpoint
48
CLOSE
close a cursor
49
CLUSTER
cluster a table according to an index
50
COMMENT
define or change the comment of an object
51
COMMIT
commit the current transaction
52
COMMIT PREPARED
commit a transaction that was earlier prepared for two-phase commit
53
COPY
copy data between a file and a table
54
CREATE ACCESS METHOD
define a new access method
55
CREATE AGGREGATE
define a new access method
56
CREATE CAST
define a new cast
57
CREATE COLLATION
define a new collation
58
CREATE CONVERSION
define a new encoding conversion
59
CREATE DATABASE
create a new database
60
CREATE DOMAIN
define a new domain
61
CREATE EVENT TRIGGER
define a new event trigger
62
CREATE EXTENSION
intall an extension
63
CREATE FOREIGN DATA WRAPPER
define a new foreigh-data wrapper
64
CREATE FOREIGN TABLE
define a new foreighn table
65
CREATE FUNCTION
define a new function
66
CREATE GROUP
define a new database role
67
CREATE INDEX
define a new index
68
CREATE LANGUAGE
define a new procedural language
69
CREATE MATERIALIZED VIEW
define a new materialized view
70
CREATE OPERATOR
define a new operator
71
CREATE OPERATOR CLASS
define a new operator class
72
CREATE OPERATOR FAMILY
define a new operator family
73
CREATE POLICY
define a new row-level security
74
CREATE PROCEDURE
define a new procedure
75
CREATE PUBLICATION
define a new publication
76
CREATE ROLE
define a new database role
77
CREATE RULE
define a new rewrite rule
78
CREATE SCHEMA
define a new schema
79
CREATE SEQUENCE
define a new sequence generator
80
CREATE SERVER
define a new foreign server
81
CREATE STATISTICS
define extended statistics
82
CREATE SUBSCRIPTION
define a new subscription
83
CREATE TABLE
define a new table
84
CREATE TABLE AS
85
CREATE TABLESPACE
define a new tablespace
86
CREATE TEXT SEARCH CONFIGURATION
define a new text search configuration
87
CREATE TEXT SEARCH DICTIONARY
define a new text search dictionary
88
CREATE TEXT SEARCH PARSER
define a new text search parser
89
CREATE TEXT SEARCH TEMPLATE
define a new text search template
90
CREATE TRANSFORM
define a new transform
91
CREATE TRIGGER
define a trigger
92
CREATE TYPE
define a new data type
93
CREATE USER
define a new database role
94
CREATE USER MAPPING
define a new mapping of a user to a foreign server
95
CREATE VIEW
define a new view
96
DEALLOCATE
deallocate a prepared statement
97
DECLARE
define a cursor
98
DELETE
delete rows of a table
99
DISCARD
discoard session state
100
DO
execute an anonymous code block
101
DROP ACCESS METHOD
remove an access method
102
DROP AGGREGATE
remove an aggregate function
103
DROP CAST
remove a cast
104
DROP COLLATION
remove a collation
105
DROP CONVERSION
remove a conversion
106
DROP DATABASE
107
DROP DOMAIN
108
DROP EVENT TRIGGER
109
DROP EXTENSION
110
DROP FOREIGN DATA WRAPPER
111
DROP FOREIGN TABLE
112
DROP FUNCTION
113
DROP GROUP
114
DROP INDEX
115
DROP LANGUAGE
116
DROP MATERIALIZED VIEW
117
DROP OPERATOR
118
DROP OPERATOR CLASS
119
DROP OPERATOR FAMILY
120
DROP OWNED
121
DROP POLICY
122
DROP PROCEDURE

Commands, Statements and Functions (2 decks)

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