1.7. Review Questions
Which of the following SQL commands is an example of a DML command?
You have just started a database transaction by inserting a row into a table. Which of the following actions will end this transaction?
Inserting another row
Issuing a COMMIT command
Issuing an END TRANSACTION command
Deleting the row you just inserted
You are designing an application that will enforce business rules through table design. One of the tables in the application contains information about parts that are used to manufacture your product. When creating the PARTS table, what could you do to make certain that each part receives a part number and that each part number will be unique?
Place a Unique constraint on the part number column ...