최신IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545무료샘플문제
문제1
Given the two SQL procedures shown below:
What is the expected output if procedure S1 is invoked with the value 1 provided for parameter V1?
Given the two SQL procedures shown below:
What is the expected output if procedure S1 is invoked with the value 1 provided for parameter V1?
정답: C
문제2
Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?
Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?
정답: C
문제3
For which types of servers can you use IBM Data Studio to create and manage SQL procedures?
For which types of servers can you use IBM Data Studio to create and manage SQL procedures?
정답: B
문제4
Given the following code
What would be value of parm2 if the following proc1 called as call proc1(3, ?)?
Given the following code
What would be value of parm2 if the following proc1 called as call proc1(3, ?)?
정답: B
문제5
Which three optional clauses can be used when creating an external function? (Choose three.)
Which three optional clauses can be used when creating an external function? (Choose three.)
정답: A,B,C
문제6
What is correct use of the MODULE?
What is correct use of the MODULE?
정답: B
문제7
Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?
Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?
정답: D
문제8
Given the statement shown below:
What happens to NEWPROD if 'http://posample.org/product.xsd' is dropped?
Given the statement shown below:
What happens to NEWPROD if 'http://posample.org/product.xsd' is dropped?
정답: C
문제9
Which two statements are true? (Choose two.)
Which two statements are true? (Choose two.)
정답: B,D