| 1/11 | 13 | 14 | 16 | ||||||||||||||||||||
| 18 | 19 | ||||||||||||||||||||||
| 2 | |||||||||||||||||||||||
| 3 | |||||||||||||||||||||||
| 4 | |||||||||||||||||||||||
| 5/17 | |||||||||||||||||||||||
| 7/12 | 6 | ||||||||||||||||||||||
| 8 | |||||||||||||||||||||||
| 9 | |||||||||||||||||||||||
| 10 | 15 | ||||||||||||||||||||||
1. A statement in SQL that allows you to perform different actions based on a set of conditions.
2. A DDL query used to delete a table from a database.
3. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
4. A clause in SQL that limits the number of rows returned in a query result.
5. A function in SQL that performs calculations on a set of values and returns a single value.
6. A DDL query used to change the name of an existing table.
7. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
8. A rule that restricts the values allowed in certain columns or tables.
9. A table that is not physically stored in the database but is created dynamically based on the result of a query.
10. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
11. A vertical part of a table that holds a specific type of data.
12. A logical representation of the structure of a database.
13. A DDL query used to remove a column from an existing table.
14. A DDL query used to remove all the data from a table while keeping its structure intact.
15. A virtual table derived from the result of a database query, which can be treated like a regular table for data retrieval purposes.
16. A DDL query used to add a new column to an existing table.
17. A DDL query used to modify the structure of an existing table.
18. Values that are substituted into the SQL parameter query at runtime.
19. A unique identifier for each record in a table.