Topic : Distributed Databases

How can we reduce the network traffic?


Answer :

Replication of data in distributed enviroonment.
Using snapshots to replicate data.
Using remote procedure calls.

Show Answer Discuss

What happens when a user issues a COMMIT?


  • The CKPT process signals a checkpoint.
  • The DBWn process wrtes the transactions changed buffers to the datafiles.
  • The LGWR flushes the log buffer to the online redo log.
  • The ARCn process writes the change vectors to the archive redo log

Answer :

The LGWR flushes the log buffer to the online redo log.

Show Answer Discuss

Oracle does not consider a transaction committed until.


  • The Data is written back to the disk by DBWR
  • The LGWR successfully writes the changes to redo
  • PMON Process commits the process changes
  • SMON Process Writes the data

Answer :

The LGWR successfully writes the changes to redo

Show Answer Discuss

The status of the Rollback segment can be viewed through


  • DBA_SEGMENTS
  • DBA_ROLES
  • DBA_FREE_SPACES
  • DBA_ROLLBACK_SEG

Answer :

DBA_ROLLBACK_SEG

Show Answer Discuss

Explicitly we can assign transaction to a rollback segment


  • TRUE
  • TRUE

Answer :

TRUE

Show Answer Discuss