Online Access Free 1Z0-183 Practice Test

Which two items must be available to perform a complete recovery of a database using RMAN?
(Choose two)

• A.Block change tracking file
• B.Latest control file
• C.Recovery catalog only
• D.All archived redo logs

What is the effect of issuing ALTER PLUGGABLE DATABASE ALL OPEN READ ONLY;?

• A.All PDBs in the CDB are opened in READ WRITE mode
• B.The command fails because PDB$SEED cannot change open mode
• C.Only PDB$SEED opens, as it is the default template PDB
• D.All user-created PDBs except PDB$SEED open in read-only mode

What is the purpose of SQL Performance Analyzer (SPA)?

• A.To identify optimizer parameter changes
• B.To adjust SGA components dynamically
• C.To predict the impact of database changes on SQL performance
• D.To capture and replay real application workloads

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

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

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

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