000-541 by IBM Valid Free Exam Practice Test

Question 1

A table named CUSTOMER has an XML column named CUSTINFO that contains several XML documents. Which SQL statement will retrieve XML documents from the CUSTOMER table and convert them to character strings?

A. SELECTXMLCAST(custinfo AS VARCHAR(350)) FROM customer B. SELECTXMLTEXT(custinfo AS VARCHAR(350)) FROM customer C. SELECT XM LS E RIALIZE (c usti nf o AS VARCHAR(350)) FROM customer D. SELECT XM LP AR S E (c usti nf o AS VARCHAR(350)) FROM customer

Correct Answer: C

Question 2

You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use?

A. GRANT USE AND GRANT FOR plans TABLESPACE TO bob B. GRANT USE OF plans TABLESPACE TO bob WITH GRANT OPTION C. GRANT USE OF TABLESPACE plans TO bob WITH GRANT OPTION D. GRANT USE AND GRANT FOR TABLESPACE plans TO bob

Correct Answer: C

Question 3

Click the Exhibit button
Given the INSERT statements shown below:
INSERT INTO applicant VALUES (1 ,'M' 54); INSERT INTO applicant VALUES (2, 'F', 38); INSERT INTO applicant VALUES (3, 'M', 21); INSERT INTO applicant VALUES (4, 'F', 91); INSERT INTO applicant VALUES (5, 'C', 50); INSERT INTO applicant VALUES (6, 'C', 70); INSERT INTO applicant VALUES (7, 'C', 95);
How many rows will be successfully inserted?

A. 3 B. 5 C. 7 D. 1

Correct Answer: B

Question 4

Click the Exhibit button

Refer to the logging configuration parameters shown in the exhibit.
If there are currently 100 active log files and there is an error with archiving log file 1. What will happen when DB2 attempts to create log file 101?

A. The database will appear hung because the active log space will be full and BLK_LOG_DSK_FUL is set to YES. Once log file 1 is archived, DB2 will begin normal processing. B. DB2 will attempt to archive log file 1 to the regular archive location up to five times. If log archival still fails after the fifth attempt, the application will receive a "log full" error and at least one transaction will be rolled back. C. DB2 will continue normal processing. It will create log file 101 while attempting to archive log file 1 up to five times. If the fifth attempt to archive log file 1 to the regular archive location fails, it will be placed in the FAILARCHPATH location until the regular archive location becomes available. D. The transaction that prompts DB2 to try and create log file 101 receives a "log full" error and is rolled back because the active log space is full. Since the physical log path is not full, the BLK_LOG_DSK_FUL parameter does not take effect, so the database does not appear hung.

Correct Answer: C

Question 5

Which three authorizations allow you to execute db2pd? (Choose three.)

A. SYSMON authority level B. SYSCTRL authority level C. SYSADM authority level D. SYSPERF authority level E. SECADM authority level

Correct Answer: A,B,C

Question 6

You are asked to create a new database called PRODDB where no privileges will be automatically granted to PUBLIC Which CREATE statement will accomplish this?

A. CREATE DATABASEproddb RESTRICTIVE B. CREATE DATABASEproddb SECURE C. CREATE DATABASEproddb REVOKE ALL FROM PUBLIC D. CREATE DATABASEproddb GRANT PUBLIC NO

Correct Answer: A

Question 7

What are three system and database level authorizations available with DB2? (Choose three.)

A. DBADM B. SYSMNT C. SYS ADM D. SYSMON E. DBCTRL

Correct Answer: A,C,D

IBM DB2 9.7 DBA for Linux UNIX and Windows - 000-541 Exam Practice Test