Oracle AI Database Administration Professional - 1Z1-183 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

When executing an incomplete recovery using RMAN, which additional step is mandatory after applying archived redo logs?

A. Creating a new password file B. Enabling block change tracking C. Running CATPROC.SQL to recompile PL/SQL packages D. Opening the database with RESETLOGS

Discussion 0

Correct Answer: D Vote an answer

Question 2

What utility is used with RMAN to perform cross-platform transport of tablespaces between systems with different endian formats?

A. LogMiner B. Transportable Database C. Data Pump D. RMAN CONVERT TABLESPACE

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which command ensures that RMAN retains backups long enough for point-in-time recovery?

A. CONFIGURE DEVICE TYPE TO FLASHBACK; B. CONFIGURE CONTROLFILE AUTOBACKUP ON; C. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; D. CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

Discussion 0

Correct Answer: C Vote an answer

Question 4

Which two actions are required to enable the In-Memory Column Store?
(Choose two)

A. Disable redo log archiving B. Set the INMEMORY_SIZE initialization parameter C. Mark objects with the INMEMORY attribute D. Enable DB_CACHE_SIZE to maximum

Discussion 0

Correct Answer: B,C Vote an answer

Question 5

What differentiates active database duplication from backup-based duplication in RMAN?

A. Backup-based duplication cannot use compression B. Active duplication copies data over the network directly from the source instance C. Active duplication requires a recovery catalog; backup-based duplication does not D. Active duplication requires no listener configuration

Discussion 0

Correct Answer: B Vote an answer

Question 6

How does Oracle Database 23ai enforce security isolation between different PDBs within the same CDB?

A. By automatically encrypting all cross-PDB links without user configuration B. By ensuring each PDB has its own data dictionary and schemas isolated from others C. By using a separate data dictionary and undo tablespace for each PDB D. By sharing the SYSTEM and SYSAUX tablespaces across all PDBs

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which configuration change can improve RMAN backup performance for large databases?

A. Disabling block change tracking B. Increasing the number of RMAN channels for parallelism C. Using archivelog-only backups exclusively D. Enabling backup compression at BASIC level

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which two features are provided by AWR baselines?
(Choose two)

A. Auto-generation of redo log switch alerts B. Retention of historical performance data for defined periods C. Comparison of current performance metrics against a known workload D. Automatic optimizer statistics gathering

Discussion 0

Correct Answer: B,C Vote an answer