How to import a schema with out data ? How to import full backup with consitent ? how to import a schema into different tablespace ? How to take backup ( DP ) – using SCN number How to Verify how many nodes in oracle Steps for grid Installation ? Patch installation steps , how to verify patch installed or not ? What is golden gate ? rman datafile recovery ? what is control file, if control file is missing how you can recover ? What is SCAN IP ? How to Verify archive log gaps ?
Sharding and High availability
What do you think epsilon does?
1. Written Test 2. Interview: (Introduce yourself . . . followed by: ) a) Write fibonacci code b) Difference between: i) Struct, Union ii) Compiler, Interpretor iii) Processor, Controller c) What do you mean by OOP?
What is Concurrency? What are Software Metrics? What is the difference between cohesion and coupling? Explain the concept of modularization What is Data Flow Diagram? What is Software Configuration Management? What is the difference between Quality Assurance and Quality control? What is baseline in Software Development? What is SRS?
Basic PLSQL use cases like user defined exception, procedures and functions. Intermediate level sql queries
majorly focused on projects and internships and what was my role in those
NOt selected in the interview
I was asked multiple Database design questions and SQL queries based on the schemas designed. Other rounds comprised of Market estimation and business case questions.
How do you determine why the same stored procedure may run with different execution plans.
Viewing 2001 - 2010 interview questions