Distributed Databases   «Prev  Next»

Using Updateable Snapshots - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is true about the ROWID snapshot log format?
Please select all the correct answers.
  A. ROWID snapshot logs can only be used with Oracle7.
  B. ROWID snapshot logs can be used in Oracle.
  C. ROWID snapshot logs are the default in Oracle.
  D. ROWID snapshot logs are an older method than primary key snapshot logs.
  E. Using the FOR UPDATE clause in the snapshot definition
  F. Using the ROWID snapshot method
  G. Using snapshots with sub queries
  H. Using the snapshot as a part of a snapshot group

2. Which of the following features has been enhanced in Oracle to support propagation to remote databases?
Please select the best answer.
  A. ROWID snapshots
  B. Advanced Queuing
  C. Data dictionary views
  D. Multimaster replication

3. What is an advantage to using updateable snapshots?
Please select the best answer.
  A. There is no chance of two users changing the same row in different sites.
  B. Users do not need privileges to update a snapshot.
  C. Updates can be made to a table even if the connection to the master site is down.
  D. Updates to snapshots take less time than updating master tables.