Which of the following SQL syntaxes should the administrator use to create an object?

A database administrator is creating a table, which will contain customer data, for an online business.

Which of the following SQL syntaxes should the administrator use to create an object?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: B

Explanation:

The SQL syntax that the administrator should use to create an object is option B. This syntax uses the CREATE TABLE statement to define a new table named customer with four columns: customer_id, name, email, and phone. Each column has a data type and a constraint, such as NOT NULL or PRIMARY KEY. The other options either have syntax errors, use incorrect keywords, or do not specify the table name or columns correctly.

Reference: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.1 Given a scenario, identify and apply database structure types.