THEODBS Midterm

123456789101112131415
Across
  1. 5. A join is a collection of data from multiple tables.
  2. 6. Preserves all rows from both tables.
  3. 7. allows the user to select a data or a group of data.
  4. 9. Is a module of the SQL language which allows you to retrieve, update, add or delete data in a database.
  5. 11. Maintains the proper security for the database.
  6. 14. Keyword that enables users to modify a created view.
  7. 15. Does not require each record in the two joined tables to have a matching record.
Down
  1. 1. Enables you to create and modify the database itself
  2. 2. Provides an easy way to remove duplicate rows.
  3. 3. keyword that enables users to delete a previously created view.
  4. 4. Is the standard language used to define, query, update and maintain relational databases.
  5. 8. Returns rows when there is at least one match in both tables.
  6. 10. Returns all rows from the left table(or first table), even if there are no matches in the right table.
  7. 12. Returns all the rows from the right table (or second table), even if there are no matches in the left table.
  8. 13. Are SELECT statements that have been saved in the database.