DS0-001: CompTIA DataSys+Demo

Question

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?

A
B
C
D

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

CREATE TABLE (Transact-SQL)

DS0-001: CompTIA DataSys+Demo

AstroTutor

Notes

Readiness

QuestionQ26

Community Discussion