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 6879create 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 7573How 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 16307What 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 4026Post New Polaris SQL PLSQL Interview Questions
What are sql data types?
How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?
What is exact difference between step page and page new(both will create the pages)?
What is the difference between process and program?
What is css attr() funtion?
What are different types of linked lists?
Tell me what is tally accounting?
When mesuring the flow of liquid what are the two things to measure?
we have a 2.5hp Starite electric motor water pump,the elec motor burned out,we need to replace starting capacitor(old capacitor specs erased),what microfarad rating capacitor do we need? 110-125V
What does "i_am_a_dummy flag" do in mysql?
Where all you can create target groups?
How do you generate an automatic po after creating a pr using a particular material?
explain how caching proxy of websphere on the edge server is done?
How to get execution statistics reports on query statements?
What are the types of macro formats?