1Z1-183 by Oracle Valid Free Exam Practice Test

Question 1

Which two statements are true about PDB lifecycle management?
(Choose two)

A. MOUNT is the default state when a PDB is created B. PDB states are persisted automatically without explicit SAVE STATE C. Dropping a PDB can optionally keep its datafiles for reuse D. PDB$SEED can be opened in READ WRITE mode for patching

Correct Answer: A,C

Question 2

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

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

Correct Answer: A

Question 3

Which feature allows RMAN to skip backing up unchanged blocks when using incremental backups?

A. Crosscheck B. Block change tracking C. Flashback logging D. Backup compression

Correct Answer: B

Question 4

Which two actions help troubleshoot slow RMAN backups?
(Choose two)

A. Reduce the number of channels to a single stream B. Review RMAN backup compression settings C. Check I/O bottlenecks on backup destinations D. Disable block change tracking

Correct Answer: B,C

Question 5

What is the recommended approach for tuning the buffer cache size?

A. Use Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) to let Oracle manage memory dynamically B. Increase DB_BLOCK_SIZE for better caching C. Increase cache size until the library cache hit ratio exceeds 99% D. Disable automatic memory management and use manual tuning only

Correct Answer: A

Question 6

Which tool is recommended for pre-upgrade checks before upgrading to Oracle Database 23ai?

A. SQL*Loader B. LogMiner C. AutoUpgrade utility D. RMAN Validate

Correct Answer: C

Question 7

When transporting a database across platforms with different endian formats, what step is mandatory?

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

Correct Answer: A

Question 8

Which step is required when creating a Container Database (CDB) using Database Configuration Assistant (DBCA) with the intention to host multiple Pluggable Databases (PDBs)?

A. Skip root and seed creation to save space for future PDBs B. Create separate SYSTEM tablespaces for each seed database C. Disable Oracle Managed Files to manually configure datafiles D. Select the "Create as Container Database" option and specify the number of PDBs

Correct Answer: D

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