PrepAway - Latest Free Exam Questions & Answers

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the fol

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 MYUSER.EMP;

B. CONNECT TO MYREMOTE;
SELECT * FROM MYUSER.EMP;

C. SELECT * FROM MYUSER.MYREMOTE.EMP;
D. CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP;
SELECT * FROM MYUSER.EMP_ALIAS;


Leave a Reply