IBM IBM Certified Advanced Database Administrator A2090-544 Questions & Answers

• Question 71:

  Which method should be used to construct an LBAC security component that represents a person's level of trust?

  A. SET

  B. TREE

  C. ARRAY

  D. ORDER

  Correct Answer: C

• Question 72:

  What will the db2audit facility do when a DB2 database instance is stopped?

  A. Stop automatically.

  B. Generate an error stating that the audit facility should be stopped prior to stopping the instance.

  C. Remain active.

  D. Write an error message to the audit log and stop automatically.

  Correct Answer: C

• Question 73:

  What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

  A. SECADM authority

  B. EXECUTE privilege on audit routines with DATA

  C. DBADM authority

  D. EXECUTE privilege on audit routines with NO DATA

  E. SYSADM authority

  Correct Answer: AB

• Question 74:

  A primary and standby database are enabled for HADR and are in peer state. The HADR_SYNCMODE configuration parameter is set to SYNC. An application connects to the primary database, issues a COMMIT and receives a successful return code in response. How were the log buffers for this unit of work processed?

  A. The log buffers were written to the DB2 log files on the primary server, sent to the standby, and written to log files on the standby server. The return code was then sent to the application.

  B. The log buffers were written to the DB2 log files on the primary server and received in the log buffers on the standby database. The return code was then sent to the application.

  C. The log buffers were written to the DB2 log files on the standby server and held in memory on the primary server. The return code was then sent to the application.

  D. The log buffers were written to the DB2 log files on the primary server and sent to TCP/IP send buffer to be shipped to the standby server. The return code was then sent to the application.

  Correct Answer: A

• Question 75:

  Which tool or command will display only the automatic storage paths in an existing backup image?

  A. db2dart

  B. db2ckbkp

  C. INSPECT

  D. db2pd

  Correct Answer: B

• Question 76:

  If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

  A. db2dart

  B. db2apptrk

  C. db2acsutil

  D. db2pd

  Correct Answer: D

• Question 77:

  A database recovery operation (RECOVER DATABASE) failed during the roll forward phase. The DBA wants to force the RECOVER DATABASE to redo the restore phase. What must occur to accomplish this?

  A. A RECOVER DATABASE command must be issued with the RESTART option specified.

  B. The RECOVER DATABASE operation must be terminated and a new RECOVER DATABASE command must be issued.

  C. A RECOVER DATABASE command must be issued with the TO END OF LOGS option specified.

  D. A RECOVER DATABASE command must be re-issued with the REPLACE option specified.

  Correct Answer: A

• Question 78:

  Given the following output from the GET DATABASE CONFIGURATION command:

  

  Which of the following DB configurations listed below will enable circular logging?

  A. LOGRETAIN=CIRCULAR

  B. LOGSECOND=-1

  C. LOGARCHMETH1=OFF and LOGARCHMETH2=OFF

  D. LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF

  Correct Answer: C

• Question 79:

  Which command CANNOT be used to create the compression dictionary for a table?

  A. IMPORT

  B. INSPECT

  C. LOAD

  D. RUNSTATS

  Correct Answer: D

• Question 80:

  What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?

  A. Issue a RESTORE DATABASE command with the REDIRECT option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

  B. Issue a RESTORE DATABASE command with the REDIRECT option;issue a RESTORE DATABASE command with the CONTINUE option;

  C. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a RESTORE DATABASE command with the CONTINUE option;

  D. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

  Correct Answer: A