A new employee is instructed to create a new table in the company's database to track employee training records. Which SQL statement should they use to accomplish this task?
The correct answer is CREATE TABLE because this SQL statement is used to define a new table within a database. The other options are incorrect: ALTER TABLE is used to modify an existing table, INSERT INTO is used to add new rows of data to a table, and SELECT is used to retrieve data from a table.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the purpose of the CREATE TABLE statement in SQL?
Open an interactive chat with Bash
What are some common data types used when creating a table in SQL?
Open an interactive chat with Bash
Can you explain the difference between CREATE TABLE and ALTER TABLE in SQL?