Across
- 1. is used along with the where clause to select the rows for which both the conditions are true
- 3. is a standardized programming language that is used to manage relational databases and perform various operations on the data in them
- 7. into inserts new data into a database
- 9. database modifies a database
- 10. is used with where clause to include the rows in the result set in case of either condition is true
- 13. updates data from a database
- 14. key it uniquely identifies each of the records
- 16. is used for sorting the data returned by the sql query in ascending order
- 17. extracts data from a database
- 18. is used to filter the result set so that only the values satisfying the condition are included
Down
- 1. is used as an alias to rename the column or table
- 2. deletes data from a database
- 4. is a request for data or information from a database table or combination of tables
- 5. it can be used to delete a database, table, view, column, index and etc.
- 6. table creates a new table
- 8. is used to delete the data in a table, but it does not delete the structure of the table
- 11. describes the portion of SQL that creates, alters and deletes database objects
- 12. this keyword retrieves the records from the table in order to limit them based on the limit value
- 15. this keyword is used to specify the column or values to be updated
- 19. is used with aggregate functions and group by instead of the where clause to filter the values of a result set