1/10 | |||||||||||||||||||||||||
16 | |||||||||||||||||||||||||
14 | |||||||||||||||||||||||||
11 | 2 | ||||||||||||||||||||||||
15 | |||||||||||||||||||||||||
12 | 3 | 17 | |||||||||||||||||||||||
4 | |||||||||||||||||||||||||
5 | 18 | ||||||||||||||||||||||||
13 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
1. A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value.
2. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
3. A function in SQL that performs calculations on a set of values and returns a single value.
4. A keyword in SQL used to return only unique rows in the result of a query.
5. The process of arranging rows in a SQL table in a specific order based on one or more columns.
6. A clause in SQL that limits the number of rows returned in a query result.
7. A table that is not physically stored in the database but is created dynamically based on the result of a query.
8. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
9. Values that are substituted into the SQL parameter query at runtime.
10. A SQL statement that uses parameters to substitute variable values in the query.
11. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.
12. A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause.
13. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
14. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.
15. Symbols used to represent parameter placeholders in a SQL statement.
16. A request for data or information from a database, typically written in a specific query language such as SQL.
17. A clause in SQL that is used to group rows based on one or more columns.
18. A statement in SQL that allows you to perform different actions based on a set of conditions.