1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
1 6155create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
2 6534How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 13094What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 3205Post New Polaris SQL PLSQL Interview Questions
What are the Advantages of using CTE in sql server?
What are the new scripting capabilities of ssms? : sql server management studio
How is data send by ip layer?
Should I keep using windows 7?
Explain the difference between a namespace and assembly name in .net?
Why null pointer is used?
What are alternatives to java serialization?
What is community ami?
How do I create a table of contents?
What is the minimum number of disk partitions required to install linux?
What is morphia mongodb?
What are the different payment methods in peoplesoft?
Explain inversion of control?
Where is activex control in internet explorer?
What are the features provided by actionscript 3.0?