SQL Commands

Question 1

Creates a database schema

Answer 1

CREATE SCHEMA AUTHORIZATION

Question 2

Creates a new table

Answer 2

CREATE TABLE

Question 3

Ensures that a column will not have null values

Answer 3

NOT NULL

Question 4

Ensures that a column will not have duplicate values

Answer 4

UNIQUE

Question 5

Defines a primary key for a table

Answer 5

PRIMARY KEY

Question 6

Defines a foreign key for a table

Answer 6

FOREIGN KEY

Question 7

Defines a default value for a column

Answer 7

DEFAULT

Question 8

Validates data in an attribute

Answer 8

CHECK

Question 9

Creates an index for a table

Answer 9

CREATE INDEX

Question 10

Creates a dynamic subset of rows/columns from one or more

tables

Answer 10

CREATE VIEW

Question 11

Modifies a tables definition (adds, modifies, or deletes attributes
or constraints)

Answer 11

ALTER TABLE

Question 12

Creates a new table based on a query in the user’s database

schema

Answer 12

CREATE TABLE AS

Question 13

Permanently deletes a table (and its data)

Answer 13

DROP TABLE

Question 14

Permanently deletes an index

Answer 14

DROP INDEX

Question 15

Permanently deletes a view

Answer 15

DROP VIEW

Question 16

Inserts row(s) into a table

Answer 16

INSERT

Question 17

Selects attributes from rows in one or more tables or views

Answer 17

SELECT

Question 18

Restricts the selection of rows based on a conditional expression

Answer 18

WHERE

Question 19

Groups the selected rows based on one or more attributes

Answer 19

GROUP BY

Question 20

Restricts the selection of grouped rows based on a condition

Answer 20

HAVING

Question 21

Orders the selected rows based on one or more attributes

Answer 21

ORDER BY

Question 22

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

Answer 22

UPDATE

Question 23

Deletes one or more rows from a table

Answer 23

DELETE

Question 24

Permanently saves data changes

Answer 24

COMMIT

Question 25

Restores data to their original values

Answer 25

ROLLBACK

Question 26

Logical Operators

Answer 26

AND/OR/NOT

Question 27

Comparison Operators

Answer 27

=, , =, <>

Question 28

Checks whether an attribute value is within a range

Answer 28

BETWEEN

Question 29

Checks whether an attribute value is null

Answer 29

IS NULL

Question 30

Checks whether an attribute value matches a given string pattern

Answer 30

LIKE

Question 31

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

Answer 31

IN

Question 32

Checks whether a subquery returns any rows

Answer 32

EXISTS

Question 33

Limits values to unique values

Answer 33

DISTINCT

Question 34

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

Answer 34

COUNT

Question 35

Returns the minimum attribute value found in a given column

Answer 35

MIN

Question 36

Returns the maximum attribute value found in a given column

Answer 36

MAX

Question 37

Returns the sum of all values for a given column

Answer 37

SUM

Question 38

Returns the average of all values for a given column

Answer 38

AVG