Question

Match the keyword with its function

Makes something new, typically a table Provides values to a table Declares a constraint on a table Chooses or reorders columns Declares which tables are present Identifies records of interest Renames either a column or a table Combines two tables or queries with equivalent structure Finds records that are shared between two tables or queries Determines items from a table or query that are not in the other table or query Extends records from one table (at the beginning) with another over a common attribute Extends data from one table (at the end) with data from another table over a common attribute Attempts to match up data over a common attribute, displaying the matched data only Attaches data together over a common attribute (if it exists or not) and shows all data in both tables Tries to mimic a text pattern Declares a data entry linkage between two tables Declares the identifier of record for a table The value cannot be replicated, but it is not indexed Condition applying to an aggregated group Used to facilitate conditional aggregation

A. INNER JOIN B. AS C. FOREIGN KEY D. INTERSECT E. HAVING F. OUTER JOIN G. UNION H. LIKE I. WHERE J. EXCEPT/MINUS K. CHECK L. UNIQUE M. INSERT INTO N. GROUP BY O. CREATE P. LEFT JOIN Q. SELECT R. PRIMARY KEY S. FROM T. RIGHT JOIN

Answer 1

Answer:------------

Makes something new, typically a table ===>  O. CREATE

Provides values to a table ====> M. INSERT INTO

Declares a constraint on a table ===> K. CHECK

Chooses or reorders columns ===> Q. SELECT

Declares which tables are present ===> S. FROM

Identifies records of interest ===> I. WHERE

Renames either a column or a table ====> B. AS

Combines two tables or queries with equivalent structure. ===> L. UNION

Finds records that are shared between two tables or queries.. ===> D. INTERSECT

Determines items from a table or query that are not in the other table or query. ===> j. EXCEPT/MINUS

Extends records from one table (at the beginning) with another over a common attribute. ==> P. LEFT JOIN

Extends data from one table (at the end) with data from another table over a common attribute. ===> T. RIGHT JOIN

Attempts to match up data over a common attribute, displaying the matched data only.===> A. INNER JOIN

Attaches data together over a common attribute (if it exists or not) and shows all data in both tables.===> F.OUTER JOIN

Tries to mimic a text pattern. ===> H. Like

Declares a data entry linkage between two tables. ===> C. FOREIGN KEY

Declares the identifier of record for a table. ===>R. PRIMARY KEY

The value cannot be replicated, but it is not indexed. ===> L. UNIQUE

Condition applying to an aggregated group. ===> E. HAVING

Used to facilitate conditional aggregation. ===> N. GROUP BY