Oracle Scenarios Question:

Download Job Interview Questions and Answers PDF

Explain What is bulk SQL?

Oracle Scenarios Interview Question
Oracle Scenarios Interview Question

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?