Question: Please answer in 500 - 600 words words, APA format with references
Must meet the requirements and write min 500 words with at least two references for EACH question.
1. A: Would SQL queries lead to performance bottlenecks in an Oracle Database and how would you eliminate this problem?
B: Provide an example of a complex SQL statement (one which joins multiple tables, uses aggregate functions or subqueries) and review the process in which you would examine the performance of the SQL statement as well as how you would adjust the statement.
2. Memory and tuning What has memory and I/O have to do with tuning of an Oracle Database? Please explain.