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

Question

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.

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?

Explanation / Answer

Hi Friend,

As per the chegg policy, please post one question per post.

I have answered Q1.

Please repost others in separate post.

3 major types of SQL statements:

DML (Data Manipulation Language): Commands used in Data Manipulation are

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.