IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 1:

  Which two DB2 commands can be performed using the ADMIN_CMD procedure? (Choose two.)

  A. RUNSTATS
  B. BACKUP
  C. RESTORE
  D. RECOVER
  E. CREATE DATABASE
  A. RUNSTATS
  B. BACKUP

• Question 2:

  Which two types of storedprocedures can be developed in IBM Data Studio? (Choose two.)

  A. SQL
  B. PHP
  C. PL/SQL
  D. Perl
  E. Ruby
  A. SQL
  C. PL/SQL

• Question 3:

  For which types of servers can you use IBM Data Studio to create and manage SQL procedures?

  A. DB2 for LUW, DB2 for z/OS, Oracle
  B. DB2 for LUW, DB2 for z/OS, SQL Server
  C. DB2for LUW, DB2 for z/OS, MySQL
  D. DB2 for LUW, DB2 for z/OS, Sybase
  A. DB2 for LUW, DB2 for z/OS, Oracle

• Question 4:

  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 REFERENCES tab1.col1
  B. DECLARE var1 tab1.col1%TYPE
  C. DECLARE var1 ANCHOR DATA TYPETO tab1.col1
  D. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1%TYPE
  C. DECLARE var1 ANCHOR DATA TYPETO tab1.col1

• Question 5:

  Which option is used when declaring a global temporary table that will keep its data across transaction boundaries?

  A. ON ROLLBACK DELETE ROWS
  B. ON ROLLBACK PRESERVE ROWS
  C. ON COMMIT PRESERVE ROWS
  D. ON COMMIT DELETE ROWS
  C. ON COMMIT PRESERVE ROWS

• Question 6:

  Given the following CREATE PROCEDURE statement:

  

  In what order must declarations occur within the lines ap: BEGIN and END ap?

  A. Variables, cursors, and condition handlers
  B. Cursors, variables, condition handlers C. Condition handlers, variables, cursors
  D. Condition handlers, cursors, variables
  A. Variables, cursors, and condition handlers

• Question 7:

  Given the two SQL procedures shown below: What is the expected output if procedure S1 is invoked with the value 1provided for parameter V1?

  

  A. NULL
  B. 2
  C. 5
  D. 7
  D. 7

• Question 8:

  In the stored procedure below:

  

  What will the value of the P_ID parameter be if the procedure is invoked and a value of 2 is specified forthe START_VALUE parameter?

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

• Question 9:

  A trigger was created using the CREATE TRIGGER statement shown below.

  

  Which statement is true about the INCRS_COMM trigger?

  A. The trigger will be executed ifthe STAFF table is populated by a load operation.
  B. The trigger will be executed before a row is inserted into the STAFF table.
  C. This trigger will be executed after a row is inserted into the STAFF table.
  D. This trigger will increase the COMM value ofa newly inserted row by 10 percent.
  C. This trigger will be executed after a row is inserted into the STAFF table.

• Question 10:

  If this statement was used tocreate an SQL procedure named P_EXIT:

  

  What will the return status be?

  A. 10
  B. 20
  C. 99
  D. NULL
  C. 99