Exam Code: C2090-611 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10.1 DBA for Linux, UNIX, and Windows
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-611 Exam.
2021 May C2090-611 Study Guide Questions:
Q41. Which statement is true regarding client-server database connectivity?
A. A remote connection uses Interprocess Communication (IPC).
B. A loopback connection can be made with either the APPC or TCP/IP protocol enabled.
C. A remote connection is established between a DB2 client in a different location from the database server.
D. A DB2 client running a lower version of DB2 can establish a local connection to a server running on a newer version.
Answer: C
Q42. Which DB2 product/feature should be used if you want to enable client reroute for transactions and connections based on workload?
A. pureScale
B. Advanced Server Edition
C. Data Partitioning Feature
D. Enterprise Server Edition
Answer: A
Q43. What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?
A. Permission to log in to the database client using telnet.
B. Permission to log in to the database server using telnet.
C. Permission to log in to the database client using secure shell (SSH).
D. Permission to log in to the database server using secure shell (SSH).
Answer: D
Replace C2090-611 download:
Q44. Which registry variable is used to enable transparent Lightweight Directory Access Protocol
(LDAP)?
A. DB2LDAP
B. DB2AUTH
C. CLNT_PW_PLUGIN
D. SRVCON_PW_PLUGIN
Answer: B
Q45. What is the MAX_LOG database configuration parameter used for?
A. To limit how many log files a single transaction can span.
B. To limit the percentage of primary log space a running transaction can consume.
C. To limit the total number of primary and secondary log files a database can consume.
D. To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.
Answer: B
Q46. Which statement about the REORGCHK command is true?
A. It cannot be run against the system catalog.
B. It automatically calls RUNSTATS by default.
C. It cannot be run against multidimensional clustering tables.
D. It automatically calls REORG if it is determined that a reorg is necessary.
Answer: B
Breathing C2090-611 discount pack:
Q47. What authority is required to grant a user ACCESSCTRL authority?
A. DBADM
B. SQLADM
C. SECADM
D. DATAACCESS
Answer: C
Q48. Which statement about Binary XML is FALSE?
A. Binary XML format is only used for data transmission.
B. Binary XML data refers to data that is in the XDBX format.
C. Only textual XML data format is supported by Binary XML.
D. The binary format provides a faster way to transmit and receive XML data.
Answer: C
Q49. What does the FLUSH PACKAGE CACHE statement do?
A. It removes all dynamic SQL statements from the package cache.
B. It removes only inactive SQL statements from the package cache.
C. It saves dynamic SQL stored in the package cache to an external file.
D. It causes all SQL statements in the package cache that are currently in use to be recompiled.
Answer: A
Q50. A user with SYSADM authority executes the following commands at host SERVER1:
Assuming the user ADMINISTRATOR exists, what could be causing the problem?
A. The password for user ADMINISTRATOR is missing.
B. The userid should not be longer than eight characters.
C. The syntax of the CATALOG NODE command must contain a valid TCP/IP address.
D. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.
Answer: D