You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?
A. Assign the value ON to the DB2_HADR_ROS registry variable.
B. Assign the value ON to the DB2_HADR_SNAP registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?
A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the droppedtable.
B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.
C. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE option to restore the
database and recover the dropped table.
D. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.
In IBM Data Studio, where can you schedule script-based jobs?
A. Job Console
B. Job Manager
C. Task Manager
D. Utilities Console
Which of the following table types is NOT supported by the load utility?
A. A Temporal table
B. A Range Partitioned table
C. A Global Temporary table
D. A Multidimensional Clustering table
If the following statement is executed:
What indexes will be created for table TAB1?
A. 1 dimension-block index and 1 composite-block index
B. 1 dimension-block index and 3 composite-block indexes
C. 3 dimension-block indexes and 1 composite-block index
D. 3 dimension-block indexes and 3 composite-block indexes
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.
Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)
A. CLIENT
B. SERVER
C. LDAP_PLUGIN
D. DATA_ENCRYPT
E. KERBEROS_PLUGIN
Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?
A. db2pd
B. db2diag
C. db2trace
D. db2fmtdiag
If the following command is executed: CREATE DATABASE sample RESTRICTIVE Which statement is true?
A. No authorities or privileges will be granted to PUBLIC.
B. Only the creator is allowed to access the SAMPLE database.
C. PUBLIC will hold only SELECT privilege on the system catalog views.
D. The RESTRICT_ACCESS database configuration parameter must be set to YES by the creator.
Which statement about referential constraints is true?
A. A referential constraint can be defined against a catalog table.
B. A referential constraint can be defined on both tables and views.
C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.
D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.
