Answer Posted / akki julak

select count(empno)-count(distinct(empno)) from emp;

What is a sql trace file?

546

---

Why is there a need for sqlcode and sqlerrm variables?

585

---

Is sql sequential or random?

536

---

Is stored procedure faster than query?

562

---

Is null operator in sql?

604

---

---

Explain the order of sql statement execution?

608

---

What is pl sql in dbms?

503

---

Define commit, rollback and savepoint?

571

---

Why do we use subquery?

487

---

What is sql lookup?

511

---

What is sql select statement?

503

---

Mention what does plv msg allows you to do?

662

---

Which command is used to call a stored procedure?

499

---

Explain alias in sql?

582

---

Can we rollback after truncate?

563

---