Design a multidatabase query plan and a set of SQL statements that implement the query of the previous exercise.

What will be an ideal response?


1. At site A, perform a SELECT statement on the database at site C that returns the SSnum and Age of all employees for which Title = ‘Manager’. Since there are
50 managers, the total amount of information returned is 50 ? (9 + 6) or 750 bytes
2. At site A, perform a SELECT on the database at site B that returns the entire
EMP21 database. The total amount of information returned is 10000 ? 30 or 3
megabytes.
3. At site A, perform the join of the two tables from steps 1 and 2, and select those names whose salary is greater than their age.

Computer Science & Information Technology

You might also like to view...

The ____ property should be tested to ensure that a masked textbox contains characters for the entire mask area.

A. MaskRange B. MaskFull C. MaskComplete D. CompleteMask

Computer Science & Information Technology

Answer the following statement(s) true (T) or false (F)

1. A data collector is a resource for storing data such as a spreadsheet while a data container is a mechanism to obtain data from a data source. 2. A risk score for a likelihood of 1 and an impact of 5 is 1/5. 3. An information security risk assessment project sponsor can be your immediate boss. 4. When the control has been implemented and data sheets about the control are available, we call the control a repeatable control of scale of 2. 5. Asset scoping expands the size of the asset survey profile.

Computer Science & Information Technology

What does the acronym TCP represent?

A. Transfer Control Protocol B. Transmission Control Protocol C. Transfer Congestion Protocol D. The Control Protocol

Computer Science & Information Technology

Which of the following diagnostic commands relies on proper forwarding of ICMP ECHO packets?

A. ifconfig B. ping C. route D. nbtstat

Computer Science & Information Technology