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:
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:
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:
Common Pitfalls:
Confusing UI labels or Access “Make-Table” queries with server SQL; assuming colloquial phrases are valid syntax.
Final Answer:
Incorrect
Discussion & Comments