Which two statements about the Process Monitor (PMON) process are true?

A. PMON performs process recovery when a client process fails.

B. During instance startup, PMON takes care of instance recovery.

C. PMON performs listener registration.

D. PMON restarts background and dispatcher processes when they fail.

E. PMON resolves failures of distributed transactions.

You execute some DMLcommands, followed by a COMMIT Statement. Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

A. 1. LGWR writes the commit record to disk.

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

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

2. LGWR writes the commit record to disk.

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

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

D. 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.

E. 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.

An Oracle instance is a combination of______.

A. database files and parameter file (initialization parameter file or server parameter file)

B. System Global Area (SGA) and background processes

C. a listener process, server processes, and background processes

D. System Global Area (SGA), server processes, and background processes

E. database files, System Global Area (SGA), and background processes

Which two statements are true about listeners?

A. Listeners use only the TCP/IP protocol.

B. Multiple listener processes can run simultaneously on a host.

C. Multiple database instances can be registered with a single listener,

D. Listener-related errors can be traced only at the administrative level.

E. Only one database instance can be registered with a single listener at any time.

Which database feature can be used for organizing data when there is a very large amount of data?

A. Index

B. Partitioning

C. Triggers

D. Row-level security

E. Database vault