SQL

Edit Answers
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
Across
  1. 2. - deletes a table.
  2. 5. - Holds a string with a maximum length of 16,777,215 characters.
  3. 8. - creates a new database.
  4. 11. - function returns the average value of a numeric column.
  5. 12. - A FIXED length string (can contain letters, numbers, and special characters). The size parameter specifies the column length in characters - can be from 0 to 255. Default is 1.
  6. 15. - TRUE if any of the subquery values meet the condition.
  7. 17. - operator is used to test for the existence of any record in a subquery.
  8. 19. - TRUE if all the conditions separated are TRUE.
  9. 21. - updates data in a database.
  10. 23. - Binary Large Objects max length: 255 bytes.
  11. 25. - function returns the total sum of a numeric column.
  12. 28. - inserts new data into a database.
  13. 29. - TRUE if the operand matches a pattern.
  14. 32. - creates a new table.
  15. 34. - A string object that can have 0 or more values, chosen from a list of possible values. You can list up to 64 values in a set list
  16. 35. - operator is used to filter records based on more than one condition
  17. 37. - TRUE if any of the conditions separated by # is TRUE.
  18. 40. - Holds a string with a maximum length of 255 characters.
  19. 42. - keyword returns all records when there is a match in left or right table records.
  20. 44. - selects records that have matching values in both tables.
  21. 45. - statement groups rows that have the same values into summary rows.
  22. 46. - means that the condition will be true if the operation is true for any of the values in the range.
  23. 47. - keyword returns all records from the right table, and the matching records from the left table.
  24. 48. - operator is used to combine the result-set of two or more SELECT statements.
  25. 49. - statement is used to select data from a database.
Down
  1. 1. - deletes an index.
  2. 3. - modifies a database.
  3. 4. - character is used to substitute one or more characters in a string.
  4. 6. - A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum string length in characters - can be from 0 to 65535.
  5. 7. - Holds a string with a maximum length of 65,535 bytes.
  6. 9. - Holds a string with a maximum length of 4,294,967,295 characters.
  7. 10. - expression goes through conditions and returns a value when the first condition is met.
  8. 13. - The clause was added to SQL because the WHERE keyword cannot be used with aggregate functions.
  9. 14. - creates an index.
  10. 16. - Binary Large Objects holds up to 16,777,215 bytes of data.
  11. 18. - Binary Large Objects holds up to 65,535 bytes of data.
  12. 20. - extracts data from a database.
  13. 22. - deletes data from a database.
  14. 24. - is used to filter records.
  15. 26. - constraint is used to limit the value range that can be placed in a column.
  16. 27. - Equal to CHAR(), but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1.
  17. 30. - selects values within a given range. The values can be numbers, text, or dates.
  18. 31. - Equal to VARCHAR(), but stores binary byte strings. The size parameter specifies the maximum column length in bytes.
  19. 33. - keyword returns all records from the left table, and the matching records from the right table.
  20. 36. - modifies a table.
  21. 38. - TRUE if the operand is equal to one of a list of expressions.
  22. 39. - TRUE if all of the subquery values meet the condition
  23. 41. -Binary Large Objects holds up to 4,294,967,295 bytes of data.
  24. 43. - Displays a record if the condition(s) isnt true.