You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?