Answer Posted / dharmendra yadav

select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;

What is an implicit commit?

561

---

What is difference between hql and native sql?

585

---

Can ddl statements be used in pl/sql?

598

---

What is row_number () in sql?

550

---

Is a foreign key always unique?

536

---

---

What is bitemporal narrowing?

739

---

what is the difference between truncate and delete statement? : Transact sql

552

---

How can I tell if sql is running?

593

---

explain the difference between bool, tinyint and bit. : Sql dba

531

---

Can you skip header records while loading? : aql loader

544

---

Show the two pl/sql cursor exceptions.

616

---

What are aggregate functions in sql?

633

---

What are the advantages of pl sql?

607

---

Can you selectively load only those records that you need? : aql loader

615

---

Can you have more than one key in a database?

509

---