High quality of C2090-735 download materials and answers for IBM certification for customers, 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:
Q11. Which three optional clauses can be used when creating an external function? (Choose three.)
A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO
Answer: A,C,D
Q12. Given the SQL statement shown below:
CREATE TRIGGER hr.raise_limit
AFTER UPDATE OF salary ON employee
REFERENCING NEW AS n OLD AS o FOR EACH ROW
WHEN (n.salary > 1.1 * o.salary)
SIGNAL SQLSTATE '75000' SET MESSAGE_TEXT='Salary increase>10%'
Which two privileges allow a user to execute the CREATE TRIGGER statement shown?
(Choose two.)
A. DBADM authority
B. SYSCTRL authority
C. SELECT and UPDATE privilege on the EMPLOYEE table
D. SYSMAINT authority
E. SELECT and ALTER privilege on the EMPLOYEE table
Answer: A,C
Q13. An SQL procedure uses the statement shown below to insert a record into a global temporary table named TEMP_TABLE.
INSERT INTO temp_table VALUES (1, 'a')
Which schema name should be used to qualify the temporary table in the INSERT statement?
A. SESSION
B. DB2ADMIN
C. DB2USER
D. SYSIBM
Answer: A
Improve C2090-735 exam cram:
Q14. Which two DB2 commands can be performed using the ADMIN_CMD procedure?
(Choose two.)
A. RUNSTATS
B. BACKUP
C. RESTORE
D. RECOVER
E. CREATE DATABASE
Answer: A,B
Q15. Given the function shown below, what is the output of the statement:
VALUES LENGTH(fcn1(' one good day'))?
CREATE FUNCTION fcn1(v1 VARCHAR(50))
RETURNS VARCHAR(50)
RETURN LTRIM(RTRIM(v1)); A. 'one good day'
B. 12
C. ' one good day '
D. 14
Answer: B
Q16. Click the Exhibit button
***MISSING EXHIBIT***.
Given the following the tables:
EMPLOYEE EMPNO EMPNAME WORKDEPT
1 Ted Smith 100 2 John Doe 200 3 Jane Doe 100 DEPT SALES_ID NAME
100 Shoes 200 Pants
Given the following trigger:
CREATE TRIGGER updt_dept AFTER UPDATE ON dept REFERENCING NEW_TABLE AS newdept OLD_TABLE AS updtdept FOR EACH STATEMENT MODE DB2SQL UPDATE employee SET workdept=(SELECT sales_id FROM newdept) WHERE workdept IN (SELECT sales_id FROM updtdept);
A trigger was created as shown in the exhibit. The UPDATE statement shown below is executed. UPDATE dept SET sales_id = '300' WHERE sales_id = '200' How many row(s) are updated in the EMPLOYEE table?
A. 0
B. 1
C. 2
D. 3
Answer: B
Guaranteed C2090-735 preparation exams:
Q17. Click the Exhibit button.
***MISSING EXHIBIT***
CREATE FUNCTION e_degree(edlevel SMALLINT) RETURNS CHAR(12) LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION BEGIN ATOMIC DECLARE degree CHAR(12); IF edlevel= 12 THEN SET degree = 'HIGH SCHOOL' ELSEIF edlevel = 14 THEN SET degree = 'ASSOCIATE' ELSEIF edlevel = 16 THEN
SET degree = 'BACHELOR'
ELSEIF edlevel = 18 THEN
SET degree = 'MASTER'
ELSEIF edlevel = 20 THEN
SET degree = 'DOCTORATE'
ELSE
SET degree = 'UNKNOWN'
END IF;
RETURN degree;
END
A user-defined function was created using the statement shown in the exhbit. What are two valid ways to invoke this function from the DB2 Command Line Processor? (Choose two.)
A. SELECT lastname, e_degree(edlevel) AS degree FROM employee
B. SELECT * FROM e_degree(SMALLINT(18))
C. VALUES e_degree(18)
D. VALUES e_degree(SMALLINT(18))
E. SELECT * FROM TABLE(e_degree(SMALLINT(18))
Answer: A,D
Q18. There is no row change timestamp column defined on a table. An original row is selected, another row is updated on the same page after the SELECT and before the UPDATE.With Optimistic Locking, what is the result?
A. The row change token predicate succeeds for the selected row because the row changetoken value for all rows on the page has changed except for the original row, so theUPDATE statement succeeds for the original row.
B. The row change token predicate fails because the row change token value for all rowson the page has changed, however the UPDATE statement succeeds since the originalrow has not actually changed.
C. The row change token predicate fails because the row change token value for all rowson the page has changed, so the UPDATE statement fails to find a row even though theoriginal row has not actually changed.
D. The row change token predicate is implicitly updated because the row change tokenvalue for all rows on the page has changed, so the UPDATE statement fails to find a roweven though the original row has not actually changed.
Answer: C
Q19. Which CREATE TRIGGER statement is valid?
A. CREATE TRIGGER test1 NO CASCADE AFTER INSERT ON employee REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL WHEN (n.bonus IS NULL) SET n.salary = n.salary + 2000
B. CREATE TRIGGER test1 NO CASCADE BEFORE INSERT ON employee REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL WHEN (n.bonus IS NULL) SET n.salary = n.salary + 2000
C. CREATE TRIGGER test1 AFTER DELETE ON employee REFERENCING OLD_TABLE AS oldemployee FOR EACH STATEMENT MODE DB2SQL DELETE FROM staff WHERE id IN (SELECT empno FROM oldemployee) D. CREATE TRIGGER test1 NO CASCASE BEFORE DELETE ON employee FOR EACH STATEMENT MODE DB2SQL DELETE FROM staff WHERE id IN (SELECT empno FROM oldemployee)
Answer: B
Q20. Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP
Answer: C