Mastering SQL Basics and DDL Commands

What does SQL stand for?

• Simple Query Language

• Standard Query Language

• Structured Query List

• Structured Query Language

Which command is used to create a new table in SQL?

• INSERT TABLE

• CREATE TABLE

• ADD TABLE

• MODIFY TABLE

What is the purpose of the ALTER TABLE command?

• To delete a table from a database.

• To create a new table in a database.

• To modify the structure of an existing table in a database.

• To retrieve data from an existing table.

Which SQL command is used to remove a table from a database?

• ALTER TABLE

• DROP TABLE

• REMOVE TABLE

• DELETE TABLE

What does DDL stand for in SQL?

• Data Distribution Layer

• Data Design Language

• Data Definition Language

• Data Delivery Logic

Which command would you use to rename a table?

• RENAME TABLE old_table_name TO new_table_name;

• UPDATE TABLE old_table_name SET name = new_table_name;

• ALTER TABLE new_table_name RENAME TO old_table_name;

• CHANGE TABLE old_table_name TO new_table_name;

What is the function of the DROP COLUMN command?

• To add a new column to a table in SQL.

• To remove a column from a table in SQL.

• To delete an entire table from the database.

• To rename an existing column in a table.

Name one type of SQL command other than DDL.

• DML

• TCL

• DDL

• DCL

What is the syntax to add a new column to an existing table?

• CREATE TABLE table_name (new_column_name data_type);

• DROP COLUMN new_column_name FROM table_name;

• UPDATE table_name SET new_column_name = data_type;

• ALTER TABLE table_name ADD COLUMN new_column_name data_type;

How do you delete a specific column from a table?

• Use 'REMOVE COLUMN column_name FROM table_name;' in SQL.

• Use 'ALTER TABLE table_name DROP COLUMN column_name;' in SQL.

• Use 'DELETE FROM table_name WHERE column_name;' in SQL.

• Use 'DROP table_name.column_name;' in SQL.