Computers and Technology, 07.03.2020 02:34 jamarengle2
The DDBMS Scenario
Specify the minimum type(s) of operation(s) the database must support (remote request, remote transaction, distributed transaction, or distributed request) in order to perform the following operations: To answer the following questions, remember that the key to each answer is in the number of different data processors that are accessed by each request/transaction. First, identify how many different DP sites are to be accessed by the transaction/request. Next, remember that a distributed request is necessary if a single SQL statement is to access more than one DP site.
Use the following summary:
Operation
Number of DPs
1
>1
Request
Remote
Distributed
Transaction
Remote
Distributed
At site C:
a. SELECT * FROM PRODUCT;
b. SELECT * FROM INVOICE WHERE INV_TOTAL < 2000;
c. SELECT * FROM PRODUCT WHERE PROD_QOH < 25;
d. BEGIN WORK;
UPDATE CUSTOMER
SET CUS_BALANCE = CUS_BALANCE + 200
WHERE CUS_NUM='12934';
INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL)
VALUES ('867541', '14678',
Answers: 1
Computers and Technology, 23.06.2019 00:30, haileesprague575
Quic which one of the following is the most accurate definition of technology? a electronic tools that improve functionality b electronic tools that provide entertainment or practical value c any type of tool that serves a practical function d any type of tool that enhances communication
Answers: 1
Computers and Technology, 23.06.2019 03:30, natalie2sheffield
Hashtags serve to identify the topic of a given tweet true false
Answers: 2
Computers and Technology, 23.06.2019 12:10, jefersina16
2. fabulously fit offers memberships for$35 per month plus a $50 enrollmentfee. the fitness studio offersmemberships for $40 per month plus a$35 enrollment fee. in how many monthswill the fitness clubs cost the same? what will the cost be?
Answers: 1
Computers and Technology, 24.06.2019 13:50, Estefaniamarilicolin
What does code do? a creates a text box that says "solid black" b creates a black border of any width c creates a black border 1 pixel wide
Answers: 1
The DDBMS Scenario
Specify the minimum type(s) of operation(s) the database must suppor...
Specify the minimum type(s) of operation(s) the database must suppor...
Mathematics, 05.03.2021 04:00
English, 05.03.2021 04:00
Mathematics, 05.03.2021 04:00
Physics, 05.03.2021 04:00