See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table:You issue the following query:Which s
Posted: Wed Jun 07, 2023 6:12 am
See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table:You issue the following query:Which statement is true regarding the outcome of this query?
A. It produces an error because the NATURAL join can be used only with two tables
B. It produces an error because a column used in the NATURAL join cannot have a qualifier
C. It produces an error because all columns used in the NATURAL join should have a qualifier
D. It executes successfully
- See The Exhibit 1 (60.39 KiB) Viewed 161 times
- See The Exhibit 2 (42.51 KiB) Viewed 161 times
- See The Exhibit 3 (90.41 KiB) Viewed 161 times
- See The Exhibit 4 (14.43 KiB) Viewed 161 times
B. It produces an error because a column used in the NATURAL join cannot have a qualifier
C. It produces an error because all columns used in the NATURAL join should have a qualifier
D. It executes successfully