how to approach a query for performance tuning ?
Consultant Oracle Interview Questions
1,923 consultant oracle interview questions shared by candidates
I wasn't asked this question but it came up. With an Internet facing application, it would make more sense to move from single node databases to clustered databases. A single node Oracle database has to be shutdown to perform upgrades and some patches. With an Oracle RAC cluster , rolling upgrades can be performed while still maintain 100 percent uptime. It seems management is favorable to this move but it just doesn't seem to be a priority.
Tell us something about your thesis during college
Decode function in SQL , journal creation process...
Describe my projects How proficient I am in MySQL General questions about ERP
one of the senior manager attended in technical interview and he is continuously throwing unnecessary questions in between technical discussion. and he was not happy with my career gap that was only 8 months.
About modules, scenarios , experience, Documentation
Sql queries
none. please note this was for an experience position.
Function in SQL nvl,nvl2 and coalesce lookups and valuesets
Viewing 1341 - 1350 interview questions