Top Posters
Since Sunday
22
21
20
17
16
15
15
14
14
14
14
14
New Topic  
wrote...
Posts: 106
2 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 11 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 99
Rep: 7 0
2 months ago
Sign in or Sign up in seconds to unlock everything.
All values of CustomerNumber that violate the constraint.
1
Related Topics
wrote...
2 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
  335 People Browsing
 114 Signed Up Today
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 151

Related Images
 79
 58
 74