Which of the following is the correct SQL syntax to create a table for an entity Student(id INT PRIMARY KEY, name VARCHAR(50))?

easy📝 Syntax Q3 of 15

SQL - Table Relationships

Which of the following is the correct SQL syntax to create a table for an entity Student(id INT PRIMARY KEY, name VARCHAR(50))?

ATABLE CREATE Student (id INT PRIMARY KEY, name VARCHAR(50));

BCREATE TABLE Student (id INT PRIMARY KEY, name VARCHAR(50));

CCREATE Student TABLE (id INT PRIMARY KEY, name VARCHAR(50));

DCREATE TABLE Student id INT PRIMARY KEY, name VARCHAR(50);

Step-by-Step Solution

Solution:

Step 1: Recall correct CREATE TABLE syntax
The correct syntax starts with CREATE TABLE, followed by table name and column definitions in parentheses.
Step 2: Check each option for syntax correctness
CREATE TABLE Student (id INT PRIMARY KEY, name VARCHAR(50)); matches the correct syntax exactly; others have wrong keyword order or missing parentheses.
Final Answer:
CREATE TABLE Student (id INT PRIMARY KEY, name VARCHAR(50)); -> Option B
Quick Check:
CREATE TABLE syntax = CREATE TABLE Student (id INT PRIMARY KEY, name VARCHAR(50)); [OK]

Quick Trick: CREATE TABLE always uses parentheses for columns [OK]

Common Mistakes:

MISTAKES

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes