Mastering SQL DDL and DML Commands

Front

What SQL command is used to create a new table?

Back

CREATE TABLE

Front

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

Back

ALTER TABLE table_name ADD COLUMN column_name data_type;

Front

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

Back

DROP TABLE table_name;

Front

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

Back

INSERT INTO

Front

How can you update existing records in a table?

Back

Use the SQL UPDATE statement with SET and WHERE clauses.

Front

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

Back

DELETE FROM table_name WHERE condition;

Front

How can you rename an existing column? Options: 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';

Back

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

Front

How do you change the data type of a column in a table? Options: 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;

Back

Use ALTER TABLE table_name ALTER COLUMN column_name new_data_type;

Front

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

Back

ALTER TABLE table_name DROP COLUMN column_name;

Front

What is the correct syntax to insert multiple records to a database table at once? Options: 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);

Back

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