Home » Certification » Oracle Certification

Define Executive Plan in Database SQL ?

Correct Answer: Executive plan can be defined as: * SQL Server caches collected procedure or the plan of query execution and used thereafter by subsequent calls * An important feature in relation to performance enhancement * Data execution plan can be viewed textually or graphically

← Previous Question Next Question→

More Questions from Oracle Certification

Insert command falls in which sub-language of SQL ?
In R-DBMS, the data is organized in the form of _____.
What are the different types of SQL statements ?
How many joining conditions are required to join 4 tables in SQL?
What command would you use to create a backup control file?
What is an Oracle index?
What is the default return value of a function?
what will be the output of the following code? class Value { public int i = 15; } public class Test { public static void main(String argv[]) { Test t = new Test(); t.first(); } public void first() { int i = 5; Value v = new Value(); v.i = 25; second(v, i); System.out.println(v.i); } public void second(Value v, int i) { i = 0; v.i = 20; Value val = new Value(); v = val; System.out.println(v.i + " " + i); } }
MOV extension refers usually to what kind of files?
Explain Data Control Language

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion