IBM
C2090-320 · Question #75
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE…
The correct answer is B. CONNECT TO MYREMOTE. See the full explanation below for the reasoning.
Question
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?
Options
- ASELECT * FROM MYUSER.EMP;
- BCONNECT TO MYREMOTE;
- CSELECT * FROM MYUSER.MYREMOTE.EMP;
- DCREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP; SELECT * FROM
How the community answered
(27 responses)- A4% (1)
- B81% (22)
- C4% (1)
- D11% (3)
Community Discussion
No community discussion yet for this question.