IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 111:

  The following triggers were defined for table TAB1 in the order shown:

  CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SET billing_date = CURRENT DATE;

  If an event occurs that causes all of them to activate, which trigger will be activated first?

  A. TRIG_A
  B. TRIG_B
  C. TRIG_C
  D. TRIG_D
  A. TRIG_A

• Question 112:

  Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?

  A. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system
  B. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects
  C. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe
  D. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/ control and asset management, meteorology and oceanography
  C. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe

• Question 113:

  A UDT is a data type which:

  A. must contain unique values.
  B. cannot be CAST to other data types.
  C. is created using the CREATE DISTINCT command.
  D. contains a value that was automatically calculated from values in other columns.
  C. is created using the CREATE DISTINCT command.

• Question 114:

  Which of the following resources can be referenced in the LOCK statement?

  A. Row
  B. Table
  C. Column
  D. Table space
  B. Table

• Question 115:

  Given the following two tables:

  NAMES

  NAME NUMBER

  Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23

  Mario Lemieux 66

  POINTS

  NAME POINTS

  Wayne Gretzky 244 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94

  How many rows would be returned using the following statement?

  SELECT name FROM names, points

  B. 5
  C. 10
  D. 25
  D. 25

• Question 116:

  Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?

  A. Applications A and B will cause a deadlock situation.
  B. Application B will read the previous version of the row.
  C. Application B will read the row and see uncommitted changes made by application A.
  D. Application B will be placed in a lock-wait state until applicationA releases its lock.
  D. Application B will be placed in a lock-wait state until applicationA releases its lock.

• Question 117:

  Which of the following DB2 UDB isolation levels will only lock rows during read processing if another transaction tries to drop the table the rows are being read from?

  A. Repeatable Read
  B. Read Stability
  C. Cursor Stability
  D. Uncommitted Read
  D. Uncommitted Read

• Question 118:

  Which of the following actions will NOT cause a trigger to be fired?

  A. INSERT
  B. DELETE
  C. ALTER
  D. UPDATE
  C. ALTER

• Question 119:

  When does a view get populated?

  A. When it is created
  B. When it is referenced in an INSERT statement
  C. The first time any executable SQL statement references it
  D. Any time an executable SQL statement references it
  D. Any time an executable SQL statement references it

• Question 120:

  Given the following table definition:

  EMPLOYEES

  EMPID INTEGER

  NAME CHAR(20)

  SALARY DECIMAL(10,2)

  If the following SQL statement is executed:

  CREATE UNIQUE INDEX empid_ui ON employees (empid)

  Which two of the following statements are true?

  A. Multiple null values are allowed in the EMPID column of the EMPLOYEES table.
  B. No null values are allowed in the EMPID column of the EMPLOYEES table.
  C. One (and only one) null value is allowed in the EMPID column of the EMPLOYEES table.
  D. No other unique indexes can be created on the EMPLOYEES table.
  E. Every value found in the EMPID column of the EMPLOYEES table will be different.
  C. One (and only one) null value is allowed in the EMPID column of the EMPLOYEES table.
  E. Every value found in the EMPID column of the EMPLOYEES table will be different.