DBA

 

Match the following terms to the appropriate definition:          

1.  equi-join    

2.derived table          

3.natural join          

4.correlated subquery          

5.outer join          

6.trigger

1. returns all records of a designated table
2. keeps redundant columns

      3. utilizes values from the main query in the subquery

      4. the outcome of a query embedded in the FROM clause 

      5. A set of SQL statements executed under specific conditions

      6. does not keep redundant columns