IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 101:

  Which of the following statements is true for declared global temporary tables?

  A. Declared global temporary table descriptions are stored in the system catalog
  B. When a session terminates, all declared global temporary tables created in the session are dropped.
  C. Declared global temporary tables are persistent and can be shared with multiple sessions.
  D. Declared temporary tables support LONG VARCHAR columns.
  B. When a session terminates, all declared global temporary tables created in the session are dropped.

• Question 102:

  Assuming EMP_ROW and NEW_HIRE have the same user-defined row data type, what is the best way to assign the elements of NEW_HIRE to EMP_ROW?

  A. emp_row.rowid = new_hire.rowid;
  B. emp_row.all = new_hire.all;
  C. SET emp_row = new_hire;
  D. SET emp_row.* = new_hire.*;
  C. SET emp_row = new_hire;

• Question 103:

  Given the procedure show below:

  

  What will be the value of P2?

  A. 50
  B. 51
  C. 100
  D. 102
  C. 100

• Question 104:

  Given the following SQL:

  

  Which of the following statements is true?

  A. The procedure declaration requires theDYNAMIC RESULT SETS 1 clause in order to return a result set.
  B. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.
  C. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.
  D. The cursor declaration requires WITH RETURN clause in order to return a result set.
  B. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.

• Question 105:

  Inthe given text below:

  

  What will be the value of the output variable BONUS?

  A. 500
  B. 1000
  C. 5200
  D. 5500
  A. 500

• Question 106:

  Click the Exhibit button.

  

  The procedure TEST5 shown in the exhibit was invoked. How many rows will be added to the DEPT table?

  A. 1
  B. 2
  C. 3
  D. 4
  C. 3

• Question 107:

  In the code segment shown below:

  

  Which statement accurately describes the result?

  A. For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primarykey.
  B. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
  C. For activities whose descriptionhas changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
  D. The statement will fail since MERGE is not a supported operator.
  B. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.

• Question 108:

  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-execute the current statement.
  C. Change the value of any variables used.

• Question 109:

  Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?

  A. The OLD correlation-name and the OLD TABLE identifier can be used if the trigger event is an INSERT operation.
  B. The scope of each correlation-name and identifierused is the entire trigger definition.
  C. The OLD TABLE or NEW TABLE identifiers can be defined in a BEFORE trigger.
  D. A NEW correlation-name can be specified more than once for a trigger.
  B. The scope of each correlation-name and identifierused is the entire trigger definition.

• Question 110:

  Click the Exhibit button.

  

  An SQL function was created using the statement shown in the exhibit. Assume this function is invoked by executing the SQL statementshown below:

  VALUES e_degree(SMALLINT(17))

  What will be returned?

  A. SQL0440N No authorized routine named "E_DEGREE"of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
  B. 1 BACHELOR 1 record(s) selected.
  C. 1 MASTER 1 record(s) selected.
  D. 1 UNKNOWN 1 record(s) selected.
  D. 1 UNKNOWN 1 record(s) selected.