Informatica Interview Questions & Answers (Database)

<<Previous:Informatica Interview Questions & Answers1(Informatica)

• 1. What is difference between “having” clause and “where” clause in oracle?

  2. Write a query to display top 3 high pay salaries employees from a emp table?

  3. Write a query to display average salary of top 4,5 and 6.

  4. Oracle external table

  5. What is difference between functions and procedures?

  6. What are cursors, indexes (types of indexes and where we can use), triggers (type of triggers), partitions, clusters, exceptions, packages and sequence in oracle.

  7. What is the logic will you implement to load data into a fact table from a dimension tables?

  8. How many cursors u can run at a time?

  9. Can u use a trigger in a trigger?

  10. How can u improve performance of queries in oracle?

  11. What is difference between surrogate key, natural key and primary key?