bind variables dynamic sql external table views mviews query to sum up pesudo columns virtual coulmns packages and advantages truncate delete exists in merge joins clustered index partitions interval partitioning puring partition loaders schema used in DB design diff between olap oltp scd collections bulk collect ref cursor unique key and primary key if base table is not present can we build the view corelated and subquery how to redirect o/p of the command in shell script
mostly they asked me the issues i faced and did not have any technical questions for me that much they were asking about pl/sql develpment
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.
que animal eres? donde te ves en 5 años
Preguntas técnicas sobre hcm Cloud
RMAN. EXPDP, IMPDP, Goldengate, RAC
They only ask DLL and String conversion
What is difference btw ETL and ELT?
Asked about my project experience and subject specific areas and educational details
Configuration steps for Data Guard.
Viewing 1351 - 1360 interview questions