Posted by: Pdfprep
Post Date: December 26, 2020
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?
A . SELECT * FROM MYUSE
B . EMP;
C . CONNECT TO MYREMOTE; SELECT * FROM MYUSE
D . EMP;
E . SELECT * FROM MYUSE
F . MYREMOT
G . EMP;
H . CREATE ALIAS EMP_ALIAS FOR LOCATIO
. MYREMOT
. MYUSE
. EMP;
SELECT * FROM MYUSE
. EMP_ALIAS;
Answer: B
Leave a Reply