Ernst & Young Senior Consultant Interview Questions, Process, and Tips for Experienced

Query optimization techniques are used to improve the performance of database queries.

• Use indexes to speed up query execution

• Avoid using SELECT * and only select the necessary columns

• Optimize joins by using appropriate join types like INNER JOIN, LEFT JOIN, etc.

• Use WHERE clause to filter data before processing

• Consider denormalizing data for frequently accessed columns

Our automation framework is a modular, data-driven framework built using Selenium and TestNG.

• Modular design allows for easy maintenance and scalability

• Data-driven approach separates test data from test scripts

• Integration with Selenium for web automation and TestNG for test execution and reporting

• Supports parallel execution for faster test runs

• Custom reporting for detailed test results analysis

No, dropping the base table of a Materialized View does not automatically drop the Materialized View itself.

• Dropping the base table of a Materialized View will not automatically drop the Materialized View.

• The Materialized View will become invalid and will need to be manually dropped or recreated.

• Any attempt to refresh the Materialized View will fail until it is fixed.