If the following SQL statements are executed:
How many rows will be added to the DEPARTMENT table?
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
Where does the DB2 Problem Determination tool (db2pd) get information from?
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
Copyright © 2021-2024 CertsTopics. All Rights Reserved
