DDL DML TCL Review

12345678910111213141516171819202122232425262728293031323334
Across
  1. 3. This command is how you name a specific backup
  2. 5. A PK is often used as these
  3. 6. A visual representation of a database's tables
  4. 9. Each column represents one of these
  5. 12. This is used to specify the unique access to the row in this table
  6. 14. All PK must meet this specification
  7. 16. This Oracle specific table is used for compound insert statements
  8. 17. This abbreviation is used to create a reference to a dataset in a query
  9. 18. This command is a hard save and cannot be undone
  10. 19. This keyword is used to specify what is going into the record
  11. 21. This command erases ALL updates since the last COMMIT
  12. 24. The keyword that SHOULD be required for DML statements
  13. 25. This command is used to change values in a table
  14. 27. These keywords are used to create a common table expression
  15. 30. This command is used to instantiate database entities
  16. 32. These can be created by a developer to retrieve custom data
  17. 34. This command is used to add data to a table
Down
  1. 1. This command is used to remove an entity from the database
  2. 2. This set operation is performed when doing a compound insert
  3. 4. This is used to specify a reference to a row in another table
  4. 7. The subset of SQL specifically associated with queries
  5. 8. Used to specify what table and field(s) for a FK
  6. 10. This subset handles modifications of the database and its tables
  7. 11. These can be created by a developer to modify entities in the database
  8. 13. This command is used to specify the table in an INSERT statement
  9. 15. These should be used in DDL and DML scripts to explain reasoning
  10. 16. This subset is used to work with the data in a database
  11. 20. This command is used to change the structure of a table
  12. 21. This command erases updates to a specified SAVEPOINT
  13. 22. This is a common abbreviation associated with CRUD
  14. 23. This command is used to name restrictions on a table
  15. 26. This subset handles backup and redo of database modifications
  16. 28. This command is used to specify a variable in a FUNCTION
  17. 29. This command is used to specify a field when replacing values
  18. 31. The main structure in a database
  19. 33. These are created to make specified datasets available by name