IBM IBM Certified Advanced Database Administrator C2090-611 Questions & Answers

• Question 31:

  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

  Correct Answer: A

• Question 32:

  Which is the suggested way to restore a database with a subset of its original table spaces?

  A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.

  B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.

  C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.

  D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.

  Correct Answer: A

• Question 33:

  Which statement is NOT true about a database restore operation?

  A. A table space restore operation must be done offline.

  B. A table space is not usable until the restore operation completes successfully.

  C. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.

  D. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.

  Correct Answer: A

• Question 34:

  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.

  Correct Answer: A

• Question 35:

  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.

  Correct Answer: D

• Question 36:

  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

  Correct Answer: B

• Question 37:

  What are two types of DB2 Discovery requests that a client can make? (Choose two.)

  A. KNOWN

  B. SEARCH

  C. LOOKUP

  D. TRUSTED

  E. UNTRUSTED

  Correct Answer: AB

• Question 38:

  Which command is used to import connectivity configuration information from a file known as a configuration profile?

  A. db2ca

  B. db2cfexp

  C. db2cfimp

  D. db2cfgimp

  Correct Answer: C

• Question 39:

  Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?

  A. RESTART DATABASE

  B. RESTORE DATABASE

  C. RESTORE TABLESPACE

  D. ROLLFORWARD DATABASE

  Correct Answer: B

• Question 40:

  Which statement is true about Insert Time Clustering (ITC) tables?

  A. An existing MDC table can be converted to an ITC table.

  B. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.

  C. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.

  D. ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.

  Correct Answer: D