1/12 | 14 | 18 | |||||||||||||||||||||||
2 | |||||||||||||||||||||||||
3 | |||||||||||||||||||||||||
4 | 17 | ||||||||||||||||||||||||
15 | |||||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | 13 | ||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
10 | 16 | ||||||||||||||||||||||||
11 | |||||||||||||||||||||||||
1. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.
2. Symbols used to represent parameter placeholders in a SQL statement.
3. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
4. A table that is not physically stored in the database but is created dynamically based on the result of a query.
5. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
6. A function in SQL that performs calculations on a set of values and returns a single value.
7. A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause.
8. A statement in SQL that allows you to perform different actions based on a set of conditions.
9. The process of fetching specific data from a database based on certain criteria or conditions.
10. A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value.
11. A SQL statement that uses parameters to substitute variable values in the query.
12. A structured collection of data that is organized and accessible in various ways.
13. A clause in SQL that is used to group rows based on one or more columns.
14. The process of arranging rows in a SQL table in a specific order based on one or more columns.
15. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
16. A clause in SQL that limits the number of rows returned in a query result.
17. Security vulnerabilities that occur when user input is directly concatenated into SQL queries.
18. A keyword in SQL used to return only unique rows in the result of a query.