How to change system global area (sga) in oracle?

0 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What is a view and how is it different from a table?

0 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

Difference between inner join vs where ?

0 Answers  

---

How to create a new view in oracle?

0 Answers  

---

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

---

List out the difference between commit, rollback, and savepoint?

0 Answers  

---

Explain the use of log option in exp command.

0 Answers  

---