IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 31:

  Click on the Exhibit button.

  

  Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure is invoked by the call statement shown below?

  CALLfind_customers(ARRAY[?16-305-3745?

  ?05-416-4565?

  ?16-305-3746?

  '905-414-4566'],

  ?16??)

  A. [?16-305-3745??05-416-4565? ?16-305-3746']
  B. [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']
  C. [?05-416-4565? '905-414-4566']
  D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?
  D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?

• Question 32:

  Which statement can be used to define an array of 30 names that have a maximum size of 25characters each?

  A. CREATE TYPE names AS VARCHAR(25) ARRAY[30];
  B. CREATE ARRAY names[30] VARCHAR(25);
  C. CREATE TYPE names[30] VARCHAR(25);
  D. CREATE ARRAY names AS VARCHAR(25);
  A. CREATE TYPE names AS VARCHAR(25) ARRAY[30];

• Question 33:

  Which of the following statements is true?

  A. A DATETIME value can be assigned to a DATE variable.
  B. Values cannot beassigned to variables inside ERROR HANDLERS.
  C. A TIMESTAMP value can be assigned to a TIME variable.
  D. The result of a GET DIAGNOSTICS statement cannot be assigned to a variable.
  C. A TIMESTAMP value can be assigned to a TIME variable.

• Question 34:

  Which two statements are true? (Choose two.)

  A. SQL procedures can contain static and/or dynamic SQL statements.
  B. Static or dynamic SQL execution is not associated with a package.
  C. The SQL procedure isalways associated with a package that contains access paths of SQL statements in the procedure.
  D. It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.
  E. SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.
  A. SQL procedures can contain static and/or dynamic SQL statements.
  C. The SQL procedure isalways associated with a package that contains access paths of SQL statements in the procedure.

• Question 35:

  Which two statements describe a CASE statement? (Choose two.)

  A. CASE statements are used to enter into some logic based on a literal value.
  B. CASE statements are used to enter into some logicbased on the value of an expression.
  C. CASE statements are used to return control to the beginning of an expression.
  D. CASE statements are used to enter into some condition and loop until the condition is met.
  E. CASE statements are used to iterate intosome logic based on a literal value.
  A. CASE statements are used to enter into some logic based on a literal value.
  B. CASE statements are used to enter into some logicbased on the value of an expression.

• Question 36:

  The CREATE PROCEDURE statement shown below was executed against a database called MYDB.

  CREATE PROCEDURE myschema.proc1(INp1 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 CHAR(4), OUT p2 INTEGER) BEGIN SET p2 = 123; END
  B. CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 CHAR(4)) BEGIN SET p2 = 'abc'; END
  C. CREATE PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER, OUT p3 SMALLINT) BEGIN SET p2 = 123; END
  D. CREATE PROCEDUREotherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4)) BEGIN SET p2 = 'abc'; END
  E. CREATE PROCEDURE myschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER) BEGIN SET p2 = 'abc'; END
  A. CREATE PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER) BEGIN SET p2 = 123; END
  D. CREATE PROCEDUREotherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4)) BEGIN SET p2 = 'abc'; END

• Question 37:

  Given the following statements in an SQL procedure:

  

  Which of the following assignment statements is valid?

  A. SET c1 = VALUES (1, 2, 3);
  B. SET c1 = CURSOR FOR VALUES (1, 2, 3);
  C. c1 = CURSOR VALUES (1, 2, 3);
  D. SET VALUES (1, 2, 3)for CURSOR c1;
  B. SET c1 = CURSOR FOR VALUES (1, 2, 3);

• Question 38:

  What are two ways toexecute an SQL procedure using IBM Data Studio? (Choose two.)

  A. Open a SQL editor, enter the appropriate CALL statement and hit the Run button.
  B. Right-click on the SQL procedure and select the Run option from the menu.
  C. Open a Command Line Processorwindow from IBM Data Studio and execute the appropriate CALL statement.
  D. Open a text editor, enter the appropriate CALL statement and hit the run button.
  E. Right-click on the SQL procedure and select the Open Visual Explain option from the menu.
  A. Open a SQL editor, enter the appropriate CALL statement and hit the Run button.
  B. Right-click on the SQL procedure and select the Run option from the menu.

• Question 39:

  Which declaration is not valid?

  A. DECLARE var1 DECIMAL(9,2);
  B. DECLARE var1 VARCHAR(20);
  C. DECLARE var1 CHAR;
  D. DECLARE var1 INTEGER DEFAULT;
  D. DECLARE var1 INTEGER DEFAULT;

• Question 40:

  Which statement will successfully create an SQL procedure that returns the name of the current month?

  A. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; SET (today = CURRENT_DATE); SET month = MONTHNAME(today); END
  B. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; SELECT (CURRENT_DATE) INTO today; SET month = MONTHNAME(today); END
  C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; VALUES (CURRENT_DATE) INTO today; SET month = MONTHNAME(today); END
  D. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN SET month = MONTHNAME(SELECT (CURRENT_DATE)) END
  C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; VALUES (CURRENT_DATE) INTO today; SET month = MONTHNAME(today); END