Answer Posted / swapna

select ename from emp where sal>(select avg(sal) from emp);

What is a stored procedure in sql with example?

598

---

Explain how can you save or place your msg in a table?

593

---

What are the different types of database management systems?

529

---

How do you run a query?

586

---

What are the benefits of pl/sql packages?

539

---

---

How do I view a sql database?

554

---

Explain commit, rollback and savepoint.

601

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

674

---

What are the types of operators available in sql?

552

---

What are the two different parts of the pl/sql packages?

557

---

What is a primary key sql?

559

---

Differentiate pl/sql and sql?

558

---

What company owns postgresql?

560

---

what is an extent ? : Sql dba

580

---

What is the difference between mdf and ndf files?

562

---