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

Question 1

Which two steps are mandatory when transporting tablespaces across platforms with different endian formats?
(Choose two)

A. Export/import the control file with Data Pump B. Recreate redo log files on target platform C. Make tablespaces READ ONLY before backup D. Use RMAN CONVERT TABLESPACE to transform datafiles

Discussion 0

Correct Answer: C,D Vote an answer

Question 2

What differentiates an incremental level 1 cumulative backup from an incremental level 1 differential backup?

A. There is no difference; both back up changes since the last level 0 backup B. Cumulative backups capture only changed blocks from the last backup, differential captures entire database C. Differential backups reset the backup optimization counters, cumulative backups do not D. Cumulative backups capture changes since the last level 0, differential captures since last level 1

Discussion 0

Correct Answer: D Vote an answer

Question 3

What view provides information about active RMAN sessions and backup operations?

A. V$RMAN_STATUS B. V$RMAN_OUTPUT C. V$BACKUP_SESSION D. V$SESSION_LONGOPS

Discussion 0

Correct Answer: A Vote an answer

Question 4

Which two actions are required before unplugging a PDB for transport to another CDB?
(Choose two)

A. Close the PDB and generate its XML metadata file B. Execute DBMS_PDB.CHECK_PLUG_COMPATIBILITY on the source CDB C. Ensure the PDB is opened in READ WRITE mode D. Run ALTER PLUGGABLE DATABASE DISCARD TEMPFILE to clean tempfiles

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

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

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

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

Which two tools are part of the Real Application Testing option?
(Choose two)

A. Active Session History (ASH) B. LogMiner C. Database Replay D. SQL Performance Analyzer (SPA)

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

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

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which two measures enhance security isolation between PDBs?
(Choose two)

A. Defining PDB-scoped unified audit policies B. Converting all common users to local users C. Using Database Vault with PDB-specific realms D. Enabling automatic undo tablespace sharing

Discussion 0

Correct Answer: A,C Vote an answer