最新的IBM 000-545免費考試真題

問題1

Which tool can be used to get quick static SQL Explain data from packages?

A. db2exfmt

B. Control Center

C. DB2 command center

D. db2expln

正確答案: D

問題2

Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?

A. db2exfmt

B. Data Studio

C. db2look

D. DB2 Command Center

正確答案: A

問題3

Click the Exhibit button.

If the procedure TEST1 shown in the exhibit is called with the value 'A00' specified for the SOMEID parameter, what is the expected return code?

A. -3

B. -1

C. 0

D. -2

正確答案: C

問題4

Which two statements are true? (Choose two.)

A. SQL procedures can contain static and/or dynamic SQL statements.

B. Static or dynamic SQL execution is not associated with a package.

C. SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.

D. The SQL procedure is always associated with a package that contains access paths of SQL statements in the procedure.

E. It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.

正確答案: A,D

問題5

Click the Exhibit button.

A user-defined function was created using the statement shown in the exhibit. Which additional option can be added to the CREATE FUNCTION statement to tell the optimizer that the function does not always return the same results for a given argument value?

A. NO EXTERNAL ACTION

B. NOT FENCED

C. STATIC DISPATCH

D. NOT DETERMINISTIC

正確答案: D

問題6

Which object is used to return a result set from an SQL procedure?

A. Cursor

B. Temporary table

C. Scratchpad

D. Array

正確答案: A

問題7

In the function shown below:

Which statement can be used to invoke the function above?

A. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1

B. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1

C. SELECT * FROM TABLE(fcn1('B01'))

D. SELECT * FROM fcn1('B01')

正確答案: C

最新的IBM DB2 9.7 SQL Procedure Developer - 000-545免費考試真題

聯系我們

站內鏈接

最新更新