SQL-CROSSWORD

Edit Answers
123456789101112131415161718192021222324
Across
  1. 1. delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted
  2. 4. is a function compares two expressions. If they are equal, the function returns null. If they are not equal, the first expression is returned
  3. 5. Synonym for rows
  4. 7. is a SQL program that is stored in the database and executed immediately before or after the INSERT, UPDATE, and DELETE commands
  5. 8. is a Key composed of two of more columns
  6. 10. is a lock that is applied on data item, other transactions can only read the item, but can't write into it
  7. 11. ensure the referential integrity of the data
  8. 13. verifies a check on a table value
  9. 14. Replaces null with the specified replacement value
  10. 15. 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
  11. 16. is column with an optimized storage for null values
  12. 19. refers to set of rules that determine how data is sorted and compared
  13. 22. Marks the end of a transaction and makes the changes permanent.
  14. 23. is a function where values of multiple rows or records are joined together to get a single value output
  15. 24. returns the first nonull expression among its arguments
Down
  1. 2. is an index that rearranges the structure of a table
  2. 3. returns the current system date and time
  3. 6. Combines each row from one table with each row of the other table
  4. 9. 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. 12. is a collection of database objects that are owned by a single user
  6. 17. is a function to transform the data from columns into rows
  7. 18. 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. 20. is sometimes also called the upsert
  9. 21. is a Fixed-length, non-Unicode character data with a length of n bytes