SQL

Question 1

Creating a Table Syntax

Answer 1

CREATE TABLE “Table Name”

([column1] [data type])

CREATE TABLE employee_num

(firstname varchar (15),

 lastname varchar (20),

 age number (3),

 salary (7,2) \<-- (0000000.00)

Question 2

CHAR(SIZE)

Answer 2

Fixed-length character string, Size is specified in parenthesis

Question 3

VARCHAR(SIZE)

Answer 3

Variable-length character string. Max size is specified.

Question 4

NUMBER(SIZE)

Answer 4

Number value with a max number of column digits

Question 5

DATE

Answer 5

Date value

Question 6

NUMBER(size,d)

Answer 6

Number value (Max number places, Max decimal places)

Question 7

INSERT Data

Answer 7

INSERT into employee

(first, last, age, address, city, state)

VALUES ('Luke', 'Duke', 45, '2130 Boars Nest', 'Hazard Co', 'Georgia');