Architecture

1.Which of the following does not affect the size of the SGA?

Ans: C

2.To clarify Oracle 10g.,which statement regarding the usage of redo log files during instance recovery is true?

A) Transactions are rolled back using redo log files.
B) Transactions are rolled forward using redo log files.
C) Transactions are rolled back using redo log files and archived log files.
D) Transactions are rolled forward using redo log files and rolled back using redo log files.

Ans: B

3.One of the user sessions was terminated abnormally in the middle of a transaction.What does Oracle database do to recover it?

A) Uses undo data for roll forward
B) Uses Flashback Log for recovery
C) Uses online redo logs to roll back
D) Uses undo data to roll back the transaction
E) Uses Recovery Manager (RMAN) to roll back
F) Uses the System Monitor (SMON) background process to perform instance recovery

Ans: D

4.Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

• A) PMON
• B) SMON
• C) MMNL
• D) MMAN
• E) MMON

Ans: D

admin November 24, 2014 Architecture Read more >