Online Access Free 1Z0-183 Exam Questions

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

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

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

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

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.Only PDB$SEED opens, as it is the default template PDB
• C.All user-created PDBs except PDB$SEED open in read-only mode
• D.The command fails because PDB$SEED cannot change open mode

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

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

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

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