Knowledge Base

Latest Posts

Architecture

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

  • A) Database buffer
  • B) Redo log buffer
  • C) Stored procedure
  • D) Shared pool

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


 

 

 

 

 

Contact Us

DBA Technologies
Aditya Enclave, 303A, Nilgiri Block
Ameerpet, Hyderabad - India
Telephone: 040 6555 5689
Mobile: +91 944 11 72718
Email: training@dbatechnologies.net

Address 2:
3rd Floor, TMC Building
Dilsukhnagar, Hyderabad - India
Telephone: 040-24052718

Important Links

© 2014 DBA Technologies. All Rights Reserved. | Website Design by BWT