1/2/12 | |||||||||||||||||||||||||
18 | |||||||||||||||||||||||||
3/14 | |||||||||||||||||||||||||
4 | |||||||||||||||||||||||||
5 | 19 | ||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
15 | |||||||||||||||||||||||||
17 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
9/13 | 8 | ||||||||||||||||||||||||
16 | |||||||||||||||||||||||||
10 | |||||||||||||||||||||||||
11 | |||||||||||||||||||||||||
1. A structured collection of data that is organized and accessible in various ways.
2. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.
3. The process of fetching specific data from a database based on certain criteria or conditions.
4. A field in one table that refers to the primary key in another table.
5. A clause in SQL that limits the number of rows returned in a query result.
6. Values that are substituted into the SQL parameter query at runtime.
7. A table that is not physically stored in the database but is created dynamically based on the result of a query.
8. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
9. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.
10. A function in SQL that performs calculations on a set of values and returns a single value.
11. A vertical part of a table that holds a specific type of data.
12. A DDL query used to remove a column from an existing table.
13. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
14. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
15. A DDL query used to create a new table in a database.
16. A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause.
17. A virtual table derived from the result of a database query, which can be treated like a regular table for data retrieval purposes.
18. A DDL query used to modify the structure of an existing table.
19. A DDL query used to delete a table from a database.