Want to pass your IBM PureData System for Transactions Technical Mastery Test v1 P2090-047 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
A. Use a CURSOR.
B. Use an EXTERNAL table.
C. Use the COPY command.
D. Increase the PreFetch Count.
What function can nzbackup perform?
A. Back up pg.log files.
B. Back up TEMP tables.
C. Back up host data (catalog metadata).
D. Back up the data using the specified number of streams.
You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?
A. Delete from PROD..TableA
B. Select * from PROD..TableA
C. Truncate table PROD..TableA
D. Insert into PROD..TableA select * from DEV..TableB