IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 151:

  An alias can be an alternate name for which two of the following DB2 objects?

  A. Sequence
  B. Trigger
  C. View
  D. Schema
  E. Table
  C. View
  E. Table

• Question 152:

  Given the statement:

  CREATE TABLE tablea (col1 INTEGER NOT NULL, CONSTRAINT const1 CHECK (col1 in (100, 200, 300)) Which of the following can be inserted into TABLEA?

  B. NULL
  C. 100
  D. '100'
  C. 100

• Question 153:

  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
  D. Default constraint

• Question 154:

  Which of the following is NOT a characteristic of a unique index?

  A. Each column in a base table can only participate in one uniqueindex, regardless of how the columns are grouped (the same column cannot be used in multiple unique indexes)
  B. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute
  C. A unique index cannot be created for a populated table if the key column specified contains more than one ULL value
  D. A unique index can only be created for a non-nullable column
  D. A unique index can only be created for a non-nullable column

• Question 155:

  In a client-server environment, which two of the following can be used to verify passwords?

  A. System Catalog
  B. User ID/password file
  C. Client Operating System
  D. Communications layer
  E. Application Server
  C. Client Operating System
  E. Application Server

• Question 156:

  If table TAB1 is created using the following statement:

  CREATE TABLE tab1 (col1 INTEGER NOT NULL,

  col2 CHAR(5),

  CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))

  Which of the following statements will successfully insert a record into table TAB1?

  A. INSERT INTO tab1 VALUES (0, 'abc')
  B. INSERT INTO tab1 VALUES (NULL, 'abc')
  C. INSERT INTO tab1 VALUES (ABS(2), 'abc')
  D. INSERT INTO tab1 VALUES (DEFAULT, 'abc')
  C. INSERT INTO tab1 VALUES (ABS(2), 'abc')

• Question 157:

  Which of the following DB2 products are required on an iSeries or System I server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?

  A. DB2 for i5/OS
  B. DB2 Runtime Client
  C. DB2 ConnectEnterprise Edition
  D. DB2 for i5/OS SQL Development Kit
  A. DB2 for i5/OS

• Question 158:

  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
  A. VALUESdegf_to_c(32)
  B. SELECT date,degf_to_c(temp) AS temp_c FROM temp_data

• Question 159:

  Given the following ALTER SEQUENCE statement:

  ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER

  Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?

  A. The next value will be 0 and the sequence will never use the values 101 to 105.
  B. The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
  C. Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
  D. The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
  D. The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

• Question 160:

  Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?

  A. SELECT UNIQUE dept FROM staff
  B. SELECT DISTINCT dept FROM staff
  C. SELECT (dept) UNIQUE FROM staff
  D. SELECT (dept) DISTINCT FROM staff
  B. SELECT DISTINCT dept FROM staff