A2090-545.pdf - IBM A2090-545 Assessment DB2 9.7 SQL Procedure Developer Assessment http\/killexams.com\/exam-detail\/A2090-545 Answer C QUESTION 108 Click

A2090-545.pdf - IBM A2090-545 Assessment DB2 9.7 SQL...

This preview shows page 1 - 4 out of 6 pages.

A2090-545 IBM Assessment: DB2 9.7 SQL Procedure Developer Assessment
Image of page 1
Answer: C QUESTION: 108 Click the Exhibit button. How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?
Image of page 2
A. 0 B. 4 C. 5 D. 7 Answer: B QUESTION: 109 Which of the following can be used to assign multiple values to a row data type variable? A. A SELECT * statement, a VALUES * statement, or a FETCH * statement. B. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement. C. A DIRECT ASSIGNMENT statement. D. D. A VARIABLE VALUES statement. Answer: B QUESTION: 110 Which two statements describe a CASE statement? (Choose two.) A. CASE statements are used to enter into some logic based on a literal value. B. CASE statements are used to enter into some logicbased on the value of an expression. C. CASE statements are used to return control to the beginning of an expression. D. CASE statements are used to enter into some condition and loop until the condition is met.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '20
  • Control flow, developer, D. D. A VARIABLE

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture