Lesson 5

Question 1

CREATE TABLE

Answer 1

SQL statement that is used to create a new table in a database.

Question 2

ALTER TABLE

Answer 2

Used to alter or change the structure of existing database table.

Question 3

Constraint

Answer 3

A rule for data in the database.

Question 4

PRIMARY KEY (PK)

Answer 4

The column that uniquely identifies each row in the table.

Question 5

FOREIGN KEY (FK)

Answer 5

Used to relate or link two tables together.

Question 6

Data Types

Answer 6

Defines what value the column can store.

Question 7

nvarchar

Answer 7

Variable width that hold string and unicode data.

Question 8

Int

Answer 8

Holds whole numbers.

Question 9

Decimal (p,s)

Answer 9

Holds numbers with decimals.

Question 10

Date

Answer 10

Stores only date data.

Question 11

NULL

Answer 11

Constraint that indicates the data column can be empty of data.

Question 12

NOT NULL

Answer 12

Constraint that insures data is always entered in a column.

Question 13

DROP TABLE

Answer 13

Statement to remove a table, and all the data rows from the database.

Question 14

Debugging

Answer 14

Making corrections to remove bugs or errors in the code.