Ocp 8i exams are till what date/month .
Are there any promotions ./codes
Printable View
Ocp 8i exams are till what date/month .
Are there any promotions ./codes
The Oracle8 Core Exams are scheduled to retire on March 31, 2002.
Have no idea when 8i OCP retires.
8i... hmmmm March 31, 2003?
I think they will be availaible much longer than Mar 2003..
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?
you use truncate manipulate/delete data, therefore its a DML keyword.
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
Mr. Hanky, you're correct. Truncate is a DDL. the correct answer is 1. explain plan.
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.