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