Multiple Choice
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) ) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q2: How are compound SQL criteria conditions formed?
Q3: Which function calculates the number of records
Q4: Which of the following SQL commands sorts
Q5: What are five restrictions placed on table
Q6: SQL uses an on-screen form to create
Q7: Why is SQL a highly sought-after language
Q8: Based on the SQL shown, which query
Q9: What SQL command can you use to
Q10: When you use a name containing a
Q11: Based on the table description and SQL