database consepts

Edit Answers
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
Across
  1. 1. Tuning database queries for better performance
  2. 3. A unit of work performed within a database system
  3. 5. A request for data from one or more tables
  4. 7. A complete set of fields describing one entity instance
  5. 8. SQL command used to modify existing records
  6. 15. Process of organizing data to reduce redundancy
  7. 16. Method of storing related rows close together
  8. 17. Ensures all values in a column are different
  9. 18. Value automatically assigned if none is provided
  10. 19. Command that undoes changes made during a transaction
  11. 21. Ensures that relationships between tables remain consistent
  12. 24. Association between two or more entities
  13. 25. Automatically applies changes to related records
  14. 26. SQL clause that filters groups after aggregation
  15. 28. Copying data from one database to another
  16. 29. An organized collection of structured information
  17. 31. A unique identifier for a record
  18. 34. SQL command used to add new records
  19. 35. A vertical set of data values in a table
  20. 38. Main unique key that identifies each record in a table
  21. 41. Combines rows from two or more tables based on related columns
  22. 43. Accuracy and consistency of data over its life cycle
  23. 44. A property or characteristic of an entity
  24. 46. SQL clause that filters rows before grouping
  25. 47. A single record in a table
  26. 48. Precompiled SQL code that can be executed repeatedly
Down
  1. 2. SQL clause that sorts the query result set
  2. 3. A stored procedure that runs automatically on an event
  3. 4. SQL routine that returns a single value
  4. 6. Command that saves all changes in a transaction
  5. 9. Language used to manage and query databases
  6. 10. A single piece of data within a record
  7. 11. SQL command used to remove records
  8. 12. SQL clause that groups rows sharing a property
  9. 13. Mechanism that prevents simultaneous access conflicts
  10. 14. Combining tables to improve read performance
  11. 20. SQL command used to retrieve data
  12. 22. Structure in a database that holds rows and columns of data
  13. 23. An object or concept about which data is stored
  14. 25. Restricts the values allowed in a column
  15. 27. Rule that limits the values in a database column
  16. 30. The structure that defines the organization of a database
  17. 32. A key used to link one table to another
  18. 33. Represents missing or undefined data
  19. 36. Copy of data for recovery purposes
  20. 37. Splitting a database into smaller, faster parts
  21. 39. Process of recovering data from a backup
  22. 40. A virtual table based on a query result
  23. 42. Central repository for integrated data analysis
  24. 45. Database feature that speeds up data retrieval