Activity#1 - IT Software Solutions for Business

Which SQL command is used to add a new row of data to a table?

• UPDATE

• INSERT

• DELETE

• ALTER

Which SQL statement is used to update existing data in a table?

• UPDATE

• MODIFY

• INSERT

• REPLACE

To delete records from a table without removing the table itself, which SQL command is used?

• DROP

• TRUNCATE

• DELETE

• REMOVE

Which SQL command is used to modify the structure of an existing table?

• CREATE

• ALTER

• DROP

• MODIFY

Which of the following commands will delete a table and all of its data from a database?

• DELETE

• DROP

• TRUNCATE

• ALTER

What is the effect of the TRUNCATE command on a table?

• It deletes all rows from the table but keeps the structure intact.

• It removes the table entirely.

• It deletes only selected rows.

• It updates existing data in the table.

Which SQL keyword is used to modify a column’s data type in an existing table?

• CHANGE

• MODIFY

• ALTER

• UPDATE

Which of the following commands is used to add a new column to an existing table?

• ADD COLUMN

• ALTER TABLE ADD COLUMN

• MODIFY TABLE ADD COLUMN

• CREATE COLUMN

If you want to remove a specific column from a table, which SQL statement would you use?

• DELETE COLUMN

• REMOVE COLUMN

• ALTER TABLE DROP COLUMN

• ALTER TABLE DELETE COLUMN

Which SQL statement can be used to rename a table?

• RENAME TABLE

• ALTER TABLE RENAME TO

• MODIFY TABLE NAME

• UPDATE TABLE NAME