1/2/12
18
3/14
4
5 19
6
15
17
7
9/13 8
16
10
11

Crossword: SQL Queries

Across

1. A structured collection of data that is organized and accessible in various ways.

2. A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables.

3. The process of fetching specific data from a database based on certain criteria or conditions.

4. A field in one table that refers to the primary key in another table.

5. A clause in SQL that limits the number of rows returned in a query result.

6. Values that are substituted into the SQL parameter query at runtime.

7. A table that is not physically stored in the database but is created dynamically based on the result of a query.

8. A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria.

9. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.

10. A function in SQL that performs calculations on a set of values and returns a single value.

11. A vertical part of a table that holds a specific type of data.

Down

12. A DDL query used to remove a column from an existing table.

13. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.

14. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.

15. A DDL query used to create a new table in a database.

16. A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause.

17. A virtual table derived from the result of a database query, which can be treated like a regular table for data retrieval purposes.

18. A DDL query used to modify the structure of an existing table.

19. A DDL query used to delete a table from a database.


🖶

Shortcuts

Left: ⇤ Right: ⇥ Up: ↑ Down: ↓