C2090-730 DB2 9 Family Fundamentals Exam (Exam 6)

C2090-730 DB2 9 Family Fundamentals Exam (Exam 6)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which of the following is a feature of a unit of work?

  • Consider the following table called EMPLOYEES:ID FIRSTNAME LASTNAME JOB LEVEL-----...

  • Given the following query:SELECT quantity,CASE WHEN itemcode = '099' THEN 'SILVER'...

  • In which of the following situations should correlation names be used?

  • Which of the following statements eliminates all but one of each set of duplicate ...

  • Given the following tables:CONTINENTSID NAME COUNTRIES1 Antarctica 02 Africa 533 A...

  • How should the following UDF be invoked in order to convert US currency values sto...

  • Given that tables T1 and T2 contain the following rows:Table T1:C1 C25 45 25 5Tabl...

  • Given the following two tables:TAB1C1 C21 Antarctica2 Africa3 Asia4 AustraliaTAB2C...

  • Given the following table and XML data stored in the CONTACTINFO column:CREATE TAB...

  • 57 Given table T1 has column I1 containing the following data:I1If the following s...

  • Given the following two tables:NAMESNAME NUMBERWayne Gretzky 99Jaromir Jagr 68Bobb...

  • Given the following CREATE TABLE statement:CREATE TABLE EMPLOYEE(EMPNO CHAR(3) NOT...

  • Given the following two tables:TAB1COL_1 COL_2A 10B 12C 14TAB2COL_A COL_BA 21C 23D...

  • If the following SQL statements are executed in the order shown:CREATE TABLE table...

  • Given the following table:TAB1COL1 COL2A 10B 20C 30A 10D 40C 30Assuming the follow...

  • The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRST...

  • Given the following expression:SELECT QUANTITY,CASE WHEN ITEMCODE = '099' THEN "SI...

  • Which of the following queries will correctly return the manager information sorte...

  • Assuming table TAB1 contains 100 rows, which of the following queries will return ...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    4 views
    people
    0 takers
    folder
    IBM

  • C2090-730 DB2 9 Family Fundamentals Exam (Exam 6) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings