Across
- 1. join can be defined as a cartesian product of the two tables included in the join.
- 3. Constraints Automatically assigns a default value if no value has been specified for the field
- 5. clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those
- 10. command deletes only the rows from the table based on the condition given in the where clause or deletes all the rows from the table if no condition is specified. But it does not free the space containing the table.
- 11. operator is used to check for values contained in specific sets.
- 13. Constraints Verifies that all values in a field satisfy a condition.
- 14. operator is used to fetch rows based on a range of values.
- 16. is a query within another query.
- 18. JOIN is a case of regular join where a table is joined to itself based on some relation between its own column(s).
- 19. command is used to delete all the rows from the table and free the space containing the table.
- 20. OUTER JOIN Retrieves all the records/rows from the left and the matched records/rows from the right table.
Down
- 2. clause is used to sort the records in result set. It can only be used in SELECT statements.
- 4. is a temporary name assigned to the table or table column for the purpose of a particular SQL query
- 6. is a data structure that provides a quick lookup of data in a column or columns of a table.
- 7. clause is used in a SELECT statement to group the results by one or more columns.
- 8. statement is used to limit the number of records returned based on a limit value.
- 9. operator of SQL is used to fetch filtered data by searching for a particular pattern in the where clause.
- 12. the condition is TRUE.
- 15. Restricts NULL value from being inserted into a column.
- 17. Ensures unique values to be inserted into the field has been specified for the field.