최신 IBM Specialist A2090-545 무료샘플문제:
1. 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 removed from the data development project.
B) The SQL procedure is dropped from the database.
C) The SQL procedure is dropped from the database and removed from the data development project.
D) The SQL procedure is temporarily hidden in the Data Source Explorer view.
2. Which statement can be used to define variable that can be shared between procedures?
A) DEFINE GLOBAL VARIABLE my_gl_var INTEGER
B) DECLARE my_gl_var INTEGER DEFAULT 1
C) CREATE GLOBAL VARIABLE my_gl_var
D) CREATE OR REPLACE VARIABLE my_gl_var INTEGER
3. Which of the following statements is true?
A) Values cannot be assigned to variables inside ERROR HANDLERS.
B) The result of a GET DIAGNOSTICS statement cannot be assigned to a variable.
C) A DATETIME value can be assigned to a DATE variable.
D) A TIMESTAMP value can be assigned to a TIME variable.
4. Click on the Exhibit button.
Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure
is invoked by the call statement shown below?
CALL find_customers(ARRAY[?16-305-3745?
?05-416-4565?
?16-305-3746?
'905-414-4566'],
?16??)
A) [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?
B) [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']
C) [?05-416-4565? '905-414-4566']
D) [?16-305-3745??05-416-4565? ?16-305-3746']
5. Which two DB2 commands can be performed using the ADMIN_CMD procedure? (Choose two.)
A) RECOVER
B) CREATE DATABASE
C) RUNSTATS
D) RESTORE
E) BACKUP
질문과 대답:
질문 # 1 정답: B | 질문 # 2 정답: D | 질문 # 3 정답: D | 질문 # 4 정답: A | 질문 # 5 정답: C,E |