Basic SQL
In SQL, this clause is used to filter results based on a condition.
WHERE
This SQL clause is used to group rows that have the same values in specified columns into summary rows.
GROUP BY
This SQL feature allows users to create a virtual table based on a query.
VIEW
This Java API allows applications to connect and interact with relational databases like MySQL.
JDBC (Java Database Connectivity)
This process organizes a database to reduce redundancy and improve integrity.
Normalization
This SQL command is used to add a new record into a database table.
INSERT
This SQL clause is used to filter groups after aggregation has been applied.
HAVING
This keyword is used to specify that a procedure parameter both receives and returns a value.
INOUT
This Python method fetches the next single row of a query result when using a cursor.
fetchone()
In a relation, when one attribute uniquely determines another, this is called a ____.
Functional Dependency
In SQL, this type of join returns all records from both tables when there is a match in either table.
FULL OUTER JOIN
This SQL clause allows a user to define a temporary table that exists only for a particular query.
WITH (Common Table Expression - CTE)
This type of SQL procedure is stored on the server and can be executed with a single call, reducing the need for multiple queries.
Stored Procedure
This SQL programming technique allows SQL statements to be embedded inside a general-purpose programming language like C or Java.
Embedded SQL
This normal form ensures that every attribute in a relation depends on the entire primary key and not just a part of it.
2nd Normal Form (2NF)
This SQL constraint ensures that a column cannot contain NULL values.
NOT NULL
This type of SQL join ensures that all rows from the left table appear in the result set, even if there is no matching row in the right table.
LEFT OUTER JOIN
This feature in SQL enables database actions to be automatically executed in response to specific events such as INSERT, UPDATE, or DELETE.
Trigger
In the MVP architecture, this component is responsible for holding the application’s data and handling business logic, without any direct access to the View.
Model
This type of dependency occurs when an attribute is indirectly dependent on a primary key through another non-key attribute.
Transitive Dependency
In SQL, this clause is used to combine multiple SQL statements into a single result set, removing duplicates.
UNION
This SQL keyword is used to implement recursive queries, allowing hierarchical data retrieval.
WITH RECURSIVE
This type of stored procedure cursor allows row-by-row processing of query results, enabling iteration over multiple rows within a procedure.
Cursor
This term refers to incompatibilities between a host programming language and the database model, such as type mismatch or conceptual model differences.
Impedance Mismatch
This is a stronger version of 3NF, ensuring that every determinant is a superkey.
Boyce-Codd Normal Form (BCNF)