Which of the following is an example of field types in the Create Table Statement?

• A. Boolean, Real, Char(10)
• B. DateTime, Text(50), Integer
• C. Blob, VarChar(20), BigInt
• D. AutoCounter, Char(30), LongInteger

Answer: (D)

In a table definition, each column is defined by a data type that tells the database what kind of data will be stored, often with optional modifiers. Char(30) shows a string type with a fixed length of 30 characters, and LongInteger represents a large numeric type. AutoCounter illustrates an attribute commonly used to make a column auto-increment its value. Together they reflect how field types and related properties appear when you define columns in a create-table statement.

Other options mix items that aren’t consistently used as standard data types in many SQL dialects (for example, a length for a text type, or an explicit AutoCounter as a data type), so the example containing a string type with length, a large integer type, and an auto-increment-like attribute aligns most closely with how field types are defined in create-table statements.