What is meant by Static query and Dynamic query?

Answers were Sorted based on User's Feedback



What is meant by Static query and Dynamic query?..

Answer / malli


Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.

Is This Answer Correct ?    3 Yes 1 No

What is meant by Static query and Dynamic query?..

Answer / malli


Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Core Java Interview Questions

whar are the draw backs of programming lang step by step in Clang and next in C++ and next and in Java nad in .Net

0 Answers  


Can a class have multiple constructors?

0 Answers  


To what value is a variable of the Boolean type automatically initialized?

3 Answers  


What is concurrent hashmap and its features?

0 Answers  


is there any function in java to make the text to blink?

6 Answers  


Can I declare class as static or private?

0 Answers  


What happens to a static var that is defined within a method of a class?

0 Answers  


How java is platform independent?

41 Answers   College School Exams Tests, Infosys, TCS,


all are saying java doesn't support multiple inheritance but by default Object class is super class for all the user defined classes and we can extend atmost one class so each class can extend more than one class so java supports multiple inheritance?i am confused with this,pls any one explain me.

4 Answers  


What about features of local inner class?

0 Answers  


How many types of parsers are there?

0 Answers  


How is hashset defined in java?

0 Answers  


Categories