PrepAway - Latest Free Exam Questions & Answers

What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?

What functionality allows users to perform a UNION operation between a DB2 table and an
Oracle view?

PrepAway - Latest Free Exam Questions & Answers

A.
Oracle connect

B.
Trusted context

C.
Oracle federation

D.
Distributed request

Explanation:

One Comment on “What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?”

  1. Chow, Kenneth KY says:

    Distributed requests
    A distributed request is a distributed database function that allows applications and users to submit SQL statements that reference two or more DBMSs or databases in a single statement. For example, a join between tables in two different DB2® for z/OS® subsystems. DB2 Connect™ provides support for distributed requests across databases and DBMSs.

    For example, you can perform a UNION operation between a DB2 table and an Oracle view. Supported DBMSs include members of the DB2 Family (such as DB2 for Linux, UNIX, and Windows, DB2 for z/OS, and DB2 for i) and Oracle. Multivendor support is available when using DB2 Connect in conjunction with InfoSphere® Federation Server.




    0



    0

Leave a Reply