MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is replication support used for? |
| A. | Perform certain administrative tasks on objects in a replication group |
| B. | Database performance tuning |
| C. | Detect and resolve conflicts |
| D. | All of above |
| Answer» D. All of above | |
| 2. |
By default which refresh on a snapshot is performed by Oracle? |
| A. | Fast refresh |
| B. | Complete refresh |
| C. | Automatic refresh |
| D. | Attempts fast refresh, if it cannot be preformed server performs a complete refresh |
| Answer» E. | |
| 3. |
Oracle creates an index for the _____________ in the snapshot base table. |
| A. | Primary key |
| B. | Foreign key |
| C. | Super key |
| D. | Both a and c |
| Answer» B. Foreign key | |
| 4. |
Which of the following is a type of replication? |
| A. | Update replication |
| B. | Read-only materialized views |
| C. | Multi replication |
| D. | All of the above |
| Answer» C. Multi replication | |
| 5. |
What needs to be done to perform a fast refresh? |
| A. | The server that manages the snapshot executes the snapshot's defining query |
| B. | Query should replace the existing snapshot data to refresh the snapshot |
| C. | The server that manages the snapshot first identifies the changes that occurred in the master since the most recent refresh of the snapshot and then applies them to the snapshot |
| D. | Create a snapshot log for the table so that fast refreshes of the snapshots are an option |
| Answer» D. Create a snapshot log for the table so that fast refreshes of the snapshots are an option | |
| 6. |
Which one of the following way is correct to turn ON replication? |
| A. | DBMS_REPUTIL_REPLICATION=ON |
| B. | DBMS_REPUTIL.REPLICATION=ON |
| C. | DBMS_REPUTIL.REPLICATION_ON |
| D. | All of the above |
| Answer» D. All of the above | |
| 7. |
Which of the following is / are DML Statements? |
| A. | Insert |
| B. | Update |
| C. | Create |
| D. | Both A and B |
| Answer» E. | |
| 8. |
A _______________ is a collection of one or more replicated objects (typically tables) that are administrated together. |
| A. | Replica |
| B. | Replica group |
| C. | Replication |
| D. | Replication group |
| Answer» E. | |
| 9. |
Which of the following object types cannot be replicated? |
| A. | Data |
| B. | Trigger |
| C. | View |
| D. | Sequence |
| Answer» E. | |
| 10. |
Advance data replication is useful to which types of Application Systems? |
| A. | Disconnected Environments |
| B. | Failover Site |
| C. | Distributing Application Loads |
| D. | All of the above |
| Answer» E. | |
| 11. |
What do you mean by Quiescence? |
| A. | Act of suspending DML activity for all tables in a given replication group |
| B. | Act of suspending DML activity for selected tables in a given replication group |
| C. | Act of granting DML activity for selected tables in a given replication group |
| D. | Act of granting DML activity for all tables in a given replication group |
| Answer» B. Act of suspending DML activity for selected tables in a given replication group | |
| 12. |
For each replication group there should be ____ master definition site |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 5 |
| Answer» B. 2 | |
| 13. |
Which site supports simple read-only and updatable snapshots of the table data at an associated master site? |
| A. | Snap site |
| B. | Replication Catalog |
| C. | Replication groups |
| D. | Snapshot site |
| Answer» E. | |