SQL - Domain 4 - 6

123456789101112131415161718192021222324
Across
  1. 2. A SQL keyword used to limit the number of records returned in a query.
  2. 3. A server app that stores databases and all related database settings.
  3. 5. An error in coding usually caused by improper punctuation, incorrect spelling of a keyword, or an incorrect ordering of keywords within a code block.
  4. 7. A word, part of the language aspect of SQL, used to formulate part of a SQL statement.
  5. 12. A SQL keyword set used to empty all the data from an entity.
  6. 13. A SQL keyword used to filter records from recordset during a query
  7. 15. A keyword used to return two or more entities as a single dataset within a query.
  8. 16. A SQL keyword used to change data within an entity.
  9. 17. A SQL Server object that is a saved query for retrieving data.
  10. 18. A SQL statement that copies records from one entity into a new entity.
  11. 20. A block of data with values for each field or column. Also known as a record.
  12. 21. In a one-to-many relationship, assurance that a value is entered in the primary key of the entity being used as the one side of the relationship before that same value is allowed on the many side of the relationship.
  13. 22. An error that occurs during the execution of code.
  14. 23. A defined set of permissions within a database.
  15. 24. A SQL keyword used to retrieve data from a database.
Down
  1. 1. A block of code that serves either as a data query or a command to add, update, or remove data or an object from a database.
  2. 4. A data type that holds a set number of characters in a field.
  3. 6. A database with entities that have data that can be joined with each other through a field common to both entities.
  4. 8. A SQL server object that is a saved query for retrieving or changing data.
  5. 9. A SQL keyword used to convert a number to a string.
  6. 10. A SQL keyword used as part of an INSERT statement that controls what is added to an entity.
  7. 11. A join that relates two fields from the same entity to each other.
  8. 14. A keyword used to generate and hold a value that is the result of a stored procedure.
  9. 15. A character type that allows for numbers, letters, and symbols, including foreign language symbols.
  10. 19. The process of replacing lost or corrupt data with a copy of that data.
  11. 23. A block of data with values for each field or column. Also known as a row.