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

What is dml statement?

995

---

What are data types in pl sql?

1189

---

How do I count rows in sql query?

1034

---

is mysql query is case sensitive? : Sql dba

1157

---

What is the starting oracle error number? What is meant by forward declaration in functions?

1039

---

How to move files from one directory to another in pl sql?

1242

---

What is trigger types of trigger?

1136

---

what is view? : Sql dba

1021

---

What are the usages of sql?

1096

---

How do you create an update query?

1015

---

how to use 'mysql' to run sql statements? : Sql dba

1108

---

How do I order by ascending in sql?

1074

---

What is primary key and foreign key?

1009

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1112

---

What is the advantage of index in sql?

1013

---