A company wants to store information about its employees in a database. As part of setting up the database, which command would be used initially to create a new table to hold the employee data?
The correct answer is 'CREATE TABLE'. This is because when establishing a new database, the 'CREATE TABLE' command is used to define a new table with its column definitions and data types. It sets the foundation for the data that will be stored. 'ALTER TABLE' is used to modify an existing table, not to create one. 'CREATE DATABASE' is used to create a database, not a table within a database. 'INSERT INTO' is used to add data to an existing table.
Learn More
AI Generated Content may display inaccurate information, always double-check anything important.
What are the key components of a SQL table?
What does the 'ALTER TABLE' command do in SQL?
What is the purpose of the 'CREATE DATABASE' command?