Answer Posted / sumeet

select min(sal) from emp where sal in (select top 2 sal from
emp order by sal desc);

What do you mean by cdb and pdb in oracle 12c?

1064

---

Can we protect our pl/sql source code?

1051

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2154

---

What would you do with an in-doubt distributed transaction?

1988

---

Which is better Oracle or MS SQL? Why?

4957

---

What is Virtual Private Database in Oracle?

1097

---

How to loop through a cursor variable?

1094

---

What is oracle database 10g express edition?

1128

---

How to define an anonymous procedure with variables?

1167

---

How many anonymous blocks can be defined?

1193

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2318

---

How to update a table row with a record?

1019

---

How to drop an existing view in oracle?

953

---

What happens to the indexes if a table is recovered?

994

---

what is a Nested Loop join?

2123

---