IBM DB2 9.7 DBA for Linux UNIX and Windows - 000-541 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Click the Exhibit button.

IBM 000-541: Practice Exam
What is the result after executing the SELECT statement shown below?
SELECT COUNTO FROM applicant WHERE gender='C'

A. 3 B. 7 C. 0 D. 4

Discussion 0

Correct Answer: C Vote an answer

Question 2

A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

A. SYSPROC.DB2SECURITYU\BEL B. SYSPROC.DB2LBACU\BEL C. SYSIBM.DB2SECURITYLABEL D. SYSIBM.DB2LBACLABEL

Discussion 0

Correct Answer: C Vote an answer

Question 3

Click the Exhibit button.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active log files, what will happen if there are currently 100 active log files and DB2 needs to create active log file 101?

A. The database will appear to be hung because the BLK_LOG_DSK_FUL configuration parameter is set to YES. Once some active log files arearchived,the database will resume normal operation. B. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log path is full. The transaction will be rolled back andit's associated application will be forced off. C. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log space and active log path are both full. The transaction will be rolled back andit's associated application will be forced off. D. The database will continue normal operation because infinite logging has been enabled and any logs that will not fit in the active log path will automatically be created within the OVERFLOWLOGPATH until logs in the active log path begin to be archived.

Discussion 0

Correct Answer: A Vote an answer

Question 4

Click the Exhibit button.

What does the SQL in the exhibit show?

A. THE SQL shows indexes on SYSIBM.SYSINDEXES table that have not been used since the last database activation. B. The SQL shows the most frequently used indexes on the SYSIBM.SYSINDEXES table since the last database activation C. The SQL shows the most frequently used indexes on the SYSIBM.SYSTABLES table since the last database activation. D. The SQL shows indexes on the SYSIBM.SYSTABLES table that are used for index-only access.

Discussion 0

Correct Answer: C Vote an answer

Question 5

You are running an IMPORT utility and have specified the option COMMITCOUNT AUTOMATIC Which two reasons will cause the IMPORT utility to COMMIT? (Choose two.)

A. to avoid lock escalation from row level to table level B. to avoid writing uncommitted data back to the database to make room in the buffer pool C. to avoid allocation of secondary log files D. to avoid running out of active log space

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

Which statement is correct about using the TAKEOVER HADR command?

A. The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the standby database is in local catchup state. B. The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the databases are in peer state. C. The TAKEOVER HADR command can only be issued on the primary database and the primary database is connected to the standby database when the command is issued. D. The TAKEOVER HADR command can only be issued on the standby database and the primary database is not connected to the standby database when the command is issued.

Discussion 0

Correct Answer: B Vote an answer