Topics included triggers, indexes and sql tuning concepts and difference between union and union all.
Oracle Interview Questions
1,915 oracle interview questions shared by candidates
mostly ask on RAC and GG
Technical
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
General screening question
How do you read AWR and provide recommendation ?
Technical Interview didnt happen
What are the components of sql?
1. Describe the Multi-Org architecture in Oracle 2. Describe setups for warehouse defaulting in Oracle 3. Tell me about yourself 4. Tell me about a time you resolved a problem in project environment
Nothing as such. They asked me if I have experience to handle team
Viewing 1261 - 1270 interview questions
See Interview Questions for Similar Jobs
Oracle Solutions ArchitectCloud Di OracleConsultant OracleCloud ConsultantCloud ManagerOracle Principal ConsultantVirtualizationCloud ArchitectOracle Project ManagerOracle HrmsCloud AdministratorOracle Pl SqlConsultant Principal OracleConsultant CrmEnablementCloud OperationsAws Cloud ArchitectOracle Business Systems Analyst