Answer Posted / pavan_1981

PL/SQL is Oracle's Procedural Language extension to SQL.
PL/SQL's language syntax, structure and data types are
similar to that of ADA. The PL/SQL language includes object
oriented programming techniques such as encapsulation,
function overloading, information hiding (all but
inheritance). PL/SQL is commonly used to write data-centric
programs to manipulate data in an Oracle database

What is the size of partition table?

1043

---

What is data manipulation language?

1187

---

What is the difference between union and union all command?

1087

---

What information is needed to connect sql*plus an oracle server?

1026

---

What is a file delimiter?

1089

---

explain the delete statements in sql

1048

---

How can you view the errors encountered in a trigger?

960

---

Explain the significance of the & and && operators in pl sql.

1007

---

What is crud stand for?

996

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

968

---

What is pl/sql table? Why it is used?

1033

---

What is output spooling in sql*plus?

1030

---

Is foreign key mandatory?

998

---

What is time based sql injection?

957

---

what is the use of friend function? : Sql dba

1021

---