1 | 15 | ||||||||||||||||||||||
2 | |||||||||||||||||||||||
12 | |||||||||||||||||||||||
3 | |||||||||||||||||||||||
4 | 5 | 17 | |||||||||||||||||||||
19 | |||||||||||||||||||||||
16 | |||||||||||||||||||||||
6 | |||||||||||||||||||||||
13 | |||||||||||||||||||||||
18 | |||||||||||||||||||||||
7 | |||||||||||||||||||||||
8 | |||||||||||||||||||||||
9 | |||||||||||||||||||||||
14 | |||||||||||||||||||||||
10 | |||||||||||||||||||||||
11 | |||||||||||||||||||||||
1. A unique identifier for each record in a table.
2. A SQL operation used to combine rows from two or more tables based on a related column between them.
3. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.
4. A set of rules and symbols used for communication and expression.
5. A logical representation of the structure of a database.
6. Symbols used to represent parameter placeholders in a SQL statement.
7. A DDL query used to create a new table in a database.
8. Values that are substituted into the SQL parameter query at runtime.
9. A function in SQL that performs calculations on a set of values and returns a single value.
10. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.
11. A DDL query used to delete a table from a database.
12. A DDL query used to add a new column to an existing table.
13. A clause in SQL that is used to group rows based on one or more columns.
14. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
15. Security vulnerabilities that occur when user input is directly concatenated into SQL queries.
16. A DDL query used to change the name of an existing table.
17. A vertical part of a table that holds a specific type of data.
18. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
19. A table that is not physically stored in the database but is created dynamically based on the result of a query.