Page: 1
/ 11
Total 55 questions
When you right-click a SQL procedure in the Data Source Explorer of IBM Data Studio and select Drop from the options menu, what happens?
- A. The SQL procedure is temporarily hidden in the Data Source Explorer view.
- B. The SQL procedure is removed from the data development project.
- C. The SQL procedure is dropped from the database.
- D. The SQL procedure is dropped from the database and removed from the data development project.
Answer : C
: 45
Click the Exhibit button.
Referring to the exhibit, which two statements are correct? (Choose two.)
- A. If the EMPLOYEE_TEMP table exists, the execution order is 1,2,3.
- B. If the EMPLOYEE_TEMP table does not exist, the execution order is 1,4,3.
- C. If the EMPLOYEE_TEMP table exists, the execution order is 4,1,2,3.
- D. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.
- E. If the messages table does not exist, the SQL procedure will still compile.
Answer : A,B
Which object is used to return a result set from an SQLprocedure?
- A. Temporary table
- B. Array
- C. Cursor
- D. Scratchpad
Answer : C
Given the following procedures:
What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES procedure is called with the value 23 provided as input?
- A. 0
- B. 6B.6
- C. 23C.23
- D. 10D.10
Answer : B
Given the function shown below:
Which statement will execute successfully?
- A. SELECT to_upper('Seize the day!')
- B. SELECT * FROM to_upper_fcn('Seize the day!')
- C. SELECT to_upper('Seize the day!') FROM SYSIBM.SYSDUMMY1;
- D. SELECT * FROM TABLE(to_upper_fcn('Seize the day!')) AS T
Answer : C
31 days access 