Exact of C2090-735 braindumps materials and lab for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-735 pdf dumps vce Materials. 100% PASS DB2 9.5 SQL Procedure Developer (C2090-735) exam Today!
2021 May C2090-735 Study Guide Questions:
Q61. Given the function shown below:
CREATE FUNCTION fcn1(v1 VARCHAR(50))
RETURNS VARCHAR(50)
SPECIFIC fcn2
RETURN LTRIM(RTRIM(v1))
Which statement will invoke the function?
A. SELECT * FROM VALUES LENGTH(fcn2(' one good day '))
B. VALUES LENGTH( fcn1(' one good day '))
C. CALL VALUES LENGTH(fcn1(' one good day '))
D. CALL LENGTH(fcn2(' one good day '))
Answer: B
Q62. Which statement will assign the schema names "SYSIBM", "SYSFUN", "SYSPROC", and "SYSIBMADM" to the CURRENT_PATH special register?
A. SET PATH = SYSTEM PATH
B. SET CURRENT_PATH = DEFAULT
C. SET PATH = SYSTEM DEFAULT
D. RESET CURRENT PATH
Answer: A
Improved C2090-735 actual exam:
Q63. Click the Exhibit button.
***MISSING EXHIBIT***
CASE rating WHEN 1 THEN UPDATE employee SET salary = salary * 1.10 WHERE
empno = v_employee_number;
WHEN 2 THEN UPDATE employee SET salary = salary * 1.05 WHERE empno =
v_employee_number;
ELSE UPDATE employee SET salary = salary * 1.03 WHERE empno =
v_employee_number;
END CASE;
Which statement is true about the CASE statement shown in the exhibit?
A. An employee with a rating of 1 receives a 10% salary increase.
B. An employee with a rating of 3 receives no salary increase.
C. An employee with a rating of 2 receives a 3% salary increase.
D. All employees will receive at least a 5% salary increase.
Answer: A
Q64. A table named TABLE1 is populated as shown below:
COL1 COL2
1 test
2 test1
3 test3
The statement shown below is executed.
CREATE PROCEDURE myproc()
BEGIN
DECLARE c1 CURSOR WITH HOLD
FOR SELECT col1, col2 FROM table1;
OPEN c1;
END
How many rows will be returned when the SQL procedure MYPROC is executed?
A. 0
B. 2
C. 3
D. 5
Answer: A
Vivid C2090-735 vce:
Q65. 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. The SQL procedure is always associated with a package that contains access paths ofSQL statements in the procedure.
D. It is necessary for an end-user to have object level privileges if that user has executeprivileges on an associated package and the SQL procedure.
E. SQL procedures can have COMMIT or ROLLBACK within atomic compoundstatements.
Answer: A,C
Q66. Click the Exhibit button.
***MISSING EXHIBIT***
CREATE PROCEDURE sal_increase_lim (empid CHAR(6), new_sal DEC(9,2))
BEGIN
DECLARE years_of_serv INT DEFAULT 0;
SELECT YEAR(CURRENT DATE) - YEAR(hiredate)
INTO years_of_serv
FROM employee
WHERE empno = empid;
CASE
WHEN years_of_serv > 30 THEN
SET gl_sal_increase = 15000;
WHEN years_of_serv > 20 THEN
SET gl_sal_increase = 12000;
WHEN years_of_serv > 10 THEN
SET gl_sal_increase = 10000;
ELSE
SET gl_sal_increase = 5000;
END CASE; UPDATE employee SET salary = new_sal WHERE empno = empid; END
Refer to the procedure shown in the exhibit and the trigger shown below.
CREATE TRIGGER sal_limit BEFORE UPDATE ON employee REFERENCING NEW AS n FOR EACH ROW WHEN (n.salary > (SELECT max_salary FROM salary_limits WHERE job_desc = n.job) + gl_sal_increase) SIGNAL SQLSTATE '78000' SET MESSAGE_TEXT = 'Salary is too big'
If the procedure SAL_INCREASE_LIM is called, which two statements are true? (Choose two.)
A. Global variables are not supported within the trigger.
B. The result of the procedure will depend on the value of MAX_SALARY in the tableSALARY_LIMITS.
C. The result of the procedure will depend on the value for HIREDATE column for theemployee that is being updated.
D. The result of the procedure will depend on the value GL_SAL_INCREASE for theemployee that is being updated.
E. This trigger would not be activated.
Answer: B,C
Q67. A database developer using Data Studio needs to view sample data in a table. Which view should be used?
A. Database Explorer
B. Data Project Explorer
C. Data Output
D. Properties
Answer: A