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.

Explanation / Answer

1.

3 major types of SQL statements:

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

2.

Different options in Where clause:

The SQL WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables. If the given condition is satisfied, then only it returns a specific value from the table.

“Like” is used while searching for a string

“In”

The IN operator allows you to specify multiple values in a WHERE clause.

The IN operator is a shorthand for multiple OR conditions.

3.

The ORDER BY clause’s purpose is to sort the query result by specific columns. Like sorting in ascending or descending order

The GROUP BY clause’s purpose is summarize unique combinations of columns values., which is used to group like column values into a single row.

4.

Use of Index to fasten Order By:

MySQL can use an index to satisfy an ORDER BY clause without doing extra sorting.

The index can also be used even if the ORDER BY does not match the index exactly, as long as all unused portions of the index and all extra ORDER BY columns are constants in theWHERE clause.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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