Top Posters
Since Sunday
37
14
10
9
8
8
7
7
7
7
6
6
New Topic  
wrote...
Posts: 188
5 months ago
You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity constraint:

SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber

You run the following SQL query:

SELECTCustomerNumber
FROMSALE
WHERECustomerNumber NOT IN
(SELECTCustomerNumber
FROMCUSTOMER);

What is shown in the results of this query?

• All values of CustomerNumber that match the constraint.

• All values of CustomerNumber that violate the constraint.

• All values of CustomerNumber where
SALE.CustomerNumber = CUSTOMER.CustomerNumber.

• All values of Customer number that are in CUSTOMER but not in SALE.
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 22 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 192
Rep: 8 0
5 months ago
Sign in or Sign up in seconds to unlock everything.
All values of CustomerNumber that violate the constraint.
1
Related Topics
wrote...
5 months ago
Exactly what I needed for my project, TYSM
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  194 People Browsing
Related Images
 100
 79

▶️ Video: Stress and Immune System Animation

For a complete list of videos, visit our video library