Free Oracle 1Z1-183 Exam Dumps Questions & Answers

Which view provides a high-level summary of database wait events for identifying performance bottlenecks?

• A.V$SQL_PLAN
• B.V$SYSTEM_EVENT
• C.V$SESSION_EVENT
• D.V$SYSSTAT

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.Use RMAN CONVERT TABLESPACE to transform datafiles
• C.Make tablespaces READ ONLY before backup
• D.Recreate redo log files on target platform

Why must the RESETLOGS option be used when opening a database after incomplete recovery?

• A.It bypasses datafile header checks
• B.It preserves the SCN for the next recovery
• C.It merges temporary and permanent tablespaces
• D.It creates a new incarnation of the database and resets the redo sequence

Which command ensures that RMAN retains backups long enough for point-in-time recovery?

• A.CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
• B.CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
• C.CONFIGURE DEVICE TYPE TO FLASHBACK;
• D.CONFIGURE CONTROLFILE AUTOBACKUP ON;

How does Flashback Table differ from Flashback Database in terms of scope and impact?

• A.Flashback Table disables redo log application; Flashback Database enforces redo consistency
• B.Flashback Table reverts the entire database; Flashback Database affects a specific table
• C.Flashback Table operates at the object level; Flashback Database rewinds the entire database instance
• D.Flashback Table requires archive logs; Flashback Database uses only undo data