A student tries to create a table for an entity Course(course_id, title) but writes: CREATE TABLE Course course_id INT PRIMARY KEY, title VARCHAR(100); What is the error?

medium📝 Debug Q6 of 15

SQL - Table Relationships

A student tries to create a table for an entity Course(course_id, title) but writes: CREATE TABLE Course course_id INT PRIMARY KEY, title VARCHAR(100); What is the error?

AMissing parentheses around column definitions

BIncorrect data type for course_id

CPRIMARY KEY cannot be used in CREATE TABLE

DTable name should be in quotes

Step-by-Step Solution

Solution:

Step 1: Review correct CREATE TABLE syntax
Column definitions must be enclosed in parentheses after table name.
Step 2: Identify missing parentheses in given statement
The statement lacks parentheses around columns, causing syntax error.
Final Answer:
Missing parentheses around column definitions -> Option A
Quick Check:
CREATE TABLE needs parentheses [OK]

Quick Trick: Always use parentheses for columns in CREATE TABLE [OK]

Common Mistakes:

MISTAKES

Omitting parentheses
Misplacing PRIMARY KEY keyword
Using wrong data types

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More SQL Quizzes

A student tries to create a table for an entity Course(course_id, title) but writes: CREATE TABLE Course course_id INT PRIMARY KEY, title VARCHAR(100); What is the error?

Step 1: Review correct CREATE TABLE syntax

Step 2: Identify missing parentheses in given statement

Final Answer:

Quick Check:

Want More Practice?