SQL Brain Teaser: Commands & Constraints

1234567891011121314
Across
  1. 2. command used to permanently remove a table and its structure from the database.
  2. 4. DDL command used to modify the structure of an existing table.
  3. 5. Command used to make all transaction changes permanent.
  4. 7. Constraint used to ensure that a column cannot contain NULL values.
  5. 8. Constraint that ensures a column cannot contain duplicate values and automatically creates an index.
  6. 11. Constraint used to uniquely identify each row in a table.
  7. 12. Command used to give privileges to users in a database.
  8. 14. DML command used to modify existing records in a table.
Down
  1. 1. Constraint that enforces referential integrity between two tables.
  2. 2. Command used to remove specific rows from a table without removing the table structure.
  3. 3. Constraint that restricts values in a column based on a condition.
  4. 6. Command used to add new records into a table.
  5. 9. DDL command used to create database objects such as tables or views.
  6. 10. DCL command used to remove privileges from a user.
  7. 13. SQL command used to undo transactions that are not yet saved permanently.