What is the use of the DROP command? What is the purpose of a COMMIT statement in SQL?
Asked in the Skill interview stage. Use the command reference data to return the entries that document these two commands and their effects.
command_name, command_type, transaction_effect, object_scope, and command_description.DROP before COMMIT.| Column | Type | Description |
|---|---|---|
| command_idPK | INT | Unique identifier for the command reference |
| command_name | VARCHAR(30) | SQL command name |
| command_type | VARCHAR(40) | SQL command classification |
| transaction_effect | VARCHAR(120) | Effect of the command on transaction state |
| object_scope | VARCHAR(80) | Database object or transaction scope affected |
| command_description | VARCHAR(255) | Concise explanation of the command |