IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 81:

  Which of the following is a NOT a valid reason for defining a view on a table?

  A. Restrict users' access to a subset of table data

  B. Ensure that rows inserted remain within the scope of a definition

  C. Produce an action as a result of a change to a table

  D. Provide users with an alternate view of table data

  Correct Answer: C

• Question 82:

  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 83:

  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 84:

  Given the requirements to store customer names, billing addresses, and telephone numbers, which of the following would be the best way to define the telephone number column for a table if all customers were located in the same country?

  A. PHONE CHAR(15)

  B. PHONE VARCHAR(15)

  C. PHONE LONG VARCHAR

  D. PHONE CLOB(1K)

  Correct Answer: A

• Question 85:

  Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?

  A. Character Large Object

  B. Time

  C. Varying-Length Character String

  D. Timestamp

  Correct Answer: B

• Question 86:

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

  A. SMALLINT

  B. INTEGER

  C. NUMERIC

  D. DOUBLE

  Correct Answer: D

• Question 87:

  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 88:

  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 89:

  Which of the following is a valid DB2 data type?

  A. NUMBER

  B. INTERVAL

  C. BYTE

  D. NUM

  Correct Answer: D

• Question 90:

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

  A. INT

  B. CHAR

  C. XML

  D. DOUBLE

  Correct Answer: C