IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 121:

  Which of the following can NOT 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

  Correct Answer: D

• Question 122:

  Which two of the following are optional and do not have to be specified when creating a table?

  A. Table name

  B. Column name

  C. Default constraint

  D. Column data type

  E. NOT NULL constraint

  Correct Answer: CE

• Question 123:

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

  A. ""

  B. "John Doe"

  C. ""

  D. ""

  Correct Answer: C

• Question 124:

  Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?

  A. BLOB

  B. CLOB

  C. DBCLOB

  D. GRAPHIC

  Correct Answer: B

• Question 125:

  Which of the following DB2 data types can NOT be used to create an identity column?

  A. SMALLINT

  B. INTEGER

  C. NUMERIC

  D. DOUBLE

  Correct Answer: D

• Question 126:

  Which of the following is a valid DB2 data type?

  A. NUMBER

  B. INTERVAL

  C. BYTE

  D. NUM

  Correct Answer: D

• Question 127:

  Which of the following DB2 data types does NOT have a fixed length?

  A. INT

  B. CHAR

  C. XML

  D. DOUBLE

  Correct Answer: C

• Question 128:

  Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

  A. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)

  B. CREATE DISTINCT TYPE currency AS SMALLINT

  C. CREATE DISTINCT TYPE currency AS BIGINT

  D. CREATE DISTINCT TYPE currency AS DOUBLE

  Correct Answer: A

• Question 129:

  Given the following CREATE TABLE statement:

  CREATE TABLE customer(custid INTEGER, info XML)

  And the following INSERT statements:

  INSERT INTO customer VALUES (1000,

  ' John Doe

  25 East Creek Drive

  Raleigh

  North Carolina

  27603

  919-555-1212

  [email protected]

  ');

  INSERT INTO customer VALUES (1000,

  ' Paul Smith

  412 Stewart Drive

  Toronto

  Ontario

  M8X-3T6

  919-555-4444

  [email protected]

  ');

  What is the result of the following XQuery expression?

  XQUERY declare default element namespace "http://custrecord.dat"; for $info in db2-fn:xmlcolumn ('CUSTOMER.INFO')/customerinfo where $info/addr/state-prov="Ontario" return $info/name/text();

  A. Paul Smith

  B. Paul Smith

  C. Paul Smith

  D. Paul Smith

  Correct Answer:

• Question 130:

  Given the following table:

  TEMP_DATA

  TEMP DATE

  45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006

  And the following SQL statement:

  CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END

  Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?

  A. VALUESdegf_to_c(32)

  B. SELECT date,degf_to_c(temp) AS temp_c FROM temp_data

  C. CALLdegf_to_c(32)

  D. SELECT * FROMTABLE(degf_to_c(temp)) AS temp_c

  E. VALUESdegf_to_c(32) AS temp_c

  Correct Answer: AB