PNG60403 TOPIC 4.5

Which SQL statement is used to create a table?

• DEFINE TABLE

• CREATE TABLE

• MAKE TABLE

• ADD TABLE

How is data added to a table in SQL?

• UPDATE TABLE

• INSERT INTO

• CREATE DATA

• ADD DATA

What SQL statement is used to update existing data?

• MODIFY

• CHANGE

• ALTER

• UPDATE

How can you delete data from a table in SQL?

• DELETE

• ERASE

• REMOVE

• CLEAR

Which SQL command is used to remove an entire table structure and its data?

• REMOVE TABLE

• CLEAR TABLE

• DROP TABLE

• DELETE TABLE

What should be used in SQL to ensure all operations succeed or fail together?

• COMMIT

• BEGIN

• TRANSACTION

• ROLLBACK

When creating or altering tables in SQL, what should be used to enforce data integrity?

• CONSTRAINTS

• ENSURE

• VERIFY

• VALIDATE

What should be considered in SQL when inserting, updating, or deleting large amounts of data?

• Quickness

• Efficiency

• Performance

• Speed