Distributed Databases   «Prev  Next»

Oracle Replication Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which conceptual model might allow a hacker to gain access to a master site from a remote site?
Please select the best answer.
  A. Updateable snapshots
  B. Trusted snapshot security
  C. Deferred constraints
  D. Untrusted snapshot security

2. Which two privileges are given to the user whose function is the "refresher?"
Please select all the correct answers.
  A. ENQUEUE ANY QUEUE
  B. ALTER ANY SNAPSHOT
  C. CREATE ANY SNAPSHOT
  D. PROPAGATE ANY SNAPSHOT
  E. BLOB
  F. CLOB
  G. BFILE
  H. NCLOB

3. What is the best description of rows in the V$EVENT_NAME view where the NAME column is equal to "queue messages"?
Please select the best answer.
  A. A session is waiting for a message to arrive in its queue from Advanced Queuing.
  B. A replication session is waiting to dequeue an event.
  C. A snapshot is waiting to refresh its rows.
  D. A queue is waiting for new messages to arrive.