Across
- 4. A lock on a single row of table.
- 7. A logical entity in the database instance memory that represents the state of a current user login to a database
- 8. An operation that retrieves data from tables or views.
- 10. function that replaces null value
- 11. Action that ends a database transaction and makes permanent all changes performed in the transaction.
- 13. Optional schema object associated with a nonclustered table, table partition, or table cluster.
- 14. JavaScript Object Notation
- 16. The ratio of distinct values to the number of table rows.
- 18. A statement that retrieves data from multiple tables specified in the FROM clause
Down
- 1. A copy of data
- 2. An integrity constraint that requires each value in a column or set of columns to match a value in the unique or primary key for a related table.
- 3. Procedural language SQL.
- 5. Vertical space in a table that represents a domain of data
- 6. SQL whose complete text is not known until run time.
- 9. A join that returns rows from the left side of the predicate for which there are no corresponding rows on the right side of the predicate.
- 12. A schema object that always returns a single value
- 15. Absence of a value in a column of a row.
- 17. A globally unique address for a row in a database.
