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

Crossword: Database Manipulation Language

Across

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.

Down

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.


🖶

Shortcuts

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