For each of the following SQL statement, refer to the above DDBMS scenario and s
ID: 3775988 • Letter: F
Question
For each of the following SQL statement, refer to the above DDBMS scenario and specify the type of operation it is (remote request, remote transaction, distributed transaction, or distributed request).
At Location A: a. BEGIN WORK;
INSERT PRODUCT(PROD_CODE, PROD_NAME, PROD_QOH)
VALUES ('1265','Drill Bit', 30);
COMMIT WORK;
b. SELECT INV_TOTAL
FROM INVOICE
WHERE INV_TOTAL > 500;
c. SELECT * FROM PRODUCT
WHERE PROD_QOH > 20;
At Location B:
d. BEGIN WORK;
INSERT CUSTOMER(CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_BAL)
VALUES ('12345','Miss Prince', '3155 Heaven ave', 5.99);
COMMIT WORK;
e. SELECT CUS_NAME, INV_TOTAL
FROM CUSTOMER, INVOICE WHERE INV_TOTAL < 2000 AND CUSTOMER.CUS_NUM = INVOICE.CUS_NUM;
f. BEGIN WORK;
UPDATE PRODUCT SET PROD_QOH = PROD_QOH - 10
WHERE PROD_CODE ='1300';
COMMIT WORK;
TABLES FRAGMENTS CUSTOMER NA PRODUCT PROD A PROD B NA INVOICE INV LINE NIA CUSTOMER LOCATION Site C PROD BExplanation / Answer
Here is the list showing type of operation:
a. Distributed Transaction
b. Remote Request
c. Distributed Request
d. Remote Transaction
e. Distributed Request
f. Distributed Transaction
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.