Free IBM 000-611 Exam Dumps Questions & Answers

What authority is required to grant a user ACCESSCTRL authority?

• A.SECADM
• B.DATAACCESS
• C.DBADM
• D.SQLADM

What does the FLUSH PACKAGE CACHE statement do?

• A.It removes only inactive SQL statements from the package cache.
• B.It saves dynamic SQL stored in the package cache to an external file.
• C.It removes all dynamic SQL statements from the package cache.
• D.It causes all SQL statements in the package cache that are currently in use to be recompiled.

What authorization is needed to execute the CREATE MASK statement?

• A.SECADM
• B.SYSCTRL
• C.SYSADM
• D.SQLADM

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

• A.To restart a failed INGEST command from the last commit point.
• B.To restart a failed INGEST command from the beginning.
• C.To terminate a failed INGEST command.
• D.To clean up the log records of a failed INGEST command.

Which user-managed file system is required for DB2 pureScale deployments?

• A.NTFS
• B.JFS2
• C.GPFS
• D.HPFS