SQL Cossword

Edit Answers
1234567891011121314151617181920212223
Across
  1. 5. ensure the referential integrity of the data
  2. 7. Marks the end of a transaction and makes the changes permanent.
  3. 9. Replaces null with the specified replacement value
  4. 11. refers to set of rules that determine how data is sorted and compared
  5. 14. is column with an optimized storage for null values
  6. 16. verifies a check on a table value
  7. 18. is a function to transform the data from columns into rows
  8. 19. Synonym for rows
  9. 20. is a collection of database objects that are owned by a single user
  10. 21. returns the current system date and time
  11. 23. is a Fixed-length, non-Unicode character data with a length of n bytes
Down
  1. 1. is a lock that is applied on data item, other transactions can only read the item, but can't write into it
  2. 2. returns the first nonull expression among its arguments
  3. 3. is sometimes also called the upsert
  4. 4. is the process of organizing data to minimize redundancy and remove ambiguity. It involves separating a database into tables and defining relationships between the tables
  5. 6. is an index that rearranges the structure of a table
  6. 8. is a SQL program that is stored in the database and executed immediately before or after the INSERT, UPDATE, and DELETE commands
  7. 10. is the SET operator allows you to combine the results of two or more SELECT statements into a single result set. And it’ll not apply SORT
  8. 12. Combines each row from one table with each row of the other table
  9. 13. is a function where values of multiple rows or records are joined together to get a single value output
  10. 15. is a function compares two expressions. If they are equal, the function returns null. If they are not equal, the first expression is returned
  11. 16. is a Key composed of two of more columns
  12. 17. delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted
  13. 22. is an alternative name for a table or column in expressions that is often used to shorten the name for subsequent reference in code, prevent possible ambiguous references, or provide a more descriptive name in the query output