1Z1-183 Exam Training Practice Tests (Oracle AI Database Administration Professional)]

Question 1

What happens when you run RESTORE DATABASE followed by RECOVER DATABASE in RMAN?

A. It restores the database to the latest available backup and applies redo to make it consistent B. It restores control files but not datafiles C. It restores only SYSTEM and SYSAUX tablespaces D. It automatically creates new standby redo logs

Correct Answer: A

Question 2

Which two tuning actions help reduce SQL execution cost?
(Choose two)

A. Gather optimizer statistics regularly B. Disable adaptive query optimization C. Disable SQL plan baselines D. Use bind variables instead of literals

Correct Answer: A,D

Question 3

What advantage does Flashback Database provide over traditional point-in-time recovery?

A. It allows rewinding the entire database quickly using flashback logs instead of restoring backups B. It replaces undo segments with archived redo C. It eliminates the need for any redo logs D. It creates guaranteed restore points automatically for every transaction

Correct Answer: A

Question 4

How does DBCA support database upgrades?

A. By skipping execution of post-upgrade scripts B. By disabling redo log archiving temporarily C. By providing a guided interface for direct database version upgrades D. By converting all non-CDBs to PDBs automatically

Correct Answer: C

Question 5

What is the key benefit of using PDB cloning for transport across different CDBs?

A. It eliminates the need for network services between source and target B. It automatically adjusts the character set without user intervention C. It enables cross-platform migration while maintaining application metadata integrity D. It copies data at the block level, bypassing tablespace checks

Correct Answer: C

Question 6

Which two actions can improve RMAN backup performance on a large database?
(Choose two)

A. Enable block change tracking B. Restrict memory usage by disabling compression C. Use multiple channels for parallel backup D. Disable redo log archiving during backup

Correct Answer: A,C

Question 7

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

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

Correct Answer: C

Question 8

Which two components can Oracle Restart automatically manage after a system reboot?
(Choose two)

A. AWR snapshots B. Database instances C. LogMiner sessions D. ASM instances

Correct Answer: B,D

Oracle AI Database Administration Professional - 1Z1-183 Exam Practice Test