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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Given the following two tables:NAMESNAME NUMBERWayne Gretzky 99Jaromir Jagr 68Bobb...

  • Which of the following is a valid wildcard character in a LIKE clause of a SELECT ...

  • Given the following tables:YEAR_2006EMPID NAME1 Jagger, Mick2 Richards, Keith3 Woo...

  • Given the following table definition:SALESINVOICE_NO CHAR(20) NOT NULLSALES_DATE D...

  • Given the following statement:SELECT hyear, AVG(salary)FROM (SELECT YEAR(hiredate)...

  • Which two of the following statements are true about the HAVING clause?

  • Given the following table definitions:DEPARTMENTDEPTNO CHAR(3)DEPTNAME CHAR(30)MGR...

  • Given the following table:EMPLOYEEEMPID NAME INSTRUMENT1 Jagger, Mick 012 Richards...

  • Given the following UPDATE statement:UPDATE employees SET workdept =(SELECT deptno...

  • Given the following table:CURRENT_EMPLOYEESEMPID INTEGER NOT NULLNAME CHAR(20)SALA...

  • Given the following table definition:SALESSALES_DATE DATESALES_PERSON CHAR(20)REGI...

  • Given the following table definition:EMPLOYESSEMP ID INTEGERNAME CHAR(20)DEPT CHAR...

  • The following SQL statement:DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RRIs used ...

  • Given the following data:TAB1C1 C2200 abc250 abc150 def300 ghi175 defIf the follow...

  • Given the following table definitions:TABLE1ID INTNAME CHAR(30)PERSON INTCITIES IN...

  • Given the following table definitions:EMPLOYEESEMPID INTEGERNAME CHAR(20)DEPTID CH...

  • Given the following table:CURRENT_EMPLOYEESEMPID INTEGER NOT NULLNAME CHAR(20)SALA...

  • Given the following table:STOCKCATEGORY CHAR(1)PARTNO CHAR(12)DESCRIPTION VARCHAR(...

  • Given the following SQL statements:CREATE TABLE tab1 (col1 INTEGER)INSERT INTO tab...

  • Given the following table definition:SALESINVOICE_NO CHAR(20) NOT NULLSALES_DATE D...

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
    0 views
    people
    0 takers
    folder
    IBM

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings