can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3
2 6053Post New i2 Interview Questions
Why high latent heat of vaporisation is desirable in a refrigerant ?
Explain the difference between criteria and criterion in hibernate?
What is the procedure to insert into a sorted array?
What happens to child records when a parent record is deleted?
Why sun introduce concept of anonymous class? What is need and real life use of anonymous class
What is Derby database?
Within the interview process you may be required to perform a role-play. A popular example of this is being asked to role-play an escalated call with an unhappy customer.
What are the components of jsp?
How do I upload a file to a joomla server?
what is the difference between testing techniques and principles of testing?Kindly explain both of them with an example.
advantages and disadvantages of the custer sampling
What is the shortcut key option to insert a page break?
List down some of the pdb commands for debugging python programs?
What is the best time complexity of bubble sort?
What is consignment inventory?