Answer / nitin

The phase of sql query execution is as follows.
1)Syntax Checking: Query will be checked if it is syntactically correct.
2)Semantic Checking:Query will be checked for user has rights on tables etc.
3)Cursor sharing:query will be checked against cursor sharing if soft parse can be done or hard parse required.
4)The creation of cost based decision tree for possible plans.
5)The execution of lowest cost execution plan.
6)Binding the execution plan.
7) Executing the query and fetching the rows.

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---

What is record variable?

0 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

Explain the difference in execution of triggers and stored procedures?

0 Answers  

---

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

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---

Describe types of sql statements?

0 Answers  

---

Is ms sql traffic encrypted?

0 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

---

How to use boolean type in select statement?

0 Answers  

---