You are designing a small relational database for a library. Before any data can be stored, you must add a table named Books with columns such as Title, Author, and ISBN. Which SQL Data Definition Language (DDL) command should you use to establish that new table?
Use the CREATE command to define the new table.
Use the GRANT command to make the table available.
The CREATE command is part of SQL's Data Definition Language and is specifically used to introduce new database objects, such as tables. ALTER modifies an object that already exists, DROP deletes an object entirely, and GRANT (permissions) assigns access rights but does not make new structures.
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 does SQL stand for and what is its purpose?
Open an interactive chat with Bash
What is an ISBN and why is it important in a library?
Open an interactive chat with Bash
What is the difference between the Create and Alter commands in SQL?