Answered

The following code would include _______.
SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;
Select one:
a. only rows that don't match both Customer_T and Order_T Tables.
b. all rows of the Order_T Table regardless of matches with the Customer_T Table.
c. all rows of the Customer_T Table regardless of matches with the Order_T Table.
d. only rows that match both Customer_T and Order_T Tables.

Answer :

Answer:

Option d is the correct answer for the above question

Explanation:

  • The above question asked about the result of the above question code, which has the query of two tables and their primary key is matched in the where class.
  • The Customer_T table has a primary key "CustomerID" and the Order_T has a foreign key "Customer_ID" and that both are matched in the where clause.
  • So the above query fetches that result in which the records match both the table. Hence Option d is the correct answer for the above question while the other is not because another option is not to get by the result of the above query.

Other Questions