Crossword on SQL

123456789101112
Across
  1. 1. A command that lets you change one or more field in a table
  2. 5. Each row in a table uniquely identify by a key
  3. 6. The collection of information stored in a database at a particular moment is
  4. 7. In which mode parameter lets you pass values to the subprogram being called? It cannot be assigned a value
  5. 9. Is used to combines the records from one or more tables
  6. 10. Operator tests column for absence of data
  7. 11. Subquery are used for row by row processing. Each subquery executed once for every row of the outer query
Down
  1. 2. The description of structure and organization of data in a database is contained in
  2. 3. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery.
  3. 4. The _____________ is essentially used to search for patterns in target string.
  4. 8. You can pefrom DML operations on simple view (TRUE/False)
  5. 12. If we have not specified ASC or DESC after a SQL ORDER BY clause, the_______is used by default.