Answer Posted / saiz

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

What are the set operators in sql?

1056

---

What is record data type?

900

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1031

---

How do you write a subquery?

1005

---

Explain what is an index?

1035

---

Is pl sql different from sql?

968

---

what is oltp (online transaction processing)? : Sql dba

1066

---

What is schema in sql example?

1159

---

How do you determine the current isolation level? : Transact sql

1142

---

what is error ora-03113: end-of-file on communication channel?

1149

---

How do I find duplicates in sql?

916

---

what are all the common sql function? : Sql dba

1045

---

Why sql query is slow?

974

---

What is the current version of sql?

1005

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1027

---