CSE :: Database System 2 - CS
- A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
- When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
- The UNION clause is used to combine the output from multiple queries together into a single result table.
- The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
- Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
- A correlated subquery is where the outer query depends on data from the inner query.
- With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
Whatsapp
Facebook
