Data Management
4 Questions
Study Guide: This page shows the correct answers and explanations for all questions in this topic.
Review these to understand the key concepts.
Question:
Which three statements are true about Automatic Diagnostic Repository (ADR)?
Correct Answer: A,D,E
- A. It is a file-based repository held outside any database.
- D. It can be used for the problem diagnosis of a database when that database’s instance is down.
- E. The ADR base is specified in the DIAGNOSTIC_DEST database parameter.
Explanation
A .True. ADR is a file system directory structure (e.g., /u01/app/orac le/diag), external to the database. B .False. ADR also stores diagnostics for non-database components (e.g., ASM, listener). C .False. It’s file-based, not schema-based. D .True. ADR logs (e.g., alert logs, trace files) are accessible even if the instance is down. E .True. DIAGNOSTIC_DEST sets the ADR base directory.
Question:
Which data dictionary view describes the data sources of external tables?
Correct Answer: A
- A. DBA_ALL_USER_EXTERNAL_LOCATIONS
Explanation
A .True. DBA_EXTERNAL_LOCATIONS (or prefixed variants) sh ows external table data sources (e.g., file paths). B-D .False. These views cover columns or tables but not external sources specifically.
Question:
Which two statements are true about the Automatic Diagnostic Repository (ADR )?
Correct Answer: C,D
- C. It supports diagnostics for Automatic Storage Management (ASM).
- D. It supports diagnostics for Oracle Clusterware.
Explanation
A .False. ADR is file-based, not in a schema. B .False. No such default exists. C .True. ADR logs ASM diagnostics. D .True. Supports Clusterware diagnostics. E .False. Defaults to $ORACLE_BASE or/u01/app/oracle if unset.
Question:
Which of the following statements is true about external tables?
Correct Answer: B
- B. They describe how the external table layer presents data to the server.
Explanation
A .False. External tables are read-only. B .True. Defines how external data (e.g., CSV) is mapped to SQL. C .False. Data is external, not in the DB. D .False. Storage is external; Oracle doesn’t define it.