000-546 by IBM Actual Free Exam Q&As

Question 1

After using the lock event monitor to capture binary lock event data in an unformatted event table, you can convert the data into an XML or text document using which of the following Java-based tools?

A. db2exportevm B. db2fmtevmon C. db2evmonfmt D. db2convertevm

Discussion 0

Correct Answer: C Vote an answer

Question 2

A DB2 9.7 database has been enabled for Oracle compatibility. What is the command to disable all compatibility features?

A. db2set DB2_COMPATIBILITY_VECTOR_ORACLE=OFF B. db2set DB2_COMPATIBILITY_VECTOR= C. db2set DB2_COMPATIBILITY_VECTOR=ORA D. db2set DB2_COMPATIBILITY_VECTOR=DB2

Discussion 0

Correct Answer: B Vote an answer

Question 3

When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?

A. DB2 limits the size of the db2diag.log and <instance>.nfy files to 10 MB, and purges the old records when the limit is reached. B. DB2 rotates through 10 db2diag.log files that are 10 MB in size. C. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files that are 10 MB in size. D. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files and limits the total size of the 20 files to 10 MB.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Which of the following actions can be done through an ALTER INDEX statement?

A. Add a column to the index key. B. Make this index the clustering index. C. Make the COMPRESS attribute YES or NO. D. Change the PCTFREE specification.

Discussion 0

Correct Answer: C Vote an answer

Question 5

User USER1 is a member of the SYSADM group for instance INST1 in DB2 9.7. Database DB_1 was just created within INST1 by user USER2. What additional authorities must be directly granted to USER1 in order for USER1 to retain the same privileges they would have had if database DB_1 had been created with DB2 9.5 by USER2?

A. DBADM, DATAACCESS, ACCESSCTRL B. DBADM, SECADM, ACCESSCTRL C. SECADM, DATAACCESS, ACCESSCTRL D. DBADM, DATAACCESS

Discussion 0

Correct Answer: A Vote an answer

Question 6

You have created a Trusted Context by using following command:

What is the ENCRYPTION type for the '9.26.146.201' address, the AUTHENTICATION type for
PUBLIC, and is MYCTX enabled?

A. None, WITHOUT AUTHENTICATION, Yes B. High, WITH AUTHENTICATION, Yes C. High, WITHOUT AUTHENTICATION, No D. None, WITH AUTHENTICATION, No

Discussion 0

Correct Answer: A Vote an answer

Question 7

How would you set the client information for a particular activity in a database using Workload Manager (WLM)?

A. Use the WLM_SET_CLIENT_INFO table function B. Use the WLM_SET_CLIENT_INFO stored procedure C. Use the WLM_SET_CLIENT_INFO special register D. Use the WLM_SET_CLIENT_INFO audit function

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which function/stored procedure CANNOT be used to view audit facility data?

A. SYSPROC.AUDIT_AUTH B. SYSPROC.AUDIT_DELIM_EXTRACT C. SYSPROC.AUDIT_ARCHIVE D. SYSPROAUDIT_LIST_LOGS

Discussion 0

Correct Answer: A Vote an answer

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - 000-546 Exam Practice Test