| 1 | 12 | ||||||||||||||||||||||
| 2 | |||||||||||||||||||||||
| 16 | 19 | ||||||||||||||||||||||
| 14 | |||||||||||||||||||||||
| 3 | |||||||||||||||||||||||
| 18 | |||||||||||||||||||||||
| 17 | |||||||||||||||||||||||
| 4 | |||||||||||||||||||||||
| 5 | |||||||||||||||||||||||
| 6 | |||||||||||||||||||||||
| 13 | |||||||||||||||||||||||
| 7 | |||||||||||||||||||||||
| 8/15 | |||||||||||||||||||||||
| 9 | |||||||||||||||||||||||
| 10 | |||||||||||||||||||||||
| 11 |
1. A SQL statement that uses parameters to substitute variable values in the query.
2. A clause in SQL that is used to group rows based on one or more columns.
3. Values that are substituted into the SQL parameter query at runtime.
4. Security vulnerabilities that occur when user input is directly concatenated into SQL queries.
5. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
6. A statement in SQL that allows you to perform different actions based on a set of conditions.
7. A request for data or information from a database, typically written in a specific query language such as SQL.
8. The process of fetching specific data from a database based on certain criteria or conditions.
9. A table that is not physically stored in the database but is created dynamically based on the result of a query.
10. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.
11. Symbols used to represent parameter placeholders in a SQL statement.
12. A function in SQL that performs calculations on a set of values and returns a single value.
13. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
14. A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause.
15. A keyword in SQL used to return only unique rows in the result of a query.
16. A virtual table derived from the result of a database query, which can be treated like a regular table for data retrieval purposes.
17. A SQL operation used to combine rows from two or more tables based on a related column between them.
18. A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value.
19. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.