Examveda

Which among the following is the correct syntax for creating table?

A. CREATE TABLE name;

B. CREATE name;

C. CREATE TABLE

D. All of the mentioned

Answer: Option A

Solution (By Examveda Team)

This question is asking about how to create a new table in a MySQL database.
Let's break down the options:
Option A: CREATE TABLE name;
This is the correct syntax for creating a table. "CREATE TABLE" tells MySQL you want to create a new table, and "name" is where you replace with the actual name you want to give your table.
Option B: CREATE name;
This is incorrect because it's missing the "TABLE" keyword. MySQL needs to know you're creating a table, not just a random object.
Option C: CREATE TABLE
This is also incorrect because it's missing the table name. You need to tell MySQL what you want to call your table.
Option D: All of the mentioned
This is incorrect since only Option A is correct.
So the answer is Option A.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous