QuestionQ26

VerifiedDatabase Fundamentals

A database administrator is creating a table to store customer data for an online business. Which of the following SQL syntaxes should the administrator use to create the object?

Explanation

CREATE TABLE syntax places the table name immediately after CREATE TABLE, followed by parentheses containing comma-separated column definitions. Thus, CREATE TABLE CUSTOMER (ID INT, NAME VARCHAR(100), AGE INT) is valid syntax.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!