Explain an exception and its types?
What is an oracle transaction?
What are the general rules on data consistency?
what are the things that you consider while creating indexes on partitioning tables?
how to find count rows in table without count function?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Display Odd/ Even number of records?
what is the syntax of UPDATE command?
Can we call a trigger inside a function and function inside a trigger? Give example.
Explain rename?
Define Transaction ?
Difference between the “verify” and “feedback” command?