When you run a database query to find data in related tables, only records that have matching values on both sides of the relationship are found. Most of the time this result will be adequate, but other times you may want to control which records will be displayed. What kind of query allows you to control the records you see, and how did you use this type of query to help answer the manager's
questions for Jasmine?
What will be an ideal response?
In order to find how many books have been rented and show all the titles, even if there were no contracts associated with them, an outer join query was used. There was one title that had zero rentals that would not have shown up by running a normal query.
You might also like to view...
____ need a different set of acceptable use policies because of their enhanced authority.
A. End-users B. Managers C. Executives D. Administrators
Which of the following is the first packet sent in the TCP three-way handshake?
A. RST B. SYN C. ACK D. PSH
When using the Between comparison operator, Access will add ________ around the date fields to search correctly
A) quotation marks (") B) asterisks (*) C) pound signs (#) D) ampersands (&)
What are the two keys that must be generated if you want to secure a zone with a digital signature? What is the purpose of each?
What will be an ideal response?