READ Free Dumps For IBM- 000-611
| Question ID 19935 | What does the FLUSH PACKAGE CACHE statement do? |
| Option A | It removes all dynamic SQL statements from the package cache. |
| Option B | It removes only inactive SQL statements from the package cache. |
| Option C | It saves dynamic SQL stored in the package cache to an external file. |
| Option D | It causes all SQL statements in the package cache that are currently in use to be recompiled. |
| Correct Answer | A |
| Question ID 19936 | The following commands are executed against a database named MY_DB, which has been configured to
Which statement is true? |
| Option A | Upon completion of the Load, the table T1 is placed into "Backup Pending" state. |
| Option B | Upon completion of the Load, a backup image of table T1 is automatically generated. |
| Option C | After a Restore and Rollforward operation, table T1 would be marked unavailable and can only be |
| Option D | After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 |
| Correct Answer | C |
