IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 11:

  Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?

  A. Control Center
  B. Development Center
  C. Developer Workbench
  D. Stored Procedure Builder Security
  C. Developer Workbench

• Question 12:

  Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?

  A. Index
  B. Check constraint
  C. Referential constraint
  D. Default constraint
  D. Default constraint

• Question 13:

  Given the following two tables:

  TAB1 C1 C2

  1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY

  5 Europe 6 North America 7 South America

  Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?

  A. INSERT INTO tab1 SELECTcx, cy FROM tab2
  B. INSERT INTO tab1 VALUES (tab2. cx, tab2. cy)
  C. INSERT INTO tab1 VALUES (SELECTcx, cy FROM tab2)
  D. INSERT INTO tab1 (c1, c2) VALUES (SELECTcx, cy FROM tab2)
  A. INSERT INTO tab1 SELECTcx, cy FROM tab2

• Question 14:

  Which of the following is true of an index used to support a UNIQUE constraint?

  A. It must have the UNIQUE attribute.
  B. It cannot be created explicitly by the user.
  C. It must have the UNIQUE and CLUSTER attributes.
  D. It must have the UNIQUE WHERE NOT NULL attribute.
  A. It must have the UNIQUE attribute.

• Question 15:

  Which two of the following statements are true about the HAVING clause?

  A. The HAVING clause is used in place of the WHERE clause.
  B. The HAVING clause uses the same syntax as the WHERE clause.
  C. The HAVING clause can only be used with the GROUP BY clause.
  D. The HAVING clause accepts wildcards.
  E. The HAVING clause uses the same syntax as the IN clause.
  B. The HAVING clause uses the same syntax as the WHERE clause.
  C. The HAVING clause can only be used with the GROUP BY clause.

• Question 16:

  Which of the following strings can be inserted into an XML column using XMLPARSE?

  A. ""
  B. ""
  C. ""
  D. ""
  A. ""

• Question 17:

  Given the following query:

  SELECT quantity,

  CASE WHEN itemcode = '099' THEN 'SILVER'

  WHEN itemcode = '788' THEN 'GOLD'

  WHEN itemcode = '899' THEN 'PLATINUM'

  ELSE 'ERROR'

  END

  FROM supplier

  What will be the result of the query if the following data is evaluated by the CASE expression?

  SUPPLIER

  QUANTITY ITEMCODE 3 099 4 099 1 788 1 899 5 009 3 788 1 899

  A. 3,SILVER 4,GOLD 1,SILVER 1,GOLD 5,PLATINUM 3,SILVER 1,GOLD
  B. 3,SILVER 4,SILVER 1,GOLD 1,PLATINUM 5,ERROR 3,GOLD 1,PLATINUM
  C. 3,SILVER 4,SILVER 1,PLATINUM 1,ERROR 5,SILVER 3,GOLD 1,PLATINUM
  D. 3,SILVER 4,SILVER 1,GOLD 1,GOLD 5,SILVER 3,ERROR 1,PLATINUM
  B. 3,SILVER 4,SILVER 1,GOLD 1,PLATINUM 5,ERROR 3,GOLD 1,PLATINUM

• Question 18:

  A stored procedure has been created with the following statement:

  CREATE PROCEDURE proc1 (IN var1 VARCHAR(10), OUT rc INTEGER) SPECIFIC myproc LANGUAGE SQL ...

  What is the correct way to invoke this procedure from the command line processor (CLP)?

  A. CALL proc1 ('SALES', ?)
  B. CALLmyproc ('SALES', ?)
  C. CALL proc1 (SALES, ?)
  D. RUN proc1 (SALES, ?)
  A. CALL proc1 ('SALES', ?)

• Question 19:

  Given the following data:

  TAB1

  C1 C2

  200 abc 250 abc 150 def 300 ghi 175 def

  If the following query is executed: WITH subset (col1, col2) AS (SELECT c1, c2 FROM tab1 WHERE c1 > 150) SELECT col2, SUM(col1) AS col1_sum FROM subset GROUP BY col2 ORDER BY col2

  Which of the following result data sets will be produced?

  A. COL2 COL1_SUM abc 200 abc 250 def 175 ghi 300 4 record(s) selected.
  B. COL2 COL1_SUM abc 450 def 175 ghi 300 3 record(s) selected.
  C. COL2 COL1_SUM abc 450 def 325 ghi 300 3 record(s) selected.
  D. COL2 COL1_SUM abc 450 abc 450 def 175 def 175 ghi 300 5 record(s) selected.
  B. COL2 COL1_SUM abc 450 def 175 ghi 300 3 record(s) selected.

• Question 20:

  If the following SQL statements are executed:

  CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, name VARCHAR(25));

  CREATE TABLE tab2 (empid SMALLINT,

  weekno SMALLINT,

  payamt DECIMAL(6,2),

  CONSTRAINT const1 FOREIGN KEY (empid)

  REFERENCES taba(id) ON UPDATE NO ACTION);

  Which of the following statements is true?

  A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
  B. The updating of values in the ID column of table TAB1 is not allowed
  C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
  D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well
  A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2