C2090-545 試験問題を無料オンラインアクセス

Which SQL procedure declaration is coded correctly?

• A.CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
  BEGIN
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  SET commission = 0;
  DECLARE a DOUBLE;
  DECLARE my_cur CURSOR FOR SELECT * FROM employee;
  SET a = .06 * salary;
  SET commission = a;
  END
• B.CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
  BEGIN
  DECLARE a DOUBLE;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  SET commission = 0;
  DECLARE my_cur CURSOR FOR SELECT * FROM employee;
  SET a = .06 * salary;
  SET commission = a;
  END
• C.CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
  BEGIN
  DECLARE a DOUBLE;
  DECLARE my_cur CURSOR FOR SELECT * FROM employee;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  SET commission = 0;
  SET a = .06 * salary;
  SET commission = a;
  END
• D.CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
  BEGIN
  DECLARE EXIT HANDLER FOR SQLEXCEPTION
  SET commission = 0;
  DECLARE my_cur CURSOR FOR SELECT * FROM employee;
  DECLARE a DOUBLE;
  SET a = .06 * salary;
  SET commission = a;
  END

Click the Exhibit button.

Which statement is true about the CASE statement shown in the exhibit?

• A.An employee with a rating of 2 receives a 3% salary increase.
• B.An employee with a rating of 3 receives no salary increase.
• C.An employee with a rating of 1 receives a 10% salary increase.
• D.All employees will receive at least a 5% salary increase.

When considering authorization for CREATE OR REPLACE PROCEDURE statements, the authorization id must have:

• A.DBADM authority
• B.group privileges on the table or view specified in the procedure
• C.IMPLICIT_SCHEMA authority on the database
• D.ownership of the existing procedure

What is correct use of the MODULE?

• A.Encryption and encapsulation
• B.Improving performance of transactions
• C.Supporting referential integrity
• D.Grouping object definitions together that has a common business purpose

If the following SQL statements were executed in the order shown: What would be the values of RET_CODE1 and RET_CODE2 after executing the SIZEPRINTER procedure?

• A.123, 123
• B.100, 100
• C.100, 0
• D.100 , 1