Question 12 PointsWhat type of JOIN returns all rows from the first table and any matching rows from the second table? FULL OUTER JOIN LEFT OUTER JOIN INNER JOIN RIGHT OUTER JOIN Question 22 PointsWhi

  1. Question 12 Points

What type of JOIN returns all rows from the first table and any matching rows from the second table?





  1. Question 22 Points

Which records will the following FROM clause select?

FROM Faculty LEFT JOIN Classes

All Faculty records and any Class records that are related to them

Any Class records that are related to Faculty records

All Class records and any Faculty records that are related to them

Any Faculty records that are related to Class records

  1. Question 32 Points

When testing for NULL values to find Customers who have no Orders, which column is best to include in the WHERE clause below:

WHERE __________ IS NULL

Any foreign key from the Customers table

The primary key from the Customers table

The OrderDate column from the Orders table

The primary key from the Orders table

  1. Question 42 Points

What type of JOIN returns all rows from the second table and any matching rows from the first table?





  1. Question 52 Points

What clause can be placed after the UNION keyword to indicate that you want the UNION performed by comparing columns that have the same name in each result set?





  1. Question 62 Points

Where is the ORDER BY clause placed to sort the results of a UNION?

The results of a UNION cannot be sorted

At the end of each SELECT statement

At the end of the last SELECT statement

At the end of the first SELECT statement

  1. Question 72 Points

When the _________ keyword is left out of a UNION, the database system automatically eliminates any duplicate rows.





  1. Question 82 Points

Which of the following is a requirement for the columns of the SELECT statements in a UNION?

Must have the same number of output columns specified.

Neither of these are requirements.

Each corresponding column must have a comparable value.

Both of these are requirements.

  1. Question 92 Points

A SELECT expression that is embedded within one of the clauses of a SELECT statement is a(n) ____________.

embedded SELECT


embedded query


  1. Question 102 Points

Which of the following is a request that can be answered using a subquery?

Create a list that combines agents and entertainers.

Create an index list of all the recipe classes, recipe titles, and ingredients.

Display products and the latest date the product was ordered.

Show me the students who have a grade of 85 or better in Art together with the faculty members who teach Art and have a proficiency rating of 9 or better.

  1. Question 112 Points

What type of subquery is an embedded SELECT expression that returns only one column and no more than one row?

Table subquery

Row subquery

Scalar subquery

  1. Question 122 Points

Which aggregate function calculates the mean for a value expression?

MAX(value expression)

MIN(value expression)

SUM(value expression)

AVG(value expression)

  1. Question 132 Points

When an aggregate function is used as a search condition it must be placed in (a) __________.

brackets []


parentheses ()

braces {}

  1. Question 142 Points

When using an aggregate function, what is the name of the column in the final result set?

The name is generated by the database system.

The name assigned in the AS clause.

None of these are possible names for the column.

All of these are possible names for the column.

The column has no name.

  1. Question 152 Points

What character is used to separate the columns referenced in the GROUP BY clause?

Comma ,

Period .

Colon :

Semicolon ;

  1. Question 162 Points

Which clause is used to group matching values of a specified column together?






  1. Question 172 Points

When the GROUP BY clause is used without aggregate functions it will give you the same result as what keyword?





  1. Question 182 Points

Columns referenced in the WHERE clause must be a part of what?

The columns referenced in the ORDER BY clause.

Tables defined in the FROM clause.

The columns referenced in the SELECT clause.

The columns used in aggregate functions.

  1. Question 192 Points

Columns referenced in the HAVING clause must also be referenced where?

Enclosed within an aggregate function

Neither in the GROUP BY clause nor enclosed within an aggregate function

In the GROUP BY clause

Either in the GROUP BY clause or enclosed within an aggregate function

  1. Question 202 Points

When does the WHERE clause act on rows?

After the rows have been grouped

Before the rows are grouped

During the grouping of rows

  1. Question 212 Points

What SQL feature enables you to undo a series of changes to the data?

System Updates



UPDATE statements

  1. Question 222 Points

What character is used to separate multiple assignment statements in the SET clause?

Colon :

Semicolon ;

Comma ,

Period .

  1. Question 232 Points

What need would NOT be addressed with an UPDATE statement?

Increasing the price of all sports supplements by 3%

Creating a list of all supplements that contain Creatine by manufacturer

Appending the word ?powder? to all ItemDescriptions for MuscleMilk products

Changing the category of all sports supplements to ?Nutrition?

  1. Question 242 Points

If the new value of a column involves the old or current value of the column, the column must be referenced where?

The left side of the equal sign

The UPDATE clause

The WHERE clause

Both sides of the equal sign

  1. Question 252 Points

Data can be inserted into a table or what other database item?




Stored procedure

  1. Question 262 Points

When the INSERT statement is fetching rows of data to be placed into a table, the SELECT expression is used in place of what?

The VALUES clause

The value expression

The column name list

The table name

  1. Question 272 Points

In an INSERT statement, the column name list can be omitted if you are doing what?

Adding only a NULL value

Adding only a default value

Adding data only to the primary key column

Supplying a value for every column in the table

  1. Question 282 Points

Which clause is used to limit the rows deleted in the DELETE statement?





  1. Question 292 Points

What would keep the DELETE statement without the WHERE clause from deleting all the rows in a table?

System logs

Referential integrity constraints


  1. Question 302 Points

What is a possible method for ensuring that the correct rows are deleted from the database before the DELETE statement is run?

Using transactions

Creating a SELECT statement and then transferring the WHERE clause to the DELETE statement

Using system logs

  1. Question 3110 Points

We are planning our 1st Quarter marketing budget and need you to provide some historical sales data from the SalesOrdersModify database. Provide summarized data regarding the orders we received during the 1st quarter of 2018 (Jan.-Mar.) broken out by customer city and state. Include customer city and state names along with the count of all orders, the average order total, smallest and largest order totals and the sum of all orders from that city and state. Arrange them by state and then city. Please make sure the average is formatted with two digits after the decimal place. (20 rows)

  1. Question 3210 Points

We are planning a postcard mailing to promote our performers who play Show Tunes or Standards. Using the EntertainmentAgencyModify database, list the full name and mailing address for all customers who did not book any performers in 2018 who play Show Tunes or Standards so that we can include them in the mailing. (Hint: create a subquery to list all customers who DID book performers who play those musical styles and then test for NULL to see which customers are not in that list) You must use the names of the musical styles, not the styleID numbers. (7 rows)

  1. Question 3310 Points

Our EntertainmentAgencyModify database is encountering performance issues because of its size. Archive all Engagements that both started and ended prior to March 1, 2018 into the Engagements_Archive table. After archiving the old Engagements, remove them from the original Engagements table to reduce the size of that table. Remember to use transactions for each of these two queries to protect your data. (45 rows)

(Note: Refer to the schema in Question 32 for relationships.)

  1. Question 3410 Points

We are looking for customer endorsements of the performer “Modern Dance”. Provide a list of names and phone numbers for any customers in the EntertainmentAgencyModify database who have ever booked this performer. Remember that some of these engagements may now be archived. Put the list of customers in alphabetical order by last name and first name. (Hint: use a SQL command that will allow you to combine the results of two similar queries, one for Engagements and one for Engagements_Archive, into a single result set.) (8 rows)

(Note: Refer to the schema in Question 32 for relationships.)

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with My Study Writers
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Very fast response and did a excellent job.
Customer 453201, May 31st, 2022
thank you so much
Customer 452749, June 10th, 2021
It was gotten well after time I needed to make needed additions, but it is something that did help me. I could not get the concept of ho to start such a project but now reading this, I was over thinking the project it seems.
Customer 452801, July 19th, 2021
Classic English Literature
It was my first time using such a service. Essay was good and nicely formatted.
Customer 452441, February 16th, 2022
Customer 453057, May 23rd, 2022
Looks great and appreciate the help.
Customer 452675, April 26th, 2021
Human Resources Management (HRM)
On time and as always a great service! This semester has been very time consuming a tough for my family so this service has not only been a life saver but helped me keep up my grades! If you are in a time crunch or need help, don't hesitate! They are worth it!
Customer 453077, April 4th, 2022
Thank you , Excellent work
Customer 453201, June 2nd, 2022
Thank you
Customer 453087, March 5th, 2022
Impressive writing
Customer 452547, February 6th, 2021
I am beyond eager to write this review for this writer. I received a grade of "Mastered"upon first submission on this assignment. I will shout to the rooftops ENCOURAGING you to hire him. I have used other writers but NONE have delivered such awesome work as this writer and NONE of their prices can compare to his. He does not try to "break the bank" and he works hard; it shows in the final paper and the grade. He is simply,THE BEST HERE!!
Customer 452995, November 16th, 2021
Business Studies
Customer 452985, November 11th, 2021
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp