Performance Engineering Interview Questions #5

Performance Engineering Interview Question 5

Following are the Performance Engineering Interview Questions Set #5. Q. 21 What is PGA? Ans: Program Global Area or PGA is a non-shared memory area used for the server process. PGA is only read and written by Oracle code acting on behalf of that process and used for operations like sorting and hashing. There is … Read more

Performance Engineering Interview Questions #4

Performance Engineering Interview Questions #4

Following are the Performance Engineering Interview Questions Set #4. Q. 16 What is the significance of the ‘Execution Plan’? Ans: The execution plan provides details about the data fetching operation. It describes how the data is fetched from the database by the SQL statement. It explains the operations like table scans, index scans, joins etc. … Read more

Performance Engineering Interview Questions #3

AWR - Performance Engineering Interview Questions

Following are the Performance Engineering Interview Questions Set #3. Q. 11 How to identify SQL statements consuming the most CPU resources in the Database? Ans: Fetch/Extract the AWR report for the problematic period, go to the section ‘SQL Statistics’ and then click the ‘SQL Ordered by CPU Time’ link. This will take you to the … Read more

Performance Engineering Interview Questions #2

Performance Engineering Interview Question 2

Following are the Performance Engineering Interview Questions Set #2. Q. 6 What is an AWR? Ans: The full form of AWR is Automatic Workload Repository. It is a built-in repository in the Oracle database that collects, processes and maintains performance statistics. AWR captures data on system load, wait events, SQL execution and more at regular … Read more

Performance Testing & Engineering Interview Questions

Performance Testing & Engineering Interview Questions

These Performance Testing and Engineering Interview Questions may act as a booster for a fresher to grab quickly the basic understanding of performance testing, testing tools and engineering concepts. For an experienced performance tester or engineer, these interview questions will help to recall the basics that they have already learned. Following are the Interview Questions: … Read more

Performance Engineering Interview Questions #1

Performance Engineering Interview Questions #1

Following are the Performance Engineering Interview Questions Set #1. Q. 1 What is Software Performance Engineering? Ans: Performance engineering is a systematic way of following the best practices and applying techniques in all stages of the software development life cycle (SDLC) to ensure that the final product is fast, responsive, scalable and appropriately optimized. Read … Read more