Answer Posted / parameswara reddy.challa

logical optimization
physical optimization

how to get @@error and @@rowcount at the same time? : Sql dba

531

---

What are sql objects?

546

---

Can we insert data into view?

527

---

what does the t-sql command ident_incr does? : Transact sql

605

---

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

524

---

---

Can we rollback delete command?

516

---

Difference between global and parameter variables?

1461

---

What is the difference between function and procedure in pl/sql?

546

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

554

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

500

---

Does sql*plus also have a pl/sql engine?

563

---

Sql technical questions

779

---

Differentiate between syntax and runtime errors.

642

---

How to run sql statements with oracle sql developer?

625

---

Which type of cursor is used to execute the dml statement?

534

---