IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 301:

  Application A issues the following SQL statements within in a single transaction using the Uncommitted Read isolation level:

  SELECT * FROM employee WHERE deptno='A00';

  UPDATE employee SET salary = salary * 1.1 WHERE deptno='A00';

  As long as the transaction has not been committed, which of the following is true for all other applications not running under the Uncommitted Read isolation level?

  A. They can read and make changes to data for any employee in department A00.
  B. They can read but not make changes to data for any employee in department A00.
  C. They must wait until the transaction is committed before accessing data of any employee in department A00.
  D. They must wait until application A disconnects before accessing data of any employee in department A00.
  C. They must wait until the transaction is committed before accessing data of any employee in department A00.

• Question 302:

  Which of the following DB2 objects is NOT considered executable using SQL?

  A. Routine
  B. Function
  C. Procedure
  D. Trigger
  D. Trigger

• Question 303:

  Which of the following tools can be used to catalog a database?

  A. Visual Explain
  B. Alert Center
  C. Journal
  D. Configuration Assistant
  A. Visual Explain

• Question 304:

  Given the following tables:

  YEAR_2006

  EMPID NAME

  1 Jagger, Mick 2 Richards, Keith 3 Wood, Ronnie 4 Watts, Charlie 5 Jones, Darryl 6 Leavell, Chuck YEAR_1962 EMPID NAME

  1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Watts, Charlie 6 Stewart, Ian

  If the following SQL statement is executed, how many rows will be returned?

  SELECT name FROM year_2007 UNION ALL SELECT name FROM year_1962

  A. 6
  B. 9
  C. 10
  D. 12
  D. 12

• Question 305:

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

  Which of the following describes the model used by the Geodetic Extender?

  A. Flat earth
  B. 3-D Square
  C. Trapezoidal
  D. Round earth
  D. Round earth

• Question 307:

  Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?

  A. Task Center
  B. Command Editor
  C. Developer Workbench
  D. Command Line Processor
  B. Command Editor