Oracle Scenarios Question:
Download Questions PDF

Explain What is bulk SQL?

Answer:

Bulk sql are forall and bulk collect INTO statement,
For performence reason the bulk bind is used to eleminate the context switching between two sql and pl/sql eng.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?Explain What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it?