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.

5.(15 Points) Explain just what Data Integrity is and how the use of Constraints may result in better Data Integrity.

6.(10 Points) Explain exactly how a Join works. What is a Cartesian Product?

7.(15 Points) Briefly describe the difference and similarities between a Join and a Correlated Sub-Query. Discuss the advantages and disadvantages of each.

8.(10 Points) Describe a Transaction. What is a transaction and what keywords are used to create transactions?

9.(10 Points) What is the Transaction Log? Describe how it works and what it is used for.

10.(10 Points) What are Triggers and Stored Procedures and how can they be used to make a database better?