SQL

5. is a lock that is applied on data item, other transactions can only read the item, but can't write into it
6. is a function to transform the data from columns into rows
9. is acronym for Current Set of Records and is a database object pointing to a currently selected set of records
12. refers to set of rules that determine how data is sorted and compared
13. is a SQL program that is stored in the database and executed immediately before or after the INSERT, UPDATE, and DELETE commands
14. 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
15. is a function where values of multiple rows or records are joined together to get a single value output
16. is a collection of database objects that are owned by a single user
17. ensure the referential integrity of the data

1. is sometimes also called the upsert
2. 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
3. delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted
4. is a Fixed-length, non-Unicode character data with a length of n bytes
7. 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
8. is a Key composed of two of more columns
10. 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. is column with an optimized storage for null values
12. is an index that rearranges the structure of a table