Which of the following database activities should the user perform?

A developer needs to add a table to a database.

Which of the following database activities should the user perform?
A . UPDATE
B . ALTER
C . CREATE
D . REPORT

View Answer

Answer: C

Explanation:

The CREATE statement is used to add a new table to a database.

The syntax of the CREATE statement is:

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, … );

Reference: CompTIA IT Fundamentals+ Study Guide: Exam FC0-U61, Second Edition, Chapter 5:

Database Fundamentals, page 194.