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.
none. please note this was for an experience position.
Why are you changing the Job
Can you walk me through the process to void checks?
Why did you choose your degree?
Tell us something about your thesis during college
What is oracle different from another database
PLSQL SQL P2p, o2c, Interface and Report
Viewing 1361 - 1370 interview questions