IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
1. A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
A) Perform the equivalent of RUNSTATS on ORA1 in Oracle; then perform RUNSTATS on the ORA1 nickname.
B) Perform the equivalent of RUNSTATS on ORA1 in Oracle.
C) Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.
D) Perform RUNSTATS on the ORA1 nickname at the federated server.
2. How can you change an existing non-partitioned index for a partitioned table to a partitioned index?
A) Use the ALTER INDEX and REORG INDEX commands.
B) Use the REORG INDEX command.
C) Use the DROP INDEX and CREATE INDEX commands.
D) Use the ALTER INDEX command.
3. If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?
A) Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
B) Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
C) Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
D) Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
4. If LOGSECOND=-1 then which of the following statements is true?
A) You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.
B) An infinite number of overflow log files will be used with archival logging.
C) You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.
D) The database will reserve active log space for transactions that may need to roll back and write log records.
5. Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY
A) Any time after 11:02:03 am
B) Any time before 11:07:03 am
C) Any time after 11:07:04 am
D) Any time after 11:07:03 am
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: C | Question # 3 Answer: A | Question # 4 Answer: C | Question # 5 Answer: B |
1407 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
