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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion