IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 11:

  Which SQL statement is allowed in a BEFORE trigger?

  A. INSERT
  B. CALL
  C. MERGE
  D. UPDATE
  B. CALL

• Question 12:

  Which command can be used to convert literals in SQL statements to parameter markers to avoid compilation of similar SQL statements?

  A. UPDATE DB CFG USING STMT_CONC ON
  B. UPDATE DB CFG USING LIT_PARM ON
  C. UPDATE DB CFG USING CURSOR_SHARING FORCED
  D. UPDATE DB CFG USING CURSOR_SHARING ON
  A. UPDATE DB CFG USING STMT_CONC ON

• Question 13:

  Which statement is permitted within a scalar user-defined function body?

  A. COMMIT
  B. INSERT
  C. SIGNAL
  D. LOOP
  C. SIGNAL

• Question 14:

  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 temporarily hidden in the Data Source Explorer view.
  B. The SQL procedure is removed from the data development project.
  C. The SQL procedure is dropped from the database.
  D. The SQL procedure is dropped from the database and removed from the data development project.
  C. The SQL procedure is dropped from the database.

• Question 15:

  Which command can be used to optimize static SQL statements containing parameterized queries?

  A. SET CURRENT EXPLAINMODE=REOPT
  B. SET CURRENT EXPLAIN MODE=EXPLAIN
  C. SET CURRENT EXPLAIN MODE=YES
  D. SET CURRENT EXPLAIN MODE=PARAM
  A. SET CURRENT EXPLAINMODE=REOPT

• Question 16:

  What is the correct order for declarations in a compound statement defined by BEGIN and END?

  A. variable, cursor, handler, condition
  B. variable, condition, cursor, handler
  C. variable, condition, handler, cursor
  D. variable, cursor, condition, handler
  B. variable, condition, cursor, handler

• Question 17:

  What values are generated each time an SQL statement is executed?

  A. SQLERRN and SQLMSG
  B. SQLSTATE and EXCEPTION
  C. EXCEPTION and SQLCODE
  D. SQLSTATE and SQLCODE
  D. SQLSTATE and SQLCODE

• Question 18:

  Which of the following can be done while debugging a SQL procedure with IBM Data Studio?

  A. Change the order of statements being executed.
  B. Edit the procedure and continue.
  C. Change the value of any variables used.
  D. Re-executethe current statement.
  C. Change the value of any variables used.

• Question 19:

  In a SQL Procedure, rows_fetched is an integer variable and curEmp is acursor variable of SELECT statement on a table. After opening the cursor curemp, which of the statement will determine the number of rows fetched?

  A. SET rows_fetched = curEmp%CURSOR_ROWCOUNT
  B. SET rows_fetched = curEmp%ROWCOUNT
  C. SET rows_fetched =CURSOR_ROWCOUNT(curemp)
  D. SET rows_fetched = ROWCOUNT(curemp)
  C. SET rows_fetched =CURSOR_ROWCOUNT(curemp)

• Question 20:

  Which statement will let you use the result set from the nested procedure CALLEE?

  A. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee;
  B. BIND RESULT SET WITH PARAMETERS FOR PROCEDUREcallee;
  C. INSERT RESULT SET FROM callee INTO CURSOR c1;
  D. SELECT * FROM callee;
  A. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee;