Answer / sawant

The System Global Area in a Oracle database is the
area in memory to facilitates the transfer of information
between users. It holds the most recently requested
structural information between users. It holds the most
recently requested structural information about the database.

The structure is Database buffers, Dictionary cache, Redo
Log Buffer and Shared SQL pool (ver 7.0 only) area.

What is a sub query and what are the different types of subqueries?

1 Answers  

---

How to select some columns from a table in oracle?

1 Answers  

---

How to use values from other tables in update statements using oracle?

0 Answers  

---

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1 Answers   HCL,

---

defination of bitmap index

1 Answers   NIIT,

---

What are the components of Logical database structure of ORACLE database?

4 Answers  

---

What is backup in Oracle?

1 Answers   MCN Solutions,

---

How do I recompile a procedure in oracle?

1 Answers  

---

What is the max number of columns in an oracle table?

1 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---

Please explain compound trigger in oracle?

1 Answers  

---