Answer Posted / chintu

A query is nothing but if we want to evaluate one thing we
will write query. like
select * from emp; --->> query

A Query is evaluated once for each and every row from the
parent statement is called corellated Query.
like
select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query

What is bulk compiling in pl/sql.?

1060

---

Explain isolation levels. : Transact sql

1015

---

When you have to use a default "rollback to" savepoint of plvlog?

1124

---

What is the use of index in hive?

959

---

What is compound trigger?

959

---

What are the benefits of stored procedures?

997

---

What are the different dcl commands in sql?

1065

---

Explain the working of foreign key?

976

---

What is the difference between database trigger and stored procedure?

1007

---

What is data definition language?

1044

---

What is crud sql?

921

---

What is the difference between clustered and non-clustered index in sql?

957

---

How do you modify a column in sql?

938

---

What is the command used to fetch first 5 characters of the string?

1334

---

what is meant by urlencode and urldocode? : Sql dba

1090

---