DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: 8i ocp Exams till what date

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    Ocp 8i exams are till what date/month .

    Are there any promotions ./codes
    Radhakrishnan.M

  2. #2
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    The Oracle8 Core Exams are scheduled to retire on March 31, 2002.

  3. #3
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    Have no idea when 8i OCP retires.

  4. #4
    Join Date
    Mar 2002
    Posts
    3
    8i... hmmmm March 31, 2003?


  5. #5
    Join Date
    Mar 2002
    Posts
    60
    I think they will be availaible much longer than Mar 2003..

  6. #6
    Join Date
    Mar 2002
    Posts
    56
    Q. 2 : The following is a DML statement keyword

    1. EXPLAIN PLAN
    2. TRUNCATE
    3. ANALYZE
    4. COMMENT

    Ans:2 ,can anyone explain,how is it?

  7. #7
    Join Date
    Jun 2001
    Posts
    132

    Wink

    you use truncate manipulate/delete data, therefore its a DML keyword.
    You think I'm going to have an affair with you? --Stanley Kowalski

  8. #8
    Join Date
    Jan 2001
    Posts
    3,134
    Sorry slob, you loose, thanks for playing. Truncate requires no commit and can not be rolledback, therfore it is not DML. See the other link for more details.

    MH
    I remember when this place was cool.

  9. #9
    Join Date
    Jun 2001
    Posts
    132

    Talking

    Mr. Hanky, you're correct. Truncate is a DDL. the correct answer is 1. explain plan.
    You think I'm going to have an affair with you? --Stanley Kowalski

  10. #10
    Join Date
    Jun 2001
    Posts
    132

    Smile

    although by your own definition {{requires no commit and can not be rolledback, therfore it is not DML. }} you're also wrong. ie. SELECT, CALL and LOCK TABLE are also DML that doesn't require no commit and can not be rolled back.
    You think I'm going to have an affair with you? --Stanley Kowalski

Posting Permissions

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


Click Here to Expand Forum to Full Width