SQL commands

Question 1

2 Types of texts

Answer 1

TEXT 225 characters max

MEMO 65536 characters

Question 2

3 Whole numbers

Answer 2

BYTE 0 to 255
INTEGER -32,768 to 32768
LONG -2.147b to 2.147b

Question 3

2 decimals

Answer 3

SINGLE

DOUBLE

Question 4

alter the table called movie, and add collumn movieID make it an autoincrimenting primary key

Answer 4

ALTER TABLE movie ADD COLUMN MovieID autoincrement primary key;

Question 5

make a new table from existing columns, where is optional

Answer 5

SELECT column1, column2, … INTO newtable FROM existing_table WHERE condition

Question 6

Add a new column called PersonID to the person table that contains an automatically increasing
integer value and serves as primary key.

Answer 6

ALTER TABLE Person ADD COLUMN PersonID autoincrement primary key;

Question 7

Create a new table actors_in_movies that contains the columns MovieID (an integer) and PersonID
(also an integer).

Answer 7

CREATE TABLE actors_in_movies (MovieID int, PersonID int)