Which two Oracle database space management features require the use of locally managed tablespaces?
Correct Answer: B,E
A .False. Works with DMTs too. B .True. LMTs use bitmaps, unlike DMT freelists. C .False. OMF is independent of management type. D .False. Alerts work with both. E .True. Shrink requires LMTs with ASSM.
1Z0-182 Exam Question 27
Which three statements are true about Automatic Diagnostic Repository (ADR)?
Correct Answer: A,D,E
A .True. ADR is a file system directory structure (e.g., /u01/app/oracle/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.
1Z0-182 Exam Question 28
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
Correct Answer: C,D
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.
1Z0-182 Exam Question 29
Which two statements are true about Fine-Grained Auditing (FGA)?
Correct Answer: C,E
A .False. Schema owners need EXECUTE on DBMS_FGA. B .False. Not limited to SYSDBA. C .True. AUDIT_ADMIN includes FGA creation rights. D .False. No such role exists. E .True. DBMS_FGA.ADD_POLICY requires this privilege.
1Z0-182 Exam Question 30
Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?
Correct Answer: C,D
With OMF enabled, Oracle automatically manages file creation. The command ALTER TABLESPACE sales_q1 ADD DATAFILE without a file specification relies on initialization parameters: A . Specify a path in the DATAFILE clause ... with at least 100 MB of available space.False. With OMF, explicitly specifying a path overrides OMF behavior, but it's not required for success if OMF parameters are set correctly. B . Add the AUTOEXTEND ON clause with NEXT set to 100M.False. AUTOEXTEND is optional and affects file growth, not the initial creation success, which depends on available space in the OMF location. C . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.True. If both parameters are set,Oracle may use either for data files (depending on context), and sufficient space (e.g., 50 MB minimum for a smallfile) ensures success. D . Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.True. This is the primary OMF parameter for data files; sufficient space (typically 100 MB minimum for a new file) guarantees the command succeeds. E . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.False. This is redundant with C; only one needs sufficient space, though C's phrasing makes it a valid independent action.
