Simple Joins

Quiz Summary

0 of 7 Questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 7 Questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Current
Review
Answered
Correct
Incorrect

Question 1 of 7

1. Question
What SQL would you write to display the state name and region name for each state? Hint…keep the column names in same order as question!
- SELECT States.state, States.Region FROM States
- SELECT States.state, Regions.regionname from FROM JOIN regions ON States.region=Regions.RegionName
- SELECT States.state, States.RegionName FROM States
- SELECT States.state, Regions.regionname from FROM JOIN regions ON States.region=Regions.regionid
Correct

Incorrect
Question 2 of 7

2. Question
What SQL would you write to display the state name, date of statehood, Capitol, Largest City, Region Name and Region Description for each state?
- This response will be awarded full points automatically, but it can be reviewed and adjusted after submission.
Grading can be reviewed and adjusted.

Grading can be reviewed and adjusted.
Question 3 of 7

3. Question
Wow…that was a lot of writing. What technique should we use to make this easier?
- UNION
- SUBQUERY
- ALIAS
- INNER JOIN
- OUTER JOIN
Correct

Incorrect
Question 4 of 7

4. Question
What is the correct form of using a table alias?
- SELECT column1, column 2 FROM table1 t WHERE column1 = value1
- SELECT t.column1, t.column 2 FROM table1 t WHERE column1 = value1
- SELECT t.column1, t.column 2 FROM table1 WHERE column1 = value1
- SELECT t.column1, t.column 2 FROM table1 t WHERE t.column1 = value1
- SELECT t.column1, t.column 2 FROM table1 WHERE t.column1 = value1
Correct

Incorrect
Question 5 of 7

5. Question
What should an alias look like?
- As short as possible.
- Length doesn't matter – used for clarity
- Resembling the table name.
- Using the first letter of the table name.
- Uses your own scheme.
- To provide some humor.
- Unique
Correct

Incorrect
Question 6 of 7

6. Question
Rewrite the SQL you would write to display the state name, date of statehood, Capitol, Largest City, Region Name and Region Description for each state using aliases.
- This response will be awarded full points automatically, but it can be reviewed and adjusted after submission.
Grading can be reviewed and adjusted.

Grading can be reviewed and adjusted.
Question 7 of 7

7. Question
Write the SQL that gives you the names of the states where the word “warm” is the region description. Use aliases.
- This response will be awarded full points automatically, but it can be reviewed and adjusted after submission.
Grading can be reviewed and adjusted.

Grading can be reviewed and adjusted.

Simple Joins

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question