Add a Table to a Database

Adding a Table to a Database

Question

A developer needs to add a table to a database.

Which of the following database activities should the user perform?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

C.

The correct answer is C. CREATE.

When a developer needs to add a table to a database, the appropriate database activity is to CREATE a table. The CREATE command is used to create a new database object, such as a table, view, or index.

UPDATE is used to modify existing data in a database, typically in a specific table. It changes the value of one or more fields in existing records.

ALTER is used to modify an existing database object, such as a table or a column within a table. It can be used to add or remove columns, change the data type of columns, or modify constraints.

REPORT is used to generate reports based on data stored in a database. It is not a database activity that is used to modify the database structure itself.

Therefore, the correct option for adding a table to a database is CREATE.