Tag: databases

Questions Related to databases

What is the meaning status code GE?
technology databases

  1. End of database

  2. Segment not found

  3. Parentage not set

  4. Successful IMS call

Show answer
Correct Option: B

Which of the following components of Oracle architecture stores the statistics gathered by the MMON process?
technology databases

  1. ADDM

  2. AWR

  3. Data dictionary views

  4. Dynamic performance views

Show answer
Correct Option: B

Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?

technology databases

  1. OFF

  2. TYPICAL

  3. ALL

  4. BASIC

Show answer
Correct Option: D

Suppose you have used EM Database Control to drill down into ADDM findings and have found that a single SQL statement is causing the majority of I/O on your system. Which of the following advisors is best suited to troubleshoot this SQL statement?

technology databases

  1. SQL Tuning Advisor

  2. SQL Access Advisor

  3. Both A and B

  4. Neither A or B

Show answer
Correct Option: C

AI Explanation

To troubleshoot a SQL statement that is causing the majority of I/O on your system, you can use the SQL Tuning Advisor and the SQL Access Advisor.

Option A) SQL Tuning Advisor - This advisor is responsible for analyzing the SQL statement's execution plan and providing recommendations to improve its performance. It suggests potential changes to the SQL statement, such as creating or modifying indexes, restructuring the SQL statement, or gathering statistics. This advisor can help optimize the execution plan and reduce the I/O impact caused by the SQL statement.

Option B) SQL Access Advisor - This advisor focuses on recommending changes to the physical schema to optimize the performance of SQL statements. It suggests creating or modifying indexes, partitioning tables, or using materialized views to improve query performance. By optimizing the access paths and data retrieval methods, the SQL Access Advisor can help reduce the I/O impact caused by the SQL statement.

Option C) Both A and B - This option is correct because both the SQL Tuning Advisor and the SQL Access Advisor are suitable for troubleshooting the SQL statement causing I/O issues. By using both advisors, you can get comprehensive recommendations to improve the performance of the SQL statement and minimize its I/O impact on the system.

Option D) Neither A nor B - This option is incorrect because both the SQL Tuning Advisor and the SQL Access Advisor are relevant in this scenario. They provide valuable insights and recommendations to troubleshoot and optimize the SQL statement causing I/O issues.

Therefore, the correct answer is option C) Both A and B.

Nearly all the advisors submit their analysis activities to the database in the form of a job. When the analysis job is submitted, which option for job scope adds the least overhead to the system?

technology databases

  1. Limited

  2. Restricted

  3. Comprehensive

  4. Thorough

Show answer
Correct Option: A

Which data dictionary view contains information explaining why ADDM made its recommendations?

technology databases

  1. DBA_ADVISOR_FINDINGS

  2. DBA_ADVISOR_OBJECTS

  3. DBA_ADVISOR_RECOMMENDATIONS

  4. DBA_ADVISOR_RATIONALE

Show answer
Correct Option: D

Which of the following advisors determines if the space allocated to the Shared Pool, Large Pool, or Buffer Cache are adequate?

technology databases

  1. SQL Tuning Advisor

  2. SGA Tuning Advisor

  3. Memory Advisor

  4. Pool Advisor

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the different advisors in Oracle Database that help with tuning and optimization.

Option A) SQL Tuning Advisor - This option is incorrect because the SQL Tuning Advisor is responsible for analyzing individual SQL statements and suggesting improvements to their execution plans. It focuses on optimizing SQL query performance, not the allocation of memory within the database.

Option B) SGA Tuning Advisor - This option is incorrect because the SGA Tuning Advisor is responsible for analyzing the System Global Area (SGA) configuration and making recommendations for optimizing memory allocation for different components of the SGA, such as the Shared Pool, Large Pool, and Buffer Cache. However, it does not specifically determine if the space allocated to these areas is adequate.

Option C) Memory Advisor - This option is correct because the Memory Advisor is responsible for analyzing the memory usage within the database and making recommendations for the optimal allocation of memory to different components, including the Shared Pool, Large Pool, and Buffer Cache. It determines if the space allocated to these areas is adequate and suggests changes if necessary.

Option D) Pool Advisor - This option is incorrect because there is no specific advisor named "Pool Advisor" in Oracle Database. It is not responsible for determining the adequacy of space allocation in the Shared Pool, Large Pool, or Buffer Cache.

The correct answer is C) Memory Advisor. This option is correct because the Memory Advisor analyzes the memory usage and determines if the space allocated to the Shared Pool, Large Pool, or Buffer Cache is adequate.

Which of the following advisors determines if the estimated instance recovery duration is within the expected service-level agreements?

technology databases

  1. Undo Management Advisor

  2. SQL Access Advisor

  3. SQL Tuning Advisor

  4. MTTR Advisor

Show answer
Correct Option: D

Using EM Database Control, you’ve identified that the following SQL statement is the source of a high amount of disk I/O: SELECT NAME, LOCATION, CREDIT_LIMIT FROM CUSTOMERS What might you do first to try to improve performance?

technology databases

  1. Run the SQL Tuning Advisor.

  2. Run the SQL Access Advisor.

  3. Check the EM Database Control main screen for alerts.

  4. Click the Alert Log Content link in the EM Database Control main screen.

Show answer
Correct Option: A

Your users have called to complain that system performance has suddenly decreased markedly. Where would be the most likely place to look for the cause of the problem in the EM Database Control?

technology databases

  1. Main screen

  2. Performance screen

  3. Administration screen

  4. Maintenance screen

Show answer
Correct Option: B