SQL

Edit Answers
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
Across
  1. 2. | Arithmetic operator represented by % (gives the remainder) |
  2. 3. | Rules applied to table columns to maintain data accuracy and integrity |
  3. 5. | Columns that make up tables in the relational data model |
  4. 11. | Constraint that assigns a value automatically when none is provided |
  5. 16. | DML command to remove records from a table |
  6. 17. | DCL command used to remove granted permissions from users |
  7. 18. | DQL command used to retrieve specific data based on conditions |
  8. 19. | Any column(s) that can qualify as Primary Key |
  9. 23. | Command category managing operations using commit, rollback, and savepoint |
  10. 25. | Candidate keys that were not chosen as the Primary Key |
  11. 29. | Conceptual framework defining how data is organized into tables |
  12. 31. | Join type that returns the Cartesian product (all combinations of rows) |
  13. 34. | Any set of columns that uniquely identify rows (PK plus extras) |
  14. 35. | Command category managing data stored inside database tables (Insert, Update, Delete) |
  15. 37. | Range operator testing if a value matches any item in a list |
  16. 38. | Set operator combining results from two queries and removing duplicates |
  17. 40. | Unique identifier for each record, combining NOT NULL and UNIQUE |
  18. 44. | Combination of two or more columns to uniquely identify a record |
  19. 46. | Functions used to summarize data, such as COUNT, AVG, or SUM |
  20. 47. | Constraint ensuring a column cannot have missing values |
  21. 49. | Organization that adopted SQL as a standard in 1987 |
  22. 51. | Pattern matching operator using % (any characters) or \_ (one character) wildcards |
  23. 52. | Constraint ensuring all values in a column are different |
  24. 54. | DCL command used to provide privileges to users |
  25. 56. | Scalar function that adjusts a numeric value to a specified number of decimal places |
  26. 57. | Alternative set operator returning rows in the first query but not the second |
  27. 58. | Command category for fetching and querying data from the database |
  28. 59. | DML command to add new records (rows) into a table |
Down
  1. 1. | Join type returning all rows from both tables, with NULLs where there is no match |
  2. 4. | DDL command to delete databases or tables permanently |
  3. 6. | Set operator returning only rows common to both queries |
  4. 7. | Data organized into tables in the relational data model |
  5. 8. | DML command to modify existing records with new values |
  6. 9. | Scalar function used to display text in capital letters |
  7. 10. | Rows that make up tables in the relational data model |
  8. 12. | Special operator comparing a value with at least one value in a list |
  9. 13. | Constraint ensuring values meet a specified condition (e.g., Age >= 18) |
  10. 14. | TCL command to undo changes made by the last transaction |
  11. 15. | Set operator returning rows in the first query but not in the second |
  12. 20. | Range operator testing if a value lies in an inclusive range |
  13. 21. | Constraint maintaining referential integrity by linking two tables |
  14. 22. | Join type where a table joins with itself (used for comparisons or hierarchy) |
  15. 24. | Join type returning all rows from the left table and matched rows from the right |
  16. 25. | Special operator comparing a value with every value in a list |
  17. 26. Organization that adopted SQL as a standard in 1986 |
  18. 27. | DDL command to make new databases, tables, or views |
  19. 28. | Command category controlling access and permissions for users |
  20. 30. | Join type that returns only rows with matching values in both tables |
  21. 31. | TCL command to save all changes permanently to the database |
  22. 32. Standardized programming language used to manage and manipulate data in RDBMS |
  23. 33. | Logical operator requiring at least one condition to be true |
  24. 36. | TCL command marking a point in a transaction to roll back partially |
  25. 39. | Functions that transform or manipulate data, such as ROUND or UPPER |
  26. 41. | Logical operator requiring both conditions to be true |
  27. 42. | Join type returning all rows from the right table and matched rows from the left |
  28. 43. | DDL command to modify existing database objects (e.g., adding a column) |
  29. 45. | Operator used to test specifically for missing values |
  30. 48. | Command category defining the structure of the database |
  31. 50. | The logical structure or blueprint of a database; a container holding objects like tables and views |
  32. 53. | Special operator returning TRUE if a subquery returns any rows |
  33. 55. | Logical operator that negates a condition |