SQL Keywords

Question 1

Adds a column in an existing table

Answer 1

ADD

Question 2

Adds a constraint after a table is already created

Answer 2

ADD CONSTRAINT

Question 3

Adds, deletes, or modifies columns in a table, or changes the data type of a column in a table

Answer 3

ALTER

Question 4

Changes the data type of a column in a table

Answer 4

ALTER COLUMN

Question 5

ALTER TABLE

Answer 5

Adds, deletes, or modifies columns in a table

Question 6

ALL

Answer 6

Returns true if all of the subquery values meet the condition

Question 7

AND

Answer 7

Only includes rows where both conditions is true

Question 8

ANY

Answer 8

Returns true if any of the subquery values meet the condition

Question 9

AS

Answer 9

Renames a column or table with an alias

Question 10

ASC

Answer 10

Sorts the result set in ascending order

Question 11

BACKUP DATABASE

Answer 11

Creates a back up of an existing database

Question 12

BETWEEN

Answer 12

Selects values within a given range

Question 13

CASE

Answer 13

Creates different outputs based on conditions

Question 14

CHECK

Answer 14

A constraint that limits the value that can be placed in a column

Question 15

COLUMN

Answer 15

Changes the data type of a column or deletes a column in a table

Question 16

CONSTRAINT

Answer 16

Adds or deletes a constraint

Question 17

CREATE

Answer 17

Creates a database, index, view, table, or procedure

Question 18

CREATE DATABASE

Answer 18

Creates a new SQL database

Question 19

CREATE INDEX

Answer 19

Creates an index on a table (allows duplicate values)

Question 20

CREATE OR REPLACE VIEW

Answer 20

Updates a view

Question 21

CREATE TABLE

Answer 21

Creates a new table in the database

Question 22

CREATE PROCEDURE

Answer 22

Creates a stored procedure

Question 23

CREATE UNIQUE INDEX

Answer 23

Creates a unique index on a table (no duplicate values)

Question 24

CREATE VIEW

Answer 24

Creates a view based on the result set of a SELECT statement

Question 25

DATABASE

Answer 25

Creates or deletes an SQL database

Question 26

DEFAULT

Answer 26

A constraint that provides a default value for a column

Question 27

DELETE

Answer 27

Deletes rows from a table

Question 28

DESC

Answer 28

Sorts the result set in descending order