SQL Keywords

123456789101112131415161718192021
Across
  1. 5. Different types of Outer Joins are Left, Right, ____
  2. 7. Opens a cursor to retrieve query results
  3. 10. Shows a prepared query
  4. 14. VIEW Adds a new view to the database
  5. 16. A set of DDL and DML clubbed to be done together
  6. 18. Runs a SQL statement dynamically
  7. 20. Removes user access privileges
  8. 21. Retrieves data from the database
Down
  1. 1. Ends the current transaction
  2. 2. Defines a cursor for a query(3,7)
  3. 3. Closes a cursor
  4. 4. Aborts the current transaction
  5. 6. Modifies existing database data
  6. 8. Describes the data access plan for a query
  7. 9. To create a where clause after Group By
  8. 11. A Join which is more efficent than brute force
  9. 12. Grants user access privileges
  10. 13. Adds new rows of data to the database
  11. 15. Gets a SQL statement ready for dynamic execution
  12. 17. Removes rows of data from the database
  13. 19. Retrieves a row of query results