Answer / Anurag Lohant

"PL/SQL table is a temporary or permanent collection of data in an Oracle database that can be created, modified, and queried within PL/SQL blocks. It is used to store intermediate results during the execution of a PL/SQL program for reuse or processing."

how to create a database in oracle?please gve anser with example

1 Answers  

---

What is the difference between subquery and correlated query?

1 Answers  

---

what are different types of keys in sql?

1 Answers  

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

What types of commands can be executed in sql*plus?

1 Answers  

---

What is trigger explain it?

1 Answers  

---

Does normalization improve performance?

1 Answers  

---

What are the various restrictions imposed on view in terms of dml?

1 Answers  

---

What is the difference between null value, zero, and blank space?

1 Answers  

---

What are pl/sql cursors?

1 Answers  

---

What is the difference between inner join and outer join?

1 Answers  

---

Why query optimization is needed?

1 Answers  

---