最新のA2090-545問題集で試験を準備する

Given the following DDL:

what will the SALARY be?

• A. salary * 1.03
• B. salary * 1.50
• C. salary * 1.05
• D. salary * 1.10

Which statement describes what must be done to create an SQL procedure that returns a result set?

• A. Execute the CREATE PROCEDURE statement using the defaults; declare a cursor within the procedure body; open the cursor; retrieve each row into output variables; close the cursor before exiting the procedure.
• B. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; declare a cursor within the procedure body; open the cursor; exit the procedure without closing the cursor.
• C. Execute the CREATE PROCEDURE statement using the defaults; declare a cursor within the procedure body; open the cursor; exit the procedure without closing the cursor.
• D. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; code a SELECT statement in the procedure body.

The CREATE PROCEDURE statement shown below was executed against a database called MYDB.
CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 SMALLINT)
BEGIN
SET p2 = 'abc';
END
Which two CREATE PROCEDURE statements, when executed against the same database, will succeed? (Choose two.)

• A. CREATE PROCEDURE myschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER) BEGIN SET p2 = 'abc'; END
• B. CREATE PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER, OUT p3
  SMALLINT)
  BEGIN
  SET p2 = 123;
  END
• C. CREATE PROCEDURE otherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4)) BEGIN SET p2 = 'abc'; END
• D. CREATE PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER)
  BEGIN
  SET p2 = 123;
  END
• E. CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3
  CHAR(4))
  BEGIN
  SET p2 = 'abc';
  END

How is the FOR statement distinct from other conditional statements?

• A. FOR statements are evaluated before each iteration of the loop.
• B. FOR statements are evaluated at the completion of each iteration of the loop.
• C. FOR statements are used to iterate over rows in a defined read-only result set.
• D. FOR statements have a terminating condition clause.

If table TAB1 were created as follows: CREATE TABLE tab1 (col1 INT NOT NULL); Which statement illustrates the proper way to define an anchor variable that references column COL1 in table TAB1?

• A. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1
• B. DECLARE var1 REFERENCES tab1.col1
• C. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1%TYPE
• D. DECLARE var1 tab1.col1%TYPE