IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 1

Question - 15 Maximum mark : - 28

Home
All Exams
IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Online Practice Exams
IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 1

Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?

Set ALTERNATER SERVER to fixed IP Addresses on both servers. ✘ Use a virtual IP Address for both servers. ✘ Use a virtual IP Address in the CATALOG DATABASE command. ✘ Catalog both servers separately and use a fixed IP address for both servers. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which conditions must be met to implement HADR?

Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit). ✘ Operating systems on primary and standby servers need not be the same; DB2 versions must be the same;and the databases need not have the same bit-size (32 or 64 bit). ✘ Operating systems on primary and standby servers must be the same; DB2 versions must be the same;and the databases need not have the same bit-size (32 or 64 bit). ✘ Operating systems on primary and standby servers must be the same; DB2 versions must be the same;and the databases must have the same bit-size (32 or 64 bit). ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS ✘ BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS ✘ BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS ✘ BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

Issue a RESTORE DATABASE command with the REDIRECT option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option; ✘ Issue a RESTORE DATABASE command with the REDIRECT option;issue a RESTORE DATABASEcommand with the CONTINUE option; ✘ Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a RESTORE DATABASEcommand with the CONTINUE option; ✘ Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a SET TABLESPACECONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option; ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

IMPORT ✘ INSPECT ✘ LOAD ✘ RUNSTATS ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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 RECOVER DATABASE command must be issued with the RESTART option specified. ✘ The RECOVER DATABASE operation must be terminated and a new RECOVER DATABASE commandmust be issued. ✘ A RECOVER DATABASE command must be issued with the TO END OF LOGS option specified. ✘ A RECOVER DATABASE command must be re-issued with the REPLACE option specified. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

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. ✘ The log buffers were written to the DB2 log files on the primary server and received in the log buffers on thestandby database. The return code was then sent to the application. ✘ The log buffers were written to the DB2 log files on the standby server and held in memory on the primaryserver. The return code was then sent to the application. ✘ The log buffers were written to the DB2 log files on the primary server and sent to TCP/IP send buffer to beshipped to the standby server. The return code was then sent to the application. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

SET ✘ TREE ✘ ARRAY ✘ ORDER ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

Stop automatically. ✘ Generate an error stating that the audit facility should be stopped prior to stopping the instance. ✘ Remain active. ✘ Write an error message to the audit log and stop automatically. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?

Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication

is not available. ✘ Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authenticationis not available. ✘ Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAPconnection. ✘ Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner