Structured query language commands and functions

1234567891011121314151617181920
Across
  1. 1. used to remove all records from a table, including all spaces allocated for the records are removed
  2. 6. command is used to create the database or its objects
  3. 10. used to insert data into a table
  4. 11. Specify characteristics for the transaction
  5. 12. It is used to retrieve data from the database
  6. 15. Call a PL/SQL or JAVA subprogram
  7. 16. Rollbacks a transaction in case of any error occurs
  8. 18. used to delete records from a database table
  9. 20. Sets a savepoint within a transaction
Down
  1. 2. It describes the access path to data
  2. 3. command is used to delete objects from the database
  3. 4. handles all the joining of the source and target
  4. 5. Commits a Transaction
  5. 7. used to update existing data within a table
  6. 8. used to rename an object existing in the database
  7. 9. command gives users access privileges to the database
  8. 13. Table control concurrency
  9. 14. used to add comments to the data dictionary
  10. 17. used to alter the structure of the database
  11. 19. command withdraws the user’s access privileges