Answer Posted / mohit lalwani

SGA known as System Global Area and is a part of the Oracle instance.

SGA consist of different memory structures which are

-Shared pool (mandatory)
-Database Buffer Cache (mandatory)
-Redo Log Buffer (mandatory)
-Large Pool (optional)
-Java Pool (optional)

-SGA is sized by sga_max_size

How to execute a stored procedure?

545

---

what is subquery? : Sql dba

560

---

What is the maximum number of triggers, you can apply on a single table?

531

---

How to return an array from java to pl/sql?

578

---

What are the sql commands?

599

---

---

Which one is faster ienumerable or iqueryable?

471

---

What is a left inner join?

521

---

What is sql rowcount?

546

---

How to use sql statements in pl/sql?

566

---

Can we edit a view in sql?

535

---

what is unique key constraint? : Sql dba

556

---

What is a database trigger?

595

---

What is dml and ddl?

509

---

explain what is mysql? : Sql dba

582

---

What is the use of nvl function?

607

---