SQL Crossword
Across
- 3. A named collection of database objects, including logical structures such as tables.and indexes.
- 6. An operation that retrieves data from tables or views.
- 7. A statement having two select statements nested.
- 9. A set of privileges that can be granted to database users
- 11. A column that is not stored in a table, yet behaves like a table column.
- 12. The WHERE condition in a SQL statement.
- 13. In a table, the intersection of a row and column.
- 15. A globally unique address for a row in a database.
- 16. A join of two or more tables that returns only those rows that satisfy the join condition.
- 18. A join of a table to itself.
Down
- 1. A join with a join condition containing an equality operator.
- 2. A named SCN in a transaction to which the transaction can be rolled back.
- 4. Absence of a value in a column of a row.
- 5. The column or set of columns that uniquely identifies a row in a table.
- 8. A join that returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.
- 9. A set of column information corresponding to a single record in a table.
- 10. A fixed data value.
- 14. The right to run a particular type of SQL statement, or the right to access an object that belongs to another user.
- 17. A statement that retrieves data from multiple tables specified in the FROM clause.
- 18. A set of extents allocated for a specific database object such as a table or index.