Production Team

8. A language used to manage and manipulate relational databases through querying, updating, and organizing data.
11. A SQL function that performs a calculation on a set of values and returns a single value.
12. A rule applied to data in a table to enforce data integrity, such as NOT NULL or UNIQUE.
13. A database feature that improves query speed by providing faster access to data rows.
15. A process in database design to reduce redundancy and improve data integrity.
17. A precompiled collection of SQL statements stored in the database that can be executed as a single unit.
18. A virtual table in SQL that provides a way to simplify complex queries by encapsulating them into reusable objects.
19. A SQL clause used in window functions to break the result set into partitions and perform calculations on each.

1. A database object that automatically executes a specified action when certain conditions are met.
2. A situation in SQL where two or more transactions are waiting for each other to release locks, causing a standstill.
3. A structured database model where data is organized in tables with rows and columns.
4. A SQL join that returns the Cartesian product of two tables, matching every row in the first table with every row in the second table.
5. The structure or organization of a database, defining how data is stored, accessed, and managed.
6. A query nested inside another SQL query, often used to retrieve data that will be used in the main query.
7. A unique identifier for each record in a SQL database table.
9. A reusable block of SQL code that performs a specific task and returns a value, used to encapsulate logic for repeated use.
10. A SQL operation used to combine rows from two or more tables based on a related column.
12. A SQL expression that allows you to define a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
14. A sequence of database operations that are treated as a single unit of work, which can be committed or rolled back.
16. A column in a SQL table that creates a relationship between two tables.