Which statement creates a table named PostalCodes with a five-character PostalCode text field and a two-character Abbrev text field?
A)CREATE TABLE PostalCodes (PostalCode TEXT, Abbrev TEXT);
B)CREATE TABLE PostalCodes (PostalCode (TEXT 5), Abbrev (TEXT 2));
C)CREATE TABLE PostalCodes (PostalCode TEXT (5), Abbrev TEXT (2));
D)CREATE TABLE (PostalCode TEXT (5), Abbrev TEXT (2));

Question

Quizplus · Accepted Answer

Option C correctly specifies the length of the text fields according to SQL syntax, which allows for defining the maximum length of text fields within parentheses right after the data type.

Which Statement Creates a Table Named PostalCodes with a Five-Character