In a dataguard environment, say the primary database is having network issues and you failover to the standby database. Now the standby has become the new primary. Now if network issues were resolved on the old primary, how do you restore it and make it a physical standby ?
How do you diagnose slow query performance
External tables. Can they have indexes
Do you interested or not
Types of tables and views Def. Between functions and procedures Datatypes Cursor and loop Package Triggers Validate triggers
What does an Ora-1555 mean?
Cycle Counting, P2P Cycle, Inventory Implementation set ups etc.
What is the thing you like most about this company?
Materialized Views. Whether once can drop an MV, if yes then what will happen to its table. Types of MV. Grants and Privileges. Synonyms. Autonomous Transactions. Parallel Hints. Benefits of Packages. Performance Tuning.
what is your previous project experience .
Viewing 21 - 30 interview questions