-
Ocp 8i exams are till what date/month .
Are there any promotions ./codes
Radhakrishnan.M
-
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.
You think I'm going to have an affair with you? --Stanley Kowalski
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|