Core DDL terminology — validate the command name:\n“The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints, and create relationships.” Indicate whether this is correct or incorrect.

Difficulty: Easy

Correct Answer: Incorrect

Explanation:


Introduction / Context:
Knowing the proper DDL verbs is critical for database design and administration. The statement claims that “MAKE TABLE” is the SQL command for creating tables and constraints. This item tests your familiarity with standard SQL syntax versus colloquial phrasing.



Given Data / Assumptions:

  • We reference ISO/IEC SQL standards and mainstream RDBMS dialects.
  • We include creating columns, constraints, and relationships in a table definition.
  • We are not discussing GUI tools that may use buttons labeled “Make Table.”


Concept / Approach:
The correct DDL to create a table is CREATE TABLE, not MAKE TABLE. Within CREATE TABLE, you define columns, primary keys, unique constraints, foreign keys, checks, and defaults. Relationships (referential constraints) are specified using FOREIGN KEY ... REFERENCES ... clauses in the same statement or via ALTER TABLE. Therefore, the wording “MAKE TABLE” is incorrect for standard SQL.



Step-by-Step Solution:

Identify the standard verb: CREATE TABLE.Enumerate what CREATE TABLE can specify: columns and constraints.Compare with the claim: “MAKE TABLE” — not a standard SQL command.Conclude the statement is incorrect.


Verification / Alternative check:
Running “MAKE TABLE ...” in any mainstream SQL engine yields a syntax error. GUI tools may offer a “Make Table” wizard, but they ultimately emit CREATE TABLE DDL.



Why Other Options Are Wrong:

  • “Correct” and “SQL-89” are false; CREATE TABLE predates SQL-92.
  • “Client tools” do not redefine SQL grammar; they generate standard DDL.
  • Storage engines do not change the verb name.


Common Pitfalls:
Confusing UI labels or Access “Make-Table” queries with server SQL; assuming colloquial phrases are valid syntax.



Final Answer:
Incorrect

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion