SQL-CROSSWORD

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