Oracle Scenarios Question: Download Oracle Scenarios 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 PDF Read All 23 Oracle Scenarios Questions

Previous Question	Next 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?