Answer Posted / manoj kaushik

Advantages of Packages --Modularity,Easier Application
Design,Information Hiding,Added Functionality,Better
Performance.

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

550

---

How to place comments in pl/sql?

604

---

How to use sql statements in pl/sql?

580

---

how do you login to mysql using unix shell? : Sql dba

568

---

What is a parameter query?

626

---

---

What is an index in sql with example?

519

---

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

527

---

How many types of cursors are available in pl/sql?

586

---

What is the use of function in sql?

540

---

Why is partition used in sql?

550

---

what is rollback? : Sql dba

595

---

what is a table in a database ? : Sql dba

542

---

Explain 3 basic parts of a trigger.

841

---

What is a database event trigger?

596

---

what are the advantages of using stored procedures? : Sql dba

620

---