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