What is the difference between sharding and partitioning?
No Answer is Posted For this Question
Be the First to Post Answer
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to lock and unlock a user account in oracle?
Explain the difference between sql and oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is private procedure oracle?
What is integrity and what is constraint??Explain with example
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What is tns name?
How to write date and time literals in oracle?
How to define a procedure inside another procedure?
How to assign query results to variables?