SQL Command Options (BASIC)

Question 1

Describes the structure of a table

Answer 1

DESCRIBE

Question 2

Inserts row(s) into a table

Answer 2

INSERT

Question 3

Selects attributes from rows in one or more tables or views

Answer 3

SELECT

Question 4

Restricts the selection of rows based on a conditional expression

Answer 4

WHERE

Question 5

Groups the selected rows based on one or more attributes

Answer 5

GROUP BY

Question 6

Restricts the selection of grouped rows based on a condition

Answer 6

HAVING

Question 7

Orders the selected rows based on one or more attributes

Answer 7

ORDER BY

Question 8

Modifies an attribute’s values in one or more table’s rows

Answer 8

UPDATE

Question 9

Deletes one or more rows from a table

Answer 9

DELETE

Question 10

Permanently saves data changes

Answer 10

COMMIT

Question 11

Restores data to its original values

Answer 11

ROLLBACK

Question 12

Comparison operators

Answer 12

=, , <=, >=, <>, !=

Question 13

Logical operators

Answer 13

AND/OR/NOT

Question 14

Checks whether an attribute value is within a range

Answer 14

BETWEEN

Question 15

Checks whether an attribute value is null

Answer 15

IS NULL

Question 16

Checks whether an attribute value matches a given string pattern

Answer 16

LIKE

Question 17

Checks whether an attribute value matches any value within a value list

Answer 17

IN

Question 18

Checks whether a subquery returns any rows

Answer 18

EXISTS

Question 19

Limits values to unique values

Answer 19

DISTINCT

Question 20

Returns the number of rows with non-null values for a given column

Answer 20

COUNT

Question 21

Returns the minimum attribute value found in a given column

Answer 21

MIN

Question 22

Returns the maximum attribute value found in a given column

Answer 22

MAX

Question 23

Returns the sum of all values for a given column

Answer 23

SUM

Question 24

Returns the average of all values for a given column

Answer 24

AVG