Mastering SQL DDL and DML Commands

What SQL command is used to create a new table?

• INSERT TABLE

• MODIFY TABLE

• ADD TABLE

• CREATE TABLE

How do you add a new column to an existing table?

• CREATE TABLE table_name ADD column_name data_type;

• UPDATE table_name SET column_name = value;

• ALTER TABLE table_name ADD COLUMN column_name data_type;

• INSERT INTO table_name (column_name) VALUES (value);

What command would you use to remove a table from a database?

• DELETE TABLE table_name;

• CLEAR TABLE table_name;

• DROP TABLE table_name;

• REMOVE TABLE table_name;

Which SQL statement is used to insert new data into a table?

• INSERT INTO

• DELETE FROM

• UPDATE

• SELECT * FROM

How can you update existing records in a table?

• Create a new table with the updated records.

• Use the SQL SELECT statement to retrieve records.

• Delete the records using the SQL DELETE statement.

• Use the SQL UPDATE statement with SET and WHERE clauses.

What is the SQL command to delete records from a table?

• DELETE FROM table_name WHERE condition;

• REMOVE FROM table_name WHERE condition;

• DELETE table_name WHERE condition;

• DROP table_name WHERE condition;

How can you rename an existing column?

• ALTER TABLE table_name RENAME COLUMN column_name;

• ALTER COLUMN table_name RENAME column_name;

• sp_name 'column_name', 'new_name';

• sp_rename 'table_name.column_name', 'new_name', 'COLUMN';

How do you change the data type of a column in a table?

• Change column_name data_type in the database settings;

• Use ALTER COLUMN column_name SET DATA TYPE new_data_type;

• Use ALTER TABLE table_name ALTER COLUMN column_name new_data_type;

• Use UPDATE table_name SET column_name = new_data_type;

What command would you use to drop a column from a table?

• ALTER TABLE table_name DROP COLUMN column_name;

• REMOVE column_name FROM table_name;

• DROP column_name IN table_name;

• DELETE COLUMN column_name FROM table_name;

What is the correct syntax to insert multiple records to a database table at once?

• INSERT INTO table_name (column1, column2) VALUES (value1a, value2a, value1b, value2b);

• INSERT table_name (column1, column2) VALUES (value1a, value2a), (value1b, value2b);

• INSERT INTO table_name (column1, column2) VALUES (value1a, value2a), (value1b, value2b), (value1c, value2c);

• INSERT ONTO table_name VALUES (value1a, value2a), (value1b, value2b);