What is meant by Static query and Dynamic query?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the features of java programming language.

566


What are the characteristics of Final,Finally and Finalize keywords.

706


Can a constructor be protected?

536


What is array initialization in java?

497


What is the intersection and union methods?

550






There are two classes named classa and classb. Both classes are in the same package. Can a private member of classa can be accessed by an object of classb?

1004


How do you break a loop?

567


Define "Access specifiers" in java.

610


What is the difference between form & report?

593


Why is the main method static?

605


What is the different types of functions?

562


How to restrict a member of a class from inheriting by its sub classes?

805


Explain the use of volatile field modifier?

638


What are the different ways to handle exceptions?

542


What is scope & storage allocation of global and extern variables? Explain with an example

583