Which of the following is the CORRECT way to create a student table with fields Roll no, Name, Age?

Question

Question

This question was previously asked in

Beltron Programmer 1 Oct 2023 Official Paper

Attempt Online

Answer 1

The correct answer is Option 2) CREATE TABLE Students (Rollno int, Name varchar (200), Age int).

Key Points

This is the correct syntax for creating a table in SQL.
CREATE TABLE is the standard SQL command used to create a new table in a database.
The correct format is:
CREATE TABLE TableName (Column1 DataType, Column2 DataType, ...);
In this case:
- Rollno is an integer (int),
- Name is a variable-length string (varchar) with a max size of 200 characters,
- Age is also an integer (int).
This command will successfully create the "Students" table with the specified columns and data types.

Additional Information

Option 1 – Incorrect: CREATE NEW TABLE is not valid SQL syntax. The correct keyword is only CREATE TABLE.
Option 3 – Incorrect: Defining data types outside the column list is incorrect syntax in SQL.
Option 4 – Incorrect: NEW TABLE is not valid. SQL does not recognize this format for table creation.
Tip: Always define both column names and their corresponding data types inside the parentheses.
Common Data Types:
- int: For whole numbers
- varchar(n): For text strings up to n characters
- date: For date values
- float, decimal: For numeric values with decimals