Answer Posted / varun

select sal from emp where rownum=2 order by sal desc;

What is benefit of creating memory optimized table?

975

---

How will you distinguish a global variable with a local variable in pl/sql?

1158

---

What are the possible values for the boolean data field?

966

---

What are all the different normalization?

1045

---

What is the difference between numeric and autonumber?

1003

---

Cite the differences between execution of triggers and stored procedures?

1082

---

How do I start sql profiler?

1001

---

Can we join tables without foreign key?

966

---

How do I view an execution plan in sql?

990

---

What is the difference between Union and Union all. Which is faster.

1405

---

What is procedure and function?

997

---

what is a field in a database ? : Sql dba

1067

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1055

---

How can use stored procedures in sql?

1144

---

How many types of cursors supported in pl/sql?

1196

---