IBM DB2 11.1 DBA for LUW (C2090-600) - IBM Actual Exam Questions
Last updated on April 25, 2026
You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?
LOAD
INGEST
IMPORT
TRANSPORT
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?
Set the DB2COMM registry variable to DB2COMM=SSL
Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP
Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT
Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
The routine cannot contain comments.
The routine must return either an integer or a null.
The routine must be cross-compatible with Oracle PL/SQL syntax rules.
The routine cannot contain argument lists or variable arguments (varargs).
The routine must be generated with IBM Database Conversion Workbench (DCW).
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?
db2val
db2set
db2look
db2greg
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?
db2cluster -verify
db2cluster -cm -list -alert
db2cluster -verify -configuration
db2cluster -cm -verify -resource
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.