Which SQL command must a database administrator (DBA) use to create new tables in order to maintain the original data set?

• A. INSERT
• B. CREATE
• C. ALTER
• D. UPDATE

Answer: (B)

The SQL command that a database administrator (DBA) uses to create new tables is the CREATE command. This command is specifically designed for defining new structures within the database, such as tables, and it ensures that the original data set remains untouched. When using the CREATE command, the DBA can define the schema for the new table, including specifying data types, constraints, and relationships with other tables. This is essential for organizing data systematically without altering the existing data that may already be stored in other tables.

In contrast, the other commands do not serve this purpose. The INSERT command is used to add new rows of data into existing tables rather than creating new tables. The ALTER command is utilized to modify the structure of an existing table, which again would affect the original data set. The UPDATE command is for changing existing data within a table, thus making alterations to the current records. Therefore, CREATE is the appropriate choice for establishing new tables while preserving the original data.