Oracle Updated 1z0-497 Exam Questions and Answers by kiyaan

The database advances a checkpoint.

A client process commits a transaction.

The redo log buffer becomes full.

A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

A tablespace is changed to read-only status.

The database is shut down in immediate mode.

1. LGWR writes the commit record to disk.

2. LGWR writes all redo entries from Redo Log Buffer to disk.

1. GWR writes only the transaction's redo entries from Redo Log Buffer to disk.

2. LGWR writes the commit record to disk.

1. LGWR puts the commit record to Redo Log Buffer.

2. IGWR writes all redo entries from Redo Log Buffer to disk.

1. LGWR puts the commit record to Redo Log Buffer.

2. If the activity is high, LGWR waits three seconds for other transactions to commit.

3. LGWR writes all redo log entries from Redo Log Buffer to disk.

1. LGWR puts the commit record to Redo Log Buffer.

2. LGWR signals the database writer (DBW) process to write dirty blocks to disk.

3. LGWR writes all redo entries from Redo Log Buffer to disk.

database backup and recovery using RMAN

performance tuning operations such as generation of AWR, ADDM, and ASH reports

storage configuration for archive logs and control files

storage configuration for data files and redo log groups

database status view and Data Pump export and import jobs

cluster

database link

mapping table

materialized view