ANSWER ALL THE QUESTIONS

SOME GUY KEEPS POSTING THE ANWSERS BUT DOSENT SOLVE 2-4

SO PLEASE ANWSER ALL

CIST 1220 SQL - Test #2

Spring Semester, 2018

(125 Points) --- Good Luck!

Take Home Questions Give Details

( ANSWER ALL QUESTIONS THEY ALLL SHOULD BE AT LEAST 2 TO 3 PARAGRAPHS IN LENGHT)

1.(15 Points) Describe the 3 major types of SQL statements and describe the 4 primary Data Manipulation statements.

2.(15 Points) Describe all of the different options you have for the Where clause.(i.e. Like, In, etc)

3.(10 Points) Describe the difference between Order By and Group By.

4.(15 Points) Describe how the use of an INDEX will make queries using Order By much faster.