Answer Posted / mani
5 types of locks in database
intent
shared
schema
update
bulk update
| Is This Answer Correct ? | 12 Yes | 12 No |
Post New Answer View All Answers
What are different methods to trace the pl/sql code?
What is the difference between inner join and outer join?
What is the difference between delete, truncate and drop command?
Do we need to create index on primary key?
What are the methods of filing?
What is cursor and why it is required?
How to take user input in pl sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is a schema sql?
How can I make sql query run faster?
what is try_catch block in procedure
Is drop table faster than truncate?
What found sql?
Why we use sql profiler?
Mention what does plv msg allows you to do?