SQL Commands (BASIC)

Question 1

Creates a database schema

Answer 1

CREATE SCHEMA AUTHORIZATION

Question 2

Creates a new table in the user’s database schema

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 (when no value is given)

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 and columns from one or more tables (see Lesson 4, Advanced SQL)

Answer 10

CREATE VIEW

Question 11

Modifies a table’s 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

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

Answer 13

CREATE TABLE AS

Question 14

Permanently deletes a table (and its data)

Answer 14

DROP TABLE

Question 15

Permanently deletes an index

Answer 15

DROP INDEX

Question 16

Permanently deletes a view

Answer 16

DROP VIEW