IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 61:

  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 ISNULL) 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 empnoFROM oldemployee)
  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

• Question 62:

  Which two statements are true with regards to nesting SQL procedures? (Choose two.)

  A. An SQL procedure cannot invoke procedures built in other languages (e.g., C, Java).
  B. An SQL procedure can invoke the same SQL procedure more than once.
  C. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with theREADS SQL DATA clause.
  D. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the MODIFIES SQL DATA clause.
  E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NOSQL clause.
  B. An SQL procedure can invoke the same SQL procedure more than once.
  E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NOSQL clause.

• Question 63:

  Given the following statement:

  

  How many values are inserted in to the array called quantity?

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

• Question 64:

  Which three optional clauses can be used whencreating an external function? (Choose three.)

  A. SCRATCHPAD
  B. NOTEPAD
  C. LANGUAGE
  D. EXTERNAL NAME
  E. DATABASEINFO
  A. SCRATCHPAD
  C. LANGUAGE
  D. EXTERNAL NAME

• Question 65:

  Which statement will create global variable?

  A. CREATE VARIABLE glob_emp_sal ANCHORE TO employee.salary
  B. PUBLISH VARIABLE glob_emp_sal DECIMAL(9,2)
  C. DECLARE GLOBAL VARIABLE glob_emp_sal DECIMAL(9,2)
  D. DECLARE GLOBAL VARIABLE glob_emp_sal ANCHORE TO employee.salary
  A. CREATE VARIABLE glob_emp_sal ANCHORE TO employee.salary

• Question 66:

  Given the following script:

  

  What would be result from the SELECT * FROM audi1?

  A. NLEVEL MESSAGE 1 FROM TRIGGER
  B. NLEVEL MESSAGE 2 FROM TRIGGER
  C. NLEVEL MESSAGE 2 TEST1
  D. NLEVEL MESSAGE 5 FROM TRIGGER
  B. NLEVEL MESSAGE 2 FROM TRIGGER

• Question 67:

  Which of the following statement isTRUE about a REPEAT loop?

  A. The condition is checked at the end of the loop.
  B. The condition is checked at the beginning of the loop.
  C. A REPEAT loop behaves like a WHILE loop.
  D. A REPEAT loop behaves like a FOR loop.
  A. The condition is checked at the end of the loop.

• Question 68:

  Which statement is true about the NUMBER data type?

  A. In DB2, theNUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.
  B. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.
  C. Declaring a column as NUMBER(10,-2)is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.
  D. Declaring a column as NUMBER(6,8) is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.
  A. In DB2, theNUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.

• Question 69:

  What is a reason to use SQL procedures in DB2?

  A. to use different programming languages
  B. to reduce code sharing
  C. to move business logic rules into the database
  D. to eliminate the need for testing
  C. to move business logic rules into the database

• Question 70:

  Click the Exhibit button.

  

  Referring to theexhibit, how many rows will be returned by the SQL query shown below?

  SELECT * FROM TABLE(getnumemployee(21?) AS dSELECT * FROM TABLE(getnumemployee(?21?) AS d

  B. 1
  C. 7
  D. 10
  C. 7