1 | 15 | ||||||||||||||||||||||||
12 | 13 | 16 | |||||||||||||||||||||||
2 | 18 | ||||||||||||||||||||||||
3 | |||||||||||||||||||||||||
4 | |||||||||||||||||||||||||
17 | |||||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 | |||||||||||||||||||||||||
14 | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
10 | |||||||||||||||||||||||||
11 | |||||||||||||||||||||||||
1. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.
2. Security vulnerabilities that occur when user input is directly concatenated into SQL queries.
3. A table that is not physically stored in the database but is created dynamically based on the result of a query.
4. A vertical part of a table that holds a specific type of data.
5. A DDL query used to create a new table in a database.
6. A DDL query used to modify the structure of an existing table.
7. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
8. A DDL query used to change the name of an existing table.
9. A unique identifier for each record in a table.
10. A structured collection of data that is organized and accessible in various ways.
11. A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value.
12. A SQL statement that uses parameters to substitute variable values in the query.
13. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
14. A set of rules and symbols used for communication and expression.
15. A logical representation of the structure of a database.
16. A field in one table that refers to the primary key in another table.
17. Symbols used to represent parameter placeholders in a SQL statement.
18. A rule that restricts the values allowed in certain columns or tables.