Question

Match the proper SQL Functions with the description that best fits its purpose.

1.   
SELECT

2.
INSERT

3.
CREATE

4.
ORDER BY

5.
WHERE

6.
DISTINCT

==============================================================================

A.  
Allows users to look at portions of data through querying.

B.  
Allows users to enter a new record (row) into a table.

C.  
Allows users to build a new object in a database (IE A database or table).

D.  
Allows users to sort their query results upon a given column.

E.  
Allows users to extract only records (rows) that fulfill a specific condition.

F.  
Allows users to eliminate duplicate records (rows) in their query results.

Answer 1

Yes, Your order is correct.

1.   
SELECT
Allows users to look at portions of data through querying.


2.
INSERT
Allows users to enter a new record (row) into a table.


3.
CREATE
Allows users to build a new object in a database (IE A database or table).


4.
ORDER BY
Allows users to sort their query results upon a given column.


5.
WHERE
Allows users to extract only records (rows) that fulfill a specific condition.


6.
DISTINCT
Allows users to eliminate duplicate records (rows) in their query results.