Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
lbelcher lbelcher
wrote...
Go to Answer
Posts: 482
Rep: 20 0
5 years 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.
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 81 times
2 Replies
Replies
Answer verified by a subject expert
Jacobian S.Jacobian S.
wrote...
#1
Posts: 388
Rep: 53 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

lbelcher Author
wrote...
#2
5 years ago
Exactly what I needed for my project, TYSM
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  987 People Browsing
 160 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 305
  
 291
  
 290
Your Opinion
Do you believe in global warming?
Votes: 370
Previous poll results: Who will win the 2024 president election?