| 1 | 10 | ||||||||||||||||||||||||
| 16 | |||||||||||||||||||||||||
| 3 | 2 | ||||||||||||||||||||||||
| 14 | |||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||
| 5 | |||||||||||||||||||||||||
| 6 | 11 | ||||||||||||||||||||||||
| 15 | |||||||||||||||||||||||||
| 7 | 12 | 13 | |||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||
| 9 | |||||||||||||||||||||||||
1. A set of rules and symbols used for communication and expression.
2. A keyword in SQL used to return only unique rows in the result of a query.
3. A clause in SQL that is used to group rows based on one or more columns.
4. A SQL statement that uses parameters to substitute variable values in the query.
5. A rule that restricts the values allowed in certain columns or tables.
6. A unique identifier for each record in a table.
7. A structured collection of data that is organized and accessible in various ways.
8. The process of fetching specific data from a database based on certain criteria or conditions.
9. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
10. A function in SQL that performs calculations on a set of values and returns a single value.
11. A DDL query used to change the name of an existing table.
12. A DDL query used to modify the structure of an existing table.
13. A logical representation of the structure of a database.
14. A DDL query used to delete a table from a database.
15. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
16. A table that is not physically stored in the database but is created dynamically based on the result of a query.