Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    23

    Unanswered: some questions in 700 certification exam

    I am preparing for 700 certification .Is there someone can help me ?Thanks!
    Which of the following is NOT a valid data type on CREATE TABLE?
    DATETIME or DOUBLE
    CREATE TABLE T1(C1 CHAR(3))
    INSERT INTO T1 VALUES ('A')
    ROLLBACK
    COMMIT
    The value A insert into c1 or not?

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    datatype is date or time or timestamp
    insert yes-but rollbacked= empty table
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Oct 2007
    Posts
    23
    thank you !

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I'm curious because I sometimes supervise such exams: Is there a reason why you don't want to take the 730 exam (DB2 V9 Fundamentals)?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •