Title: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ... Post by: lbelcher on Feb 10, 2019 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:
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. Title: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ... Post by: Jacobian Smith on Feb 10, 2019 Content hidden
Title: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ... Post by: lbelcher on Feb 10, 2019 Exactly what I needed for my project, TYSM
|