logo

CuriousTab

Define Executive Plan in Database SQL ?

Discussion


Home Certification Oracle Certification Comments
Share: 

  • Question
  • 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 

  • Tags: Database Administrator, Project Manager
    Similar Questions
  • 1. In the following pieces of code, B and D will compile without any error. True or false ? A: StringBuffer sb1 = "abcd"; B: Boolean b = new Boolean("abcd"); C: byte b = 255; D: int x = 0x1234; E: float fl = 1.2; Solve it....

  • 2. What is the output after compile and run the following code ? int Output = 10; boolean b = false; if((b == true) && ((Output += 10) == 20)) { System.out.println("We are equal " + Output); } else { System.out.println("Not equal! " + Output); } Solve it....

  • 3. Why do you need common fields in a Database? Solve it....

  • 4. Difference between Candidate key and Primary key? Solve it....

  • 5. What is the maximum number of triggers, can apply to a single table? Solve it....

  • 6. Insert command falls in which sub-language of SQL ? Solve it....

  • 7. In R-DBMS, the data is organized in the form of _____. Solve it....

  • 8. What are the different types of SQL statements ? Solve it....

  • 9. How many joining conditions are required to join 4 tables in SQL? Solve it....

  • 10. What command would you use to create a backup control file? Solve it....


  • Comments

    There are no comments.

Enter a new Comment