1/12 | 16 | ||||||||||||||||||||||||
2 | |||||||||||||||||||||||||
3 | 18 | ||||||||||||||||||||||||
4 | |||||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
14 | 17 | ||||||||||||||||||||||||
7/13 | |||||||||||||||||||||||||
15 | |||||||||||||||||||||||||
8 | 19 | ||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
10 | |||||||||||||||||||||||||
11 | |||||||||||||||||||||||||
1. A rule that restricts the values allowed in certain columns or tables.
2. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.
3. A keyword in SQL used to return only unique rows in the result of a query.
4. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
5. A clause in SQL that limits the number of rows returned in a query result.
6. Security vulnerabilities that occur when user input is directly concatenated into SQL queries.
7. A DDL query used to remove a column from an existing table.
8. A DDL query used to add a new column to an existing table.
9. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.
10. A logical representation of the structure of a database.
11. A SQL statement that uses parameters to substitute variable values in the query.
12. A DDL query used to create a new table in a database.
13. A structured collection of data that is organized and accessible in various ways.
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 specify conditions on groups of rows created by the 'GROUP BY' clause.
16. A DDL query used to modify the structure of an existing table.
17. A request for data or information from a database, typically written in a specific query language such as SQL.
18. A statement in SQL that allows you to perform different actions based on a set of conditions.
19. A DDL query used to delete a table from a database.