Oracle AI Database Administration Professional - 1Z0-183 模擬練習

A. It diagnoses failures and provides recommended repair scripts

B. It scans archived redo logs for duplicate entries

C. It automatically repairs all detected corruption without user approval

D. It only reports block corruption for datafiles in the SYSTEM tablespace

A. To disable adaptive query optimization features

B. To ensure the optimizer uses only known, verified execution plans

C. To lock execution plans for a fixed period

D. To dynamically change SQL text at runtime

A. Convert the datafiles using RMAN CONVERT

B. Disable redo log archiving during transport

C. Drop all user tablespaces before conversion

D. Enable Data Guard before transport

A. It eliminates the need for network services between source and target

B. It copies data at the block level, bypassing tablespace checks

C. It enables cross-platform migration while maintaining application metadata integrity

D. It automatically adjusts the character set without user intervention

A. Cluster resources like listeners, ASM instances, and services

B. Network topology for standby databases

C. Automatic Memory Management components

D. Optimizer statistics synchronization

A. Enabling block change tracking

B. Opening the database with RESETLOGS

C. Creating a new password file

D. Running CATPROC.SQL to recompile PL/SQL packages

A. It manages redo log files directly

B. It automatically encrypts all backups

C. It replaces the need for archived redo logs

D. It stores backup metadata permanently, whereas control file records may be overwritten

A. Gather optimizer statistics regularly

B. Disable adaptive query optimization

C. Disable SQL plan baselines

D. Use bind variables instead of literals